File Size With Macros Has Increased From Its Origina Size

  • Thread starter Thread starter Fred
  • Start date Start date
F

Fred

I have a spreadsheet with a few macros that I open and execute about several
times a day for the past year. I noticed that the file size increased from
less than 100 bytes to 5 MB. There has been no increase in the cells and/or
macros.
The macros include moving/deleting cells. These are repetitive macros that
has to be executed hourly.

Is there any explanation for this? Is there a way to "optimize" (defrag?)
this file?
 
Could be your macros are steadily increasing your file size due to what Excel
thinks is an increase in the used ranges of worksheets.

See Debra's site for re-setting the "used range" of worksheets in workbooks.

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

Don't forget the "Save" part.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Do macros in Excel increase file size? 4
macros and file size 3
Size of file grows 4
File Increase in size 7
File size increase 1
File Size 3
file size increases drmatically 1
Workbook size 2

Back
Top