Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
EstherJ
 
Posts: n/a
Default Size (mb) of sheets in file

Is there any way of finding out the mb size of individual sheets within a
workbook. I can only view the size of the file as a whole by going to File
and then Properties and General

Thanks,

Esther
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

No better than an estimate...

Make a copy of your workbook.
open that copy
delete a worksheet
save that copy
compare the size of the original workbook with that copy.

Repeat as necessary.



EstherJ wrote:

Is there any way of finding out the mb size of individual sheets within a
workbook. I can only view the size of the file as a whole by going to File
and then Properties and General

Thanks,

Esther


--

Dave Peterson
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
Large Excel file size caused by a bug ? I really tried everything Anik Excel Discussion (Misc queries) 5 March 16th 05 06:19 PM
Deleted all images but file size still too big!! ka Excel Discussion (Misc queries) 1 February 2nd 05 12:49 PM
Excel file size increased Akheel Excel Discussion (Misc queries) 2 January 29th 05 05:18 PM
Importing .txt data files increases .xls file size BrianJ Excel Discussion (Misc queries) 1 January 29th 05 02:02 PM
Workbook and sheets have disappeared but file can open Jacktion Excel Discussion (Misc queries) 4 January 27th 05 02:11 PM


All times are GMT +1. The time now is 06:55 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"