Hi All
I have morethan 80000 rows of data and i will filter some criteria and after filteration no.of rows contains morethan 20000, so when i am trying to delete that all rows its not deleting its giving error.
Is there any way fastest way to delete that much of rows...
Thanks
Naveed Raza
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
What is the error message you get?
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
when i am trying to delete morethan 25000 rows of data its giving message .
Pleae find the attached error msg image
Never encountered that before...
I presume you are filtering data, then trying to delete entire rows. Reading the error message, it may be worth trying to sort your data by the field on which you are filtering first, so that the range to be deleted is a contiguous row selection.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks