Results 1 to 5 of 5
  1. #1
    gerretdj
    Guest

    Growing File Size for Spreadsheet

    We have a shared workbook that is growing in size for no apparent reason. Workbook contains 12 sheets each with no more than 10 columns and 50 rows. No complicated formulas, just data. Each time the workbook is closed it gets larger and is currently up to 4.6MB. Originally set up on Office 97. We have tried everything short of recreating the workbook. Any ideas?

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Growing File Size for Spreadsheet

    For a start clear all unused areas (menu, Edit Clear, All, or delete all unused columns and rows). Formatting large unused areas will cause larger file sizes.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Growing File Size for Spreadsheet

    Another culprit might be if you have Tools/Options/Calculation/Save External Link Values set which keeps a copy of the tables in
    external workbooks to which formulas refer.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Growing File Size for Spreadsheet

    Hi,

    You could try copying each sheet (just the range with values and formulae) into a new workbook.

    You might try to narrow down the problem. Save 12 copies of the workbook, and in each copy, delete 11 sheets. Open each of the 12 workbooks to see if there's one which recreates the problem.

    If there is only one worksheet, save several copies of that, deleteing a different range of rows.

    If you're still stumped, at least you have a workbook which is small enough to post on the forum!
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  5. #5
    gerretdj
    Guest

    Re: Growing File Size for Spreadsheet

    Your first suggestion worked out and we have the file down to an acceptable size. In the process found that one of the users sharing the file had set the switch to track and save changes for thirty days. This may have been the culprit. Will now monitor the new workbook size. Thanks for your assistance.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •