Excel consuming absurd amount of memmory

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":

  1. Copy the contents from all cells
  2. Create a new sheet
  3. "Paste special" the values, comments, values, formulas, validation and formats. Delete the old sheet
  4. 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

guilhermecgs

Posted 2014-08-20T02:02:18.403

Reputation: 145

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

No answers