Solved

Excel Used Range and Last Cell STILL Inaccurate

Posted on 2011-09-21
5
213 Views
Last Modified: 2012-05-12
Cell IV65536 is registering as the last used cell in the range, which is obviously wrong for me.  (It's just a few rows and columns of data.)

However, it obviously is making my file HUGE and SLOW!

I've tried deleteing the columns and rows around the data, using the Edit>Clear>All command, and even some VBAs in other solutions to clear up this mess.

BUT, still, nothing works (yes, I saved, closed, and re-opened the file only for it not to work still).

Any other ideas?
0
Comment
Question by:HaimD
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 19

Assisted Solution

by:regmigrant
regmigrant earned 250 total points
ID: 36575031
The best solution I ever found for this was a set of utilities called ASAP - I'm not connected with them and I wont post a link but I can recommend it for this and similar problems
0
 

Author Comment

by:HaimD
ID: 36575039
If I find it, I'll let you know.  Thanks
0
 
LVL 81

Expert Comment

by:byundt
ID: 36575140
I normally Delete (rather than Clear) the rows and columns that lie beyond the data. Since IV65536 is marked as the last cell, make sure that you deletions extend both row-wise and column-wise to that cell.

If that still doesn't work for you, could you post your workbook?
0
 
LVL 81

Accepted Solution

by:
byundt earned 250 total points
ID: 36575168
You can download the ASAP Utilities package suggested by regmigrant from http://www.asap-utilities.com/
0
 

Author Closing Comment

by:HaimD
ID: 36575951
The function in the Add-In worked!  Great!  :)
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question