Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Mark
 
Posts: n/a
Default Controlling Workbook File Size?

I have a workbook that has recently increased from 5meg to 30 meg. There are
no pivot tables -- only a couple small macros that involve a few lines of
vba. What could have caused the jumped.. and what can I do to fix it?
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Just guesses...

The last used cell on each worksheet is way past where you think it should be.
See Debra Dalgleish's site to reset this last used cell.

http://www.contextures.com/xlfaqApp.html#Unused

Any chance you have objects (pictures/buttons/textboxes) in your workbook?

Sometimes pictures get duplicated by error.

Mark wrote:

I have a workbook that has recently increased from 5meg to 30 meg. There are
no pivot tables -- only a couple small macros that involve a few lines of
vba. What could have caused the jumped.. and what can I do to fix it?


--

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:50 AM.

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"