If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formula's stop working
Has anyone encountered Formula's that stop working in
Excel 2000? Recently I've had several users state that all of a sudden, their formula's stop working. I uninstalled and reinstalled Office 2000 Pro on one users PC then about a week later, it happened again. Any thoughts on this? Thanks in advance. Ken |
#2
|
|||
|
|||
Formula's stop working
Hi Ken,
ToolsOptionsCalculation, check Automatic This setting is taken from the first workbook opened, and then applies to all open workbooks. -- Kind Regards, Niek Otten Microsoft MVP - Excel "Ken Smith" wrote in message ... Has anyone encountered Formula's that stop working in Excel 2000? Recently I've had several users state that all of a sudden, their formula's stop working. I uninstalled and reinstalled Office 2000 Pro on one users PC then about a week later, it happened again. Any thoughts on this? Thanks in advance. Ken |
#3
|
|||
|
|||
Formula's stop working
Ken
The most likely cause is that ToolsOptionsCalculation "automatic" got switched to "manual" Excel takes the calculation mode of the first workbook opened in a session. If that workbook was saved as "manual" calc, then subsequent workbooks opened will be "manual" no matter which mode they were saved under. Gord Dibben Excel MVP On Fri, 23 Jan 2004 10:56:52 -0800, "Ken Smith" wrote: Has anyone encountered Formula's that stop working in Excel 2000? Recently I've had several users state that all of a sudden, their formula's stop working. I uninstalled and reinstalled Office 2000 Pro on one users PC then about a week later, it happened again. Any thoughts on this? Thanks in advance. Ken |
#4
|
|||
|
|||
Formula's stop working
thank you, I'll get with the user and try that.
thanks again, hope this is it. Ken -----Original Message----- Ken The most likely cause is that ToolsOptionsCalculation "automatic" got switched to "manual" Excel takes the calculation mode of the first workbook opened in a session. If that workbook was saved as "manual" calc, then subsequent workbooks opened will be "manual" no matter which mode they were saved under. Gord Dibben Excel MVP On Fri, 23 Jan 2004 10:56:52 -0800, "Ken Smith" wrote: Has anyone encountered Formula's that stop working in Excel 2000? Recently I've had several users state that all of a sudden, their formula's stop working. I uninstalled and reinstalled Office 2000 Pro on one users PC then about a week later, it happened again. Any thoughts on this? Thanks in advance. Ken . |
#5
|
|||
|
|||
Formula's stop working
thank you, I'll get with the user and try that.
thanks again, hope this is it. Ken -----Original Message----- Hi Ken, ToolsOptionsCalculation, check Automatic This setting is taken from the first workbook opened, and then applies to all open workbooks. -- Kind Regards, Niek Otten Microsoft MVP - Excel "Ken Smith" wrote in message ... Has anyone encountered Formula's that stop working in Excel 2000? Recently I've had several users state that all of a sudden, their formula's stop working. I uninstalled and reinstalled Office 2000 Pro on one users PC then about a week later, it happened again. Any thoughts on this? Thanks in advance. Ken . |
Thread Tools | |
Display Modes | |
|
|