Slow Load & Save with no data to speak of.
I have a spreadsheet that I have done VBA work with and the workbook except for the formatting is basicly blank but it shows 142 M file size. The used range is A1:H52 and 13 sheets and that is it.I have unloaded the Module and it is still almost that big! Any thoughts?
Last edited by EdCreated; 06-04-2011 at 05:16 PM. Reason: Wrong area posted
Hi,
Have you checked the used range on each of the 13 sheets with End Home?
In my experience of several similar requests the user has generally found that a cell vale/formula has been copied to the last row.
When you say the formatting is 'basically' blank what exactly do you mean?
Regards
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Re: Slow Load & Save with no data to speak of.
Thanks for the reply Richard,
Yestersday I went ahead out of frustration and deleted 2 worksheets that showed by way of the horizontal and vertical bars that they were excessive. That knocked it down from 142M to 35 which is MUCH BETTER! As far as your suggestion, there where no formulas outside of my work area.
The format I referred to was the interior color of the cells done in altenating orange and white.
Thanks again Richard.
Ed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks