Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto calculating not working
For the first time in 20 years of using Excel, I am finding that auto
calculation is not taking place whenever I add new entries to a range of cells included in, for example, the SUM function. I only get the correct results after invoking the function again. Even to calculate a fraction, the correct answer is not automatically updated if the numerator or denominator changes. Yesterday, I emailed the worksheet I was working on to my office neighbour's computer and I was able to edit the sheet and get the updated results automatically. Could there be something wrong with the version on Excel 2007 on my PC? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto calculating not working
Check:
Office ButtonExcel OptionsFormulasWorkbook CalculationAutomatic Regards, Fred "Marcia" wrote in message ... For the first time in 20 years of using Excel, I am finding that auto calculation is not taking place whenever I add new entries to a range of cells included in, for example, the SUM function. I only get the correct results after invoking the function again. Even to calculate a fraction, the correct answer is not automatically updated if the numerator or denominator changes. Yesterday, I emailed the worksheet I was working on to my office neighbour's computer and I was able to edit the sheet and get the updated results automatically. Could there be something wrong with the version on Excel 2007 on my PC? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto calculating not working
Hi,
It sounds like it may be calculation has been changed to manual. Office button - Excel Options - Formulas - Select "Automatic" - OK If it is that and your wondering how, it's because Excel remembers the calculation setting of the first workbook opened in a session and if that was set to manual then the application is changed to manual. Mike "Marcia" wrote: For the first time in 20 years of using Excel, I am finding that auto calculation is not taking place whenever I add new entries to a range of cells included in, for example, the SUM function. I only get the correct results after invoking the function again. Even to calculate a fraction, the correct answer is not automatically updated if the numerator or denominator changes. Yesterday, I emailed the worksheet I was working on to my office neighbour's computer and I was able to edit the sheet and get the updated results automatically. Could there be something wrong with the version on Excel 2007 on my PC? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto calculating not working
Thank you so much! I did find that out with the help of someone from my IT
dept! Never too old to learn! "Fred Smith" wrote: Check: Office ButtonExcel OptionsFormulasWorkbook CalculationAutomatic Regards, Fred "Marcia" wrote in message ... For the first time in 20 years of using Excel, I am finding that auto calculation is not taking place whenever I add new entries to a range of cells included in, for example, the SUM function. I only get the correct results after invoking the function again. Even to calculate a fraction, the correct answer is not automatically updated if the numerator or denominator changes. Yesterday, I emailed the worksheet I was working on to my office neighbour's computer and I was able to edit the sheet and get the updated results automatically. Could there be something wrong with the version on Excel 2007 on my PC? . |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto calculating not working
Glad to help. Thanks for the feedback.
Fred "Marcia" wrote in message ... Thank you so much! I did find that out with the help of someone from my IT dept! Never too old to learn! "Fred Smith" wrote: Check: Office ButtonExcel OptionsFormulasWorkbook CalculationAutomatic Regards, Fred "Marcia" wrote in message ... For the first time in 20 years of using Excel, I am finding that auto calculation is not taking place whenever I add new entries to a range of cells included in, for example, the SUM function. I only get the correct results after invoking the function again. Even to calculate a fraction, the correct answer is not automatically updated if the numerator or denominator changes. Yesterday, I emailed the worksheet I was working on to my office neighbour's computer and I was able to edit the sheet and get the updated results automatically. Could there be something wrong with the version on Excel 2007 on my PC? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating working days | Excel Discussion (Misc queries) | |||
Calculating working hours | Excel Discussion (Misc queries) | |||
Calculating Working Days | Excel Worksheet Functions | |||
Calculating working hours | Excel Discussion (Misc queries) | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions |