Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default Workbook size

Typically it has to do with your used range getting messed up. As a guess on
one or more of your sheets your scroll bars allow you to drag the scroll
handle well past the end of your data. Here is a link on fixid the used
range...

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

Jim Thomlinson


"Sri Harsha" wrote:

Hi,
I've created a workbook that captures the daily work done by my team. I had
a similar one before and the new one is more than 11 MB in size. The old one
was less than 1 MB.

To make the changes, i just copied the existing one and formatted according
to the new requirements. I want to know the reason behind huge increase in
the file size...

Regards,
Sri Harsha.

 
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
Workbook size Deb G Excel Discussion (Misc queries) 3 March 8th 08 10:39 PM
Workbook size Mike D. Excel Discussion (Misc queries) 1 December 16th 07 11:37 PM
can i size an Excel workbook window's opening size? ncjenny Excel Discussion (Misc queries) 0 November 12th 06 04:03 PM
My workbook links are not updating (its 30,000 KB size workbook). rselena Excel Discussion (Misc queries) 1 August 14th 06 09:14 PM
Size of a Workbook Basharat A. Javaid Excel Discussion (Misc queries) 2 July 4th 05 07:47 PM


All times are GMT +1. The time now is 11:46 PM.

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

About Us

"It's about Microsoft Excel"