Help Needed

  • Thread starter Thread starter Anonymous1
  • Start date Start date
A

Anonymous1

I have a weekly report that's now 4 MBs. While it has
links within it, etc., I've made no special changes to it
for 2 weeks. At that point it was 2 MB. Prior to that
I'd added a sheet which caused it to increase in size
from 1 MB to 2 MB. Whenever I save it for use in the
upcoming week, I use "Save As".
If I copy this document to Version 2, delete the first 13
of 14 sheets, insert a blank sheet, and then delete the
the sheet I'd been using, I'm left with one blank sheet,
which I don't touch. Somehow, it's property size is 3.54
MB (for the blank sheet) which I've Saved As something
else.
Can anyone help?

Thanks!
 
TRY
tools/options/calculations tab, deselect "Save external link values"
then save, close & see file size.
HTH
Bob Umlas
Excel MVP
 
Back
Top