File Size

  • Thread starter Mattlynn via OfficeKB.com
  • Start date
M

Mattlynn via OfficeKB.com

Hi all

I have a spreadsheet with some pivots, graphs, and lookup formulae etc.
The file was 90MB, to start with (Its a big file).
I decided to save before i closed, although i made no changes, and it resized
it to 208MB.

Any ideas??

Is there a way, i can find out sizes per tab, to see where the massive hike
in size came from.


Many Thanks
Matt
 
J

Jim Thomlinson

There is no way to determine the memory usage of a sheet or such without
removing the sheet from the spreadsheet. It is kind of like trying to figure
out what your arm weighs. Short of taking your arm off it is hard to know.

One thing to look for is initialized cells that are blank. If you can drag
your scroll bars well past the end of the data then you have blank cells
stored in memory. Pivot tables are good for doing that. Check out this link
to remove the blank cells from memory...

http://www.contextures.com/xlfaqApp.html#Unused
 
M

Mattlynn via OfficeKB.com

Hi Jim
Thats a great technique - although it didnt work.
looks like its back to option 1 then. I have done this in the past, but i was
hoping for a more automated way, but hey, many thanks for your help anyway.

Cheers
Matt



Jim said:
There is no way to determine the memory usage of a sheet or such without
removing the sheet from the spreadsheet. It is kind of like trying to figure
out what your arm weighs. Short of taking your arm off it is hard to know.

One thing to look for is initialized cells that are blank. If you can drag
your scroll bars well past the end of the data then you have blank cells
stored in memory. Pivot tables are good for doing that. Check out this link
to remove the blank cells from memory...

http://www.contextures.com/xlfaqApp.html#Unused
Hi all
Click to expand...
[quoted text clipped - 10 lines]
Many Thanks
Matt
Click to expand...
Click to expand...
 
Top