Slow Excel 2007 calculation in a workbook and one solution - Bob
Flanagan
06-Jun-07 11:29:10

Problem:

In Excel 2007 an xls workbook takes 2-4 seconds to recalculte whenever a
cell is changed. The workbook works fine in Excel 2003.

No external links
no macros
no range names
File well under 1 meg, with very few formulas - mostly data and sums
No conditional formatting
A few IF formulas, about 10-20
About 30 sum functions
Just one worksheet
Changing to manual recalc did not help
Saving as xlsx did not solve
Copying and pasting cells to a xlsx workbook did not solve
Clearing all formats did not solve
Converting all cells to values did not solve
Copying the worksheet to a new workbook did not solve
Deleting all cells did not solve!!!!
Doing an Edit, Clear All did not solve!!!!!

Solution that worked:
Created a new xlsx workbook
Selected the cells and did a copy, paste special formulas to the new
workbook

Changing cells in the new workbook resulted in no delay.

The above works if there is just one sheet in a workbook. I'm not
certain
how one would solve if there were multiple worksheets. Any thoughts?

Most likely there is some corruption in the XLS workbook, but none that
affects performance in 2003, just in 2007.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel





Slow Excel 2007 calculation in a workbook and one solution - Jim Rech
06-Jun-07 12:06:06

Interesting work, Bob, but I don't buy that, especially the "most
likely"
part.


I doubt "corruption" would survive that, after all, what would the XML
equivalent of corruption be?<g

How about we say we don't know the cause but MS damn sure should!

--
Jim
Slow Excel 2007 calculation in a workbook and one solution - Bob
Flanagan
07-Jun-07 09:44:49

Jim, I agree. After several hours of frustration, I jumped to
conclusions
as to the cause. I'm gong to keep trying to find the cause - after
being
away from the problem for a days, I have some more thoughts on how to
pinpoint the problem.

Bob

http://www.eggheadcafe.com/software/...xcel-2007-calc
ulati.aspx









*** Sent via Developersdex http://www.developersdex.com ***