File size increased 7-fold!

[bman342]

My file size was about 480kb. I then added a couple of additional macros
(maybe about 5 more, relatively short), and added some conditional
formatting. Suddenly the file size jumped to an unwieldy 3.8mb!

Half a meg was kind of large, 3.8mb is almost unusable. Any suggestions?
Thanks.

 

[Gord Dibben]

Probably needs the used ranges on each sheet reset

See Debra Dalgleish's site for info.

http://www.contextures.on.ca/xlfaqApp.html#Unused



Gord Dibben MS Excel MVP

 

[bman342]

Interesting, thanks. I have four different worksheets in this WB. Sure enough
one of the worksheets had the scroll setting all the way to the bottom row.
After trying some of her manual resets, I just copied the file under a
different filename and deleted the suspected culprit WS, and that worked.
Luckily it's a fairly simple sheet to redo.

 

[Gord Dibben]

Happy to hear you're sorted.

Now.........to find out why the increase in size<g>


Gord