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

--
Matt Lynn

Message posted via http://www.officekb.com

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
--
HTH...

Jim Thomlinson


"Mattlynn via OfficeKB.com" wrote:

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

--
Matt Lynn

Message posted via http://www.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 Thomlinson wrote:
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

[quoted text clipped - 10 lines]
Many Thanks
Matt

--
Matt Lynn

Message posted via http://www.officekb.com