+ Reply to Thread
Results 1 to 4 of 4

Reduce File Size of xlsb

  1. #1
    Registered User
    Join Date
    12-06-2013
    Location
    Swe
    MS-Off Ver
    Excel 2007
    Posts
    26

    Reduce File Size of xlsb

    Hi, I have 4 .xlsb workbooks with a lot of references between them and trying to reduce size to improve performance etc.
    The sheets also contain tables with formulas to fetch data from other Workbooks and sheets. Some of them 40 columns wide
    and 10.000 rows where all cells contain data or formula.

    What can I do and how?

    Already done:

    * converted to .xlsb as stated above which was the most effective adjustment so far
    * CTRL+END and removed all possible not needed data with "Clear All"
    * Using INDEX instead of VLOOKUP in formulas (not reducing size maybe but improving performance from what I understand)
    * Removed all unnecessary formatting
    * some other stuff....

  2. #2
    Valued Forum Contributor Hawkeye16's Avatar
    Join Date
    02-27-2013
    Location
    Holland
    MS-Off Ver
    ├•┤ Pew Pew
    Posts
    441

    Re: Reduce File Size of xlsb

    Seems to me that you have done most of the stuff I would suggest already. Unless you can find a way to not link to external files or not have formulas in all of the cells that you have them in I can't think of another way I would reduce size.
    Despite the high cost of living, it remains very popular.

    Don't forget to mark threads SOLVED when you get an answer and rep all the geniouses that helped you today!

  3. #3
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Reduce File Size of xlsb

    Few quick checks?

    - Are you referencing full columns/rows? reference only range in use
    - Is there any Conditional formatting?
    - Are you using INDIRECT, OFFSET or other volatile formulae?
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  4. #4
    Registered User
    Join Date
    12-06-2013
    Location
    Swe
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Reduce File Size of xlsb

    Yes I´m referencing whole columns. Started to change that but I didn't see the file size going down so I stopped.
    No conditional formatting.
    No INDIRECT or OFFSET.

+ 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: 9
    Last Post: 05-18-2023, 07:18 PM
  2. Reduce File Size
    By hasanpmp in forum Excel General
    Replies: 3
    Last Post: 05-15-2014, 05:31 AM
  3. Replies: 1
    Last Post: 12-17-2013, 03:18 PM
  4. File Size Difference with xlsm and xlsb
    By aftabn10 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-25-2011, 01:05 PM
  5. Need help to reduce file size
    By iturnrocks in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-11-2007, 06:17 AM

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