Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Very Long Calculation Times
I have a large spreadsheet that has a lot of data and a lot of formulas. I
have deleted a very large amount of the spreadsheet in order to streamline the amount of time that it takes to calculate cells. I normally work in a manual calc mode. I thought that after making these changes that the calc time would have dropped dramatically. It has not changed at all really. The overall size of the spreadsheet has been cut in half. Are there any usual supects that consume calc times? Is there any way to test the sheet to see where the resource drag is? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Very Long Calculation Times
Look he
www.decisionmodels.com -- Kind regards, Niek Otten Microsoft MVP - Excel "Briar Rabbit" wrote in message ... |I have a large spreadsheet that has a lot of data and a lot of formulas. I | have deleted a very large amount of the spreadsheet in order to streamline | the amount of time that it takes to calculate cells. I normally work in a | manual calc mode. I thought that after making these changes that the calc | time would have dropped dramatically. It has not changed at all really. The | overall size of the spreadsheet has been cut in half. Are there any usual | supects that consume calc times? Is there any way to test the sheet to see | where the resource drag is? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help setting the worksheet header/Footer margins based on string height? | Excel Discussion (Misc queries) | |||
Display names | Excel Discussion (Misc queries) | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
MOREFUNC.XLL - RECALL() to trigger once only calculation? | Excel Discussion (Misc queries) | |||
Date & Time | New Users to Excel |