+ Reply to Thread
Results 1 to 4 of 4

Size of Recovered Excel workbook

  1. #1
    Registered User
    Join Date
    09-10-2013
    Location
    Arizona, USA
    MS-Off Ver
    Excel 2007
    Posts
    12

    Size of Recovered Excel workbook

    I had an Excel workbook that was 2,200 KB. Excel stopped working, and recovered the workbook from an Auto-saved version. Now the workbook is 18,000 KB. Does anyone know the reason for the huge difference? I have added functionality, but nothing significant. Is there a way to reduce the size of the workbook?

    Thank you!
    KarlaM

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Size of Recovered Excel workbook

    This is just a guess but I think that there is a lot of "overhead junk" created by the recovery, in the file that you have recovered. It might be worth copying one worksheet at a time and paste into a new workbook.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Size of Recovered Excel workbook

    I use one sheet as a 'Status Log' that sometimes has several thousand lines in it. When I do that my workbook balloons to the size you mention, even when that sheet is deleted, and the workbook saved, of 'saved as'.

    1. Open the original file.
    2. Right click one of the 'Sheet Name' tabs on the bottom of the original file.
    Select 'Select All Sheets'.
    3. Right click one of the 'Sheet Name' tabs on the bottom of the original file.
    Select 'Move or Copy'. Select the 'Copy' checkbox. Copy to New Book.
    4. If you have any Macros, export the modules one at a time. Count the number of modules you exported.
    Do the same for any UserForms, Worksheets, that have code, etc.
    5. Import the items from Step 4 into the New Workbook.
    6. When you save the New Workbook the size will be a lot smaller.

    WARNING: If you have any Macros assigned to command buttons on the sheets make sure that the
    NEW WORKBOOK is the file that is referenced for the assigned macros.

  4. #4
    Registered User
    Join Date
    09-10-2013
    Location
    Arizona, USA
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Size of Recovered Excel workbook

    Thank you so much for your quick responses. I think you are probably right about the "junk". I tried as you suggested with exporting and importing macros and copying worksheets from the old workbook to the new. It worked like a charm!

    Thanks!
    KarlaM

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 08-12-2013, 10:34 AM
  2. [SOLVED] Recovered workbook won't let me amend charts
    By katieshields in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 03-31-2013, 01:01 AM
  3. Huge size of my Excel workbook
    By RagonichaFulva in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-15-2012, 07:07 AM
  4. Replies: 3
    Last Post: 01-17-2011, 03:55 AM
  5. Excel workbook size
    By jasonhenley in forum Excel General
    Replies: 2
    Last Post: 08-03-2009, 03:09 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1