1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Size

Discussion in 'Ask an Excel Question' started by Surekha, Aug 16, 2018.

  1. Surekha

    Surekha New Member

    Messages:
    26
    Hi Team,
    I have excel which contains more than 80 sheets, with 27 pivot. Each sheet will not have data more than 10000 rows. I saved the file in binary format but still file size is more than excepted( it around 35 MB). File doesn't contains any object in it. When I delete unwanted rows and columns file size will increase instead of decreasing. Please help me to resolve this.
  2. GraH - Guido

    GraH - Guido Well-Known Member

    Messages:
    812
    Hi,
    I suspect some pivot cache issues.
    - Do some of the pivots share the same data, or do they all refer to other datasets?
    - Is the pivot data in the same file, or not?

    Already try to set "save pivot data with file" to false (uncheck the flag), for each of the pivots. See if that has any effect at all.
  3. pecoflyer

    pecoflyer Active Member

    Messages:
    258
  4. Deepak

    Deepak Excel Ninja

    Messages:
    2,862
    You may share the file if issue exists yet.
  5. Chihiro

    Chihiro Excel Ninja

    Messages:
    5,053
    80 sheets sounds excessive. Consider splitting workbook to smaller chunks. Typically, I'd recommend keeping sheet number in a given workbook to 20 or less (though I prefer less than 10).

    On top of PivotCache others have mentioned... check each sheet's used range by using CTRL + END. If the selected cell is beyond your data range, then you'd need to select those ranges and use edit tool to clear all.

Share This Page