Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Excel workbooks growing way too large for no apparent reason...?

  1. #11
    Board Regular
    Join Date
    Oct 2009
    Location
    New Mexico, USA
    Posts
    455
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel workbooks growing way too large for no apparent reason...?

    Thanks for the post.

    You mentioned that you converted a worksheet into the new xlsx format.
    That format is used by Office 2007 and 2010. I am using Office 2003. I don't know if there is any issues with the later versions. They might have fixed it by now. I don't think it would work for me in any case since i have quite a bit of vba in the background. I would rather get away from the paste function for this project (if possible).

  2. #12
    New Member
    Join Date
    Jul 2011
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel workbooks growing way too large for no apparent reason...?

    Quote Originally Posted by MacBlimp View Post
    Hello,

    a colleague of mine is experiencing a weird problem with a number of his workbooks in excel 2007. His workbooks grow a lot when performing seemingly innocent actions. An example from yesterday:

    Adding a few hyperlinks to other sheets in the workbook caused the document to grow from 1 072k to an overwhelming 38Mb. No other operations than adding the links were performed between saves.

    The document is in excel 97-03 format and he's working in excel 2007.
    For some reason, deleting all rows and columns outside the used range of the worksheets (but not neccessarily the worksheet where the canges were made) brings the filesize back to normal for some reason.

    If anyone can shed some light at what's happening we'd be very grateful.

    Thanks in advance
    I've seen this and here's what I found worked. Use the Excel 2007 Name Manager to delete all names that are no longer used in the worksheet(s). There will be quite a few if there was a pivot table of any reasonable size that you deleted. If they have a #REF in the description you can delete them without checking but if you have set print areas, etc, these will give rise to 'names'. Having done that save the file. My 'best' case was 19M to 202k doing this. Hope this works.

  3. #13
    New Member
    Join Date
    May 2013
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Re: Excel workbooks growing way too large for no apparent reason...?


Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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