+ Reply to Thread
Results 1 to 3 of 3

Reduce workbook size

  1. #1
    Registered User
    Join Date
    10-10-2003
    Location
    Massachusetts
    Posts
    82

    Reduce workbook size

    We are running excel 2007. We have a workbook that is approaching 12 mb in size, and takes a very long time to open and save. We are running Gigabit adapters in the server and the workstation. Opening and saving using excel 2003 took seconds. Under XL 2007 it takes what seems like forever.

    The workbook has 20 some odd sheets, and each sheet has custom column & row widths as well as custom formatting.
    My idea is to copy and paste all of these sheets into one large sheet. Then delete all the other sheets. Then I would like to select a range that contains the information for what we want to do from this one larger sheet, and paste the range into a temporary sheet.
    The problem is formatting the sheet so that column and row sizes are appropriate.

    Is there any (relatively quick) way to save the column and row widths, formatting and fonts from the original sheets to format the temporary sheet?

    Any other ideas for reducing the file size would be greatly appreciated.


    Thanks,

    Capt. B

  2. #2
    Forum Contributor
    Join Date
    09-04-2006
    Location
    Yorkshire, England
    Posts
    267
    Have you convereted it to a xl 2007 file? or are you re openning a 2003 file with xl 2007 everytime?
    JR
    Versions
    Mac OS X 'Leopard'
    Mac MS Office Excel 2004
    Windows XP
    MS Excel 2002
    MS Excel 2003

  3. #3
    Registered User
    Join Date
    10-10-2003
    Location
    Massachusetts
    Posts
    82
    Saving the worksheet in xlsm reduces the file size substantially (by 2/3). Unfortunately the load time does not change. We still have a couple of older computers run xl 2003 so we are staying with .xls file type for the moment. If the file had loaded quickly as an xlsm, we would have upgraded the older computers to XL 07.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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