Any tips on why my file size has grown to massive proportions, and what might I be able to do about it?
My xlsm file has grown to 72 mb in a matter of days. There are 5 macro's, only two of which are semi complete, 6 sheets, none of which are more than 300 rows, and 5 or 6 excel generated buttons on the first sheet.
Not sure where all this storage requirement is coming form?
Still learning... one day I will be able to help!
Hi,
Maybe you are using all the rows in on or many sheets. Even if there is no data in it, Excel will "count" them.
Try resetting the last used cell in your worksheets.
See here:
https://support.office.com/en-au/art...8-b3c1d86e99e9
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
That's better, back down to 3 mb!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Graham Pall 
Register To Reply
Bookmarks