• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Actual Last row needed

R

Raghava@rock

Member
Hi ,

I have Xlsb file where by mistake i have updated formula in a column to last row ( 1048576) and saved it . Now i am trying to reset to actual end last row 1456 .

While i am deleting row , excel gives me error saying that "Excel cannot complete the task with available resources. Choose less data or close applications." Which i tried but no luck.

Request you to help me with this regard.
 
Hi ,

If the file size is less than 1 MB , can you upload the workbook ?

If not , try deleting a lesser number of rows at a time ; since you say your last row of data is row 1456 , first try deleting the rows 1000001 to 1048576 ; if this works , save the file.

Reopen the file , and see where the last used cell is now pointing to , by pressing CTRL END and seeing where the cursor is placed.

Narayan
 
You must log in or register to reply here.
Back
Top