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

3
  • 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. Aug 20, 2014 at 4:15
  • 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
    Aug 21, 2014 at 7:14
  • 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. Aug 21, 2014 at 16:22

0

You must log in to answer this question.

Browse other questions tagged .