Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
More Excel 2007 Speed Issues
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 *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I speed up excel 2007 | Excel Discussion (Misc queries) | |||
Analysis Toolpack Issues in Excel 2007 (Office 2007 Enterprise) | Excel Discussion (Misc queries) | |||
Speed VBA Excel 2003 vs 2007 | Excel Programming | |||
Speed issues | Excel Worksheet Functions | |||
Speed Issues again | Excel Programming |