ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Find cause of slowly calculating spreadsheet -recursive equation? (https://www.excelbanter.com/excel-discussion-misc-queries/107581-find-cause-slowly-calculating-spreadsheet-recursive-equation.html)

manxman

Find cause of slowly calculating spreadsheet -recursive equation?
 
I have a spreadsheet that takes an inordinate amount of time to process any
new entry, about two seconds. It also causes other sheets to operate slowly
when it is open. I think there is a recursive equation somewhere in the ten
or twelve tabs, but how do I find it in a reasonable amount of time?

Peo Sjoblom

Find cause of slowly calculating spreadsheet -recursive equation?
 
Check here

http://www.decisionmodels.com/

the excel pages deal with speed and calculations

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email)


"manxman" wrote in message
...
I have a spreadsheet that takes an inordinate amount of time to process any
new entry, about two seconds. It also causes other sheets to operate
slowly
when it is open. I think there is a recursive equation somewhere in the
ten
or twelve tabs, but how do I find it in a reasonable amount of time?





All times are GMT +1. The time now is 08:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com