file size
 

How can I determine what is taking up so much memory in my excel workbook?

Hi
try the following:
http://www.contextures.com/xlfaqApp.html#Unused
and see if this helps

--
Regards
Frank Kabel
Frankfurt, Germany

aroe wrote:
How can I determine what is taking up so much memory in my excel
workbook?

Try code like the following:

MsgBox FileLen(ThisWorkbook.FullName)

This requires that the files be saved to disk at least once.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"aroe" wrote in message
...
How can I determine what is taking up so much memory in my
excel workbook?