Hi, i have an excel file which is 20MB. It has lots of tabs and is quite manual to produce each month.
I created a new worksheet and created some macros to automate some of the manual steps - i.e unhide all sheets, copy and paste data to other parts of the report, refresh all pivots etc..
the file size has increased to 34MB by adding one sheet - why would this be?
It is called file bloat and the problem is well known.
Here's one message about that.
There could be several circumstances causing the problem. Search is your friend.
Good luck!
David
(*) Reputation points appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks