+ Reply to Thread
Results 1 to 11 of 11

Excel file size blowing up

  1. 05-10-2017, 09:08 AM #1
    Joe_Swe
    Joe_Swe is offline
    Registered User
    Join Date
    05-10-2017
    Location
    Stockholm, Sweden
    MS-Off Ver
    2016
    Posts
    5

    Excel file size blowing up

    Hi!

    New to the forum, signed up after having tried to troubleshoot for hours. Hopefully I can return some advice in the future.

    So I have an excel file that I have been working on for a while. Now, in one of the sheets I am simply adding two rows (it has around 1000 rows) and after saving it file size increases by 10%, while doing the same change in 6 sheets, it more than doubles.

    - Have tried ctrl + end and there is no additional formatting
    - I am the only user, so its not a shared file.

    Any help would be highly appreciated!
    Reply With QuoteRegister To Reply
  2. 05-10-2017, 09:29 AM #2
    LukeGilfoyle
    LukeGilfoyle is offline
    Forum Contributor
    Join Date
    10-28-2015
    Location
    Lincolnshire, England
    MS-Off Ver
    2016
    Posts
    188

    Re: Excel file size blowing up

    Joe_Swe,

    Save As "Binary Workbook" - this should considerably help.

    Also, make sure there are no hidden formats on any sheet (including hidden sheets) or objects.

    Let me know if this help.

    Thanks



    Administrative Note:
    • As per Forum Rule #12, please limit quotes to only that which is necessary -- otherwise it's just clutter...Thanks.
    Last edited by jeffreybrown; 05-10-2017 at 09:31 AM. Reason: Administrator note
    If myself or others have helped, please add to our reputation by pressing the 'Star' icon below this.
    Reply With QuoteRegister To Reply
  3. 05-10-2017, 09:32 AM #3
    Joe_Swe
    Joe_Swe is offline
    Registered User
    Join Date
    05-10-2017
    Location
    Stockholm, Sweden
    MS-Off Ver
    2016
    Posts
    5

    Re: Excel file size blowing up

    Thanks. There are no hidden formats, sheets or objects so there must be something else. Can try to save as "Binary Workbook" but I kind of got obsessed with understanding the problem :-)
    Reply With QuoteRegister To Reply
  4. 05-10-2017, 09:34 AM #4
    LukeGilfoyle
    LukeGilfoyle is offline
    Forum Contributor
    Join Date
    10-28-2015
    Location
    Lincolnshire, England
    MS-Off Ver
    2016
    Posts
    188

    Re: Excel file size blowing up

    Joe_Swe,

    Are the rows containing formulas?

    If they are and you don't need the formulas to be calculating constantly, then copy all of the data containing formulas, right click on the top left cell you selected and press "Paste Values".

    This will reduce the size too.

    Thanks
    Last edited by jeffreybrown; 05-10-2017 at 09:44 AM.
    Reply With QuoteRegister To Reply
  5. 05-10-2017, 09:34 AM #5
    CK76
    CK76 is online now
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,885

    Re: Excel file size blowing up

    By chance does workbook contain pivottables?
    Reply With QuoteRegister To Reply
  6. 05-10-2017, 09:39 AM #6
    Joe_Swe
    Joe_Swe is offline
    Registered User
    Join Date
    05-10-2017
    Location
    Stockholm, Sweden
    MS-Off Ver
    2016
    Posts
    5

    Re: Excel file size blowing up

    LukeGilfoyle,

    Yes, the rows have formulas, but even just adding two blank rows causes the problem..
    Last edited by jeffreybrown; 05-10-2017 at 09:43 AM.
    Reply With QuoteRegister To Reply
  7. 05-10-2017, 09:40 AM #7
    Joe_Swe
    Joe_Swe is offline
    Registered User
    Join Date
    05-10-2017
    Location
    Stockholm, Sweden
    MS-Off Ver
    2016
    Posts
    5

    Re: Excel file size blowing up

    CK76,

    No pivots, just pure formulas..
    Last edited by jeffreybrown; 05-10-2017 at 09:43 AM.
    Reply With QuoteRegister To Reply
  8. 05-10-2017, 09:40 AM #8
    LukeGilfoyle
    LukeGilfoyle is offline
    Forum Contributor
    Join Date
    10-28-2015
    Location
    Lincolnshire, England
    MS-Off Ver
    2016
    Posts
    188

    Re: Excel file size blowing up

    Out of interest, how long are the rows? Do they contain formatting, conditional formatting rules?

    Did saving as binary help?
    Reply With QuoteRegister To Reply
  9. 05-10-2017, 09:44 AM #9
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Excel file size blowing up

    Luke & Joe,

    Administrative Note:
    • As per Forum Rule #12, please limit quotes to only that which is necessary -- otherwise it's just clutter...Thanks.
    HTH
    Regards, Jeff
    Reply With QuoteRegister To Reply
  10. 05-10-2017, 09:52 AM #10
    Joe_Swe
    Joe_Swe is offline
    Registered User
    Join Date
    05-10-2017
    Location
    Stockholm, Sweden
    MS-Off Ver
    2016
    Posts
    5

    Re: Excel file size blowing up

    Rows are 48 colums long. No conditional formating, but they do indeed have simple formats. Although even clearing formats does not solve the problem.

    Yes, saving as binary reduced size so I guess thats what I will go with. Frustrating though to not understand the underlying issue =)
    Reply With QuoteRegister To Reply
  11. 05-10-2017, 09:59 AM #11
    LukeGilfoyle
    LukeGilfoyle is offline
    Forum Contributor
    Join Date
    10-28-2015
    Location
    Lincolnshire, England
    MS-Off Ver
    2016
    Posts
    188

    Re: Excel file size blowing up

    This is a lot of information on this from a simple Google search - very common issue with excel files.

    If I have helped, please consider adding to my reputation - many thanks
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Too Many Rows With .csv file. Need to create macro to reduce row size or file size
    By rmccain in forum Excel General
    Replies: 9
    Last Post: 05-18-2023, 07:18 PM
  2. Size of Size of the Excel File saved on a networkdrive
    By cpmsimoes in forum Excel General
    Replies: 0
    Last Post: 08-12-2015, 06:01 AM
  3. Blowing out candles
    By FDibbins in forum The Water Cooler
    Replies: 11
    Last Post: 09-12-2013, 05:44 PM
  4. Excel file size increases when saving - 80KB file becomes 26MB, help!
    By TanyaExcel in forum Excel General
    Replies: 5
    Last Post: 09-13-2012, 11:50 AM
  5. Excel 2007 : File size blowing up, help please!!!!
    By hawee in forum Excel General
    Replies: 3
    Last Post: 03-28-2012, 04:25 PM
  6. [SOLVED] Excel 2007 : File size has increased in size...Why
    By THORmx in forum Excel General
    Replies: 3
    Last Post: 02-12-2009, 02:39 AM
  7. [SOLVED] Unable to open excel file and when view the file size show as 1 KB
    By Kamal Siva in forum Excel General
    Replies: 1
    Last Post: 03-06-2006, 11:25 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1