Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating cells twice?
I use a spreadsheet everyday that involves alot of VBA and calculations. The sheet used to run its calculation once (manual calc is the only way to use the spreadsheet). It has started to calc the sheet twice now when we hit shift F9. Any reasons? I thought it might be because of dependent algorithms, but they have always been there. -- Nike6106 ------------------------------------------------------------------------ Nike6106's Profile: http://www.excelforum.com/member.php...o&userid=36170 View this thread: http://www.excelforum.com/showthread...hreadid=559498 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating cells twice?
Is the program set to calculate manually?? Goto options calculate and
see what is checked off |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating cells twice?
Some cells may be calculated more than once, especially if you have User Defined Functions. This happens more (or even only, I'm
not sure) if your UDFs address worksheet cells directly, that is, not via the argument list. It also depends on which version of Excel you have. Much information about the calculation mechanism can be found on Charles William's site: www.decisionmodels.com For Excel 2002, an uncommonly detailed specification of that mechanism can be found he http://msdn.microsoft.com/library/de...c_xlrecalc.asp -- Kind regards, Niek Otten Microsoft MVP - Excel "Nike6106" wrote in message ... | | I use a spreadsheet everyday that involves alot of VBA and calculations. | The sheet used to run its calculation once (manual calc is the only way | to use the spreadsheet). It has started to calc the sheet twice now | when we hit shift F9. Any reasons? I thought it might be because of | dependent algorithms, but they have always been there. | | | -- | Nike6106 | ------------------------------------------------------------------------ | Nike6106's Profile: http://www.excelforum.com/member.php...o&userid=36170 | View this thread: http://www.excelforum.com/showthread...hreadid=559498 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating cells | Excel Worksheet Functions | |||
Calculating the average of cells | New Users to Excel | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Cells formated as numbers are calculating like text | Excel Discussion (Misc queries) | |||
Calculating without including Hidden Cells | Excel Discussion (Misc queries) |