#1   Report Post  
aroe
 
Posts: n/a
Default file size

How can I determine what is taking up so much memory in my excel workbook?
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

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?



  #3   Report Post  
Chip Pearson
 
Posts: n/a
Default

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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel file size Eric Excel Discussion (Misc queries) 3 February 25th 05 01:13 PM
File asks to update when no links were created Dave Links and Linking in Excel 1 December 16th 04 08:10 PM
File Size Jus Excel Discussion (Misc queries) 1 December 6th 04 01:09 PM
File is locked for Editing by user problem Mirth Excel Discussion (Misc queries) 1 December 3rd 04 04:45 PM
format question when open csv file Jeff Excel Discussion (Misc queries) 1 December 1st 04 06:53 PM


All times are GMT +1. The time now is 12:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"