+ Reply to Thread
Results 1 to 2 of 2

Massive jump in file size?

  1. #1
    Registered User
    Join Date
    08-25-2017
    Location
    England
    MS-Off Ver
    2016
    Posts
    36

    Massive jump in file size?

    Hi people.

    I have an Excel file that lives on a One Drive (Business version), file size was roughly 2MB, today the file became inaccessible on the One Drive as the size has increased to 37.1MB. (One Drive max size is 30MB)

    I cannot see why the file has increased in size by nearly 30 time for no reasons, there is no new data, macros or anything else in there, its just well, bigger.

    Is there a way or method I can use to find out why this might be? Is it a common issue?

    Unfortunately I cannot upload the sheet here as it has business sensation info on it.

    Thank you

  2. #2
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: Massive jump in file size?

    Seeing that the file has been inaccessible, try right click, copy etc. to your hard drive. See if you can open it.


    I usually discover links to other workbooks which can gum it all up. You might look at Data, Connections, Edit Links. They may also lurk in Conditional Formatting formulas.

    Pete
    Last edited by PeteABC123; 06-04-2018 at 04:29 PM.

+ 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. Massive file size when adding comments with picture
    By npbndcis in forum Excel General
    Replies: 7
    Last Post: 12-31-2015, 11:35 AM
  2. Massive File Size for No Obvious Reason...
    By chconnol in forum Excel General
    Replies: 5
    Last Post: 01-21-2012, 12:45 PM
  3. Undesirable massive increase in file size
    By 1eyedjack in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-14-2010, 12:53 PM
  4. Massive file size even when empty
    By talksalot81 in forum Excel General
    Replies: 16
    Last Post: 03-19-2010, 05:41 AM
  5. MASSIVE FILE - chart won't update
    By rasonline in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-04-2009, 05:22 PM
  6. Massive file, chart won't update?
    By rasonline in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-27-2008, 03:19 PM
  7. Massive large size of Excel File after Updating
    By coreman in forum Excel General
    Replies: 2
    Last Post: 09-13-2005, 12:06 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