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