0
I have a excel file consuming a huge amount of memmory, something ~500mb.
The file contains only one sheet, no images or scripts and its size is only 719kb.
I have checked all suggested solutions found in some forums, but none worked (http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2012/12/18/top-10-list-of-performance-issues-in-excel-workbooks.aspx)
The only thing that works is a manual procedure that looks like "black magic":
- Copy the contents from all cells
- Create a new sheet
- "Paste special" the values, comments, values, formulas, validation and formats. Delete the old sheet
- If you just Ctrl+V into the new sheet it will not work
The lady that uses this excel file in a daily basis does not know what triggers the problem. The only thing she knows is that everything is OK and 5 minutes later the slowness starts. All efforts to extract from her what exactly she has doing at the time to trigger the problem have been in vain
I have attached an example below. Any Help?
https://dl.dropboxusercontent.com/u/2292171/example2014%20%281%29.xlsx
LibreOffice is also extremely slow (400MB memory usage and 100% CPU usage on 1 CPU core) when opening the sample. So this is not an Excel issue, the XLSX file seams to have issues. – magicandre1981 – 2014-08-20T04:15:55.400
I wonder if it is the print setup? I noticed it is set to fit to a single page, where it probably should be 30+ pages. – Mike Honey – 2014-08-21T07:14:28.703
I captured a xperf trace of LibreOffice and here graphic/drawing operations cause the CPU usage ad slowdowns. Maybe it is the same for Excel. – magicandre1981 – 2014-08-21T16:22:02.173