Windows 10: Excel files expanding exponentially

Discus and support Excel files expanding exponentially in Microsoft Office and 365 to solve the problem; Office 365 Excel has obscurely increased file sizes to where they sometimes become unworkable, a problem cited various times on the web. Solutions... Discussion in 'Microsoft Office and 365' started by Old Fixer, Jan 15, 2019.

  1. Old Fixer Win User

    Excel files expanding exponentially


    Office 365 Excel has obscurely increased file sizes to where they sometimes become unworkable, a problem cited various times on the web. Solutions include deleting/hiding unused ranges of cells, searching for hidden worksheets and hidden formulas, running the Office Repair, even uninstalling and reinstalling Office 365, all to no avail. My simple workpages are only 10 columns wide and not more than 100 lines long. I have been using several formulas for a decade that I constructed (not from 3rd party templates) that keep track of monthly payments on just 13 rental units, maintaining progressive balances. In the earliest files I have, the file size was about 10MB ten years ago and have stayed in that range until last March when it suddenly jumped to 20 MB and now has grown to 25MB with only a few more lines of data entered on each worksheet. The files are saved to OneDrive.

    MS support suggested this could happen from improper shutdowns or saving incorrectly, but is the program that fragile that it requires an IT tech to monitor a workbook so simple? The only suggestion that held any credibility was that I may have moved these files through too many revisions of Excel over the years, but that doesn't explain the sudden jump last March.

    The workaround solution I used was to manually copy and paste each worksheet into a new workbook by highlighting the original, copying its contents and formulas with the menu command (not Ctrl+C) and doing a special paste into a freshly created workpage. Unused cell ranges were eliminated en masse after all workpages had been moved. [The Copy/Move option on the tab wasn't as clean.] When completed, with everything in the same format and physical layout, the entire workbook is only 118 kb! *Shock

    How does this occur? Is there no way to look into the belly of these files to see what's going on? There's got to be a reason this happens and a fix for it.

    :)
     
    Old Fixer, Jan 15, 2019
    #1
  2. dalchina Win User

    CSV files used to open in Excel....not now!


    Hi, you say Excel is installed. Does it run normally?

    You can't find Excel in (an unspecified) list of applications. I don't know which list that is for sure.

    For example, in the list related to:
    - rt click a file. Open With
    - this list:

    Excel files expanding exponentially [​IMG]

    - this list:

    Excel files expanding exponentially [​IMG]


    - some other list...

    If Excel does not appear in the above, I suggest you repair your office installation.

    Maybe the above gives you some ideas. Otherwise please post a screenshot of where you think you should see it but don't. Thanks.
     
    dalchina, Jan 15, 2019
    #2
  3. Excel file

    Hi zhiyang....,

    I'm assuming that since you're using Excel 2011, that you have a Mac. Have you tried saving the file in the default 2011 format of XLSX?

    While I have tested and can open both XLS and XLSX files on my Windows Phone, they were both created in PC versions of Excel 2000 and Excel 2010.

    As a test, would you:

    • First, try saving the file as XLSX and see if you can access the newer file format on your phone.

    Otherwise, try the following as a test:

    • Open up a web browser
    • Go to Windows Live and login.
    • Select "SkyDrive" at the top of the brwoser window
    • Select the Excel icon near the top where it says "Create"
    • Add a few numbers and do an AutoSum. Maybe add some formatting.
    • Close the workbook (File -> Close workbook)
    • Next, your SkyDrive file listing will appear with the new file.
    • Click the "i" circle to the far right of the new file.
    • Now, select "Send a link"
    • Enter your e-mail information and click "Send"
    • On your phone, open the e-mail and click on the button that says "View document"
    • You should be able to view the document.
    • If yes, then there is apparently a compatibilty issue on the Mac using XLS and I would try my first suggestion of trying to save the file in a different format like the newer XLSX.

    By the way, the procedure gets easier in Windows Phone Mango (coming soon - no official release dates yet except in Japan) as you can save to and access files directly from your SkyDrive. That would eliminate the e-mailing it to yourself steps ... a lot easier!

    I hope this helps!

    David
     
    David Scammell, Jan 15, 2019
    #3
  4. illimay Win User

    Excel files expanding exponentially

    How do I expand the 'Recent' list in the File Explorer?


    Thanks for an alternative suggestion.


    Excel files expanding exponentially [​IMG]


    I don't know what happened... but the list got longer for some reason. I didn't do anything special... but it just got longer
     
    illimay, Jan 15, 2019
    #4
Thema:

Excel files expanding exponentially

Loading...
  1. Excel files expanding exponentially - Similar Threads - Excel files expanding

  2. Excel cannot open files

    in Windows 10 Network and Sharing
    Excel cannot open files: I found in the last two to three days that XLSX files are not opening and i am getting the below mentioned message. Can you please help out Excel cannot open the file 'Salary working file Feb'19.xlsx' because the file format or file extension is not valid. Verify that the...
  3. excel file not found

    in Windows 10 Network and Sharing
    excel file not found: I have an excel file I can see on my jump drive G It will not open the error message is Sorry, we couldn't find G:\2014-2019 SMILEYS.xlsx. Is it possible it was moved, renamed or deleted? How do I get into this file?...
  4. Excel files

    in Windows 10 Network and Sharing
    Excel files: How do I open https://answers.microsoft.com/en-us/windows/forum/all/excel-files/9c381f48-f96f-4778-8304-10e1331e1e5a"
  5. Restore Excel file sheet

    in Windows 10 Network and Sharing
    Restore Excel file sheet: Working in an Excel file I mistakenly deleted a "sheet" is it possible to restore it? I've looked in the Recycle Bin, I've tried "restore previous version." https://answers.microsoft.com/en-us/windows/forum/all/restore-excel-file-sheet/7f8a11d4-0a49-45df-8396-c0d21791c1bc"
  6. Expand File Explorer Navigation Pane

    in Windows 10 Network and Sharing
    Expand File Explorer Navigation Pane: Now and then I want to view the full folder tree in Navigation Pane of File Explorer. There are some options to keep the folder tree open, but most of the time they are a pain in the butt. When I do want the tree visible, I have to go to the root disk and open each parent...
  7. excel file replaced by a TMP file

    in Windows 10 BSOD Crashes and Debugging
    excel file replaced by a TMP file: I have a Excel file that has changed into a TMP file and cannot be opened. When trying to open from the Excel program, it indicates that the file is missing. Why did it change and how do I get it back?...
  8. Searching for excel files in file explorer

    in Windows 10 Network and Sharing
    Searching for excel files in file explorer: How can I refine my search when searching for a particular spreadsheet? https://answers.microsoft.com/en-us/windows/forum/windows_10-networking/searching-for-excel-files-in-file-explorer/5baecff7-1583-4f15-9e96-6e6e45efd92d
  9. ODT file to Excel?

    in Windows 10 Software and Apps
    ODT file to Excel?: Greetings, How can I convert an ODT file into excel? It was in excel style format (unsure if Microsoft) over a month ago and now it will only open (with random letters) in Notepad. When I try (open with) (WORD) ...I receive an error message. The file shows that it has 30KB...
  10. Expanding C: drive with File Explorer

    in Windows 10 Support
    Expanding C: drive with File Explorer: I need to replace the personal.xlsb file to my Excel XLSTART folder on my C: Drive but I do not seem to bore down to XLSTART using file explorer. If I go to this pc and choose C: then Users, then my user name I get only such things a Documents, Favorites, One Drive, etc. I...