| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Report with formuals already entered
I'm doing an old 2006 audit report with formulas entered...I'm saving as a
2007 report and changing the numbers...The formulas are correct, but it won't automatically accept any of my new numbers and formulate...It's like the old report was formatted or saved a certain way...That person is no longer working there and noone in the office can figure out what is wrong...I don't want to have to delete a 62 page report from the beginning...Help please............. |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Report with formuals already entered
Do you have Automatic Calculation enabled at ToolsOptionsCalculation?
If so and formulas won't update try this trick. Select all cells then EditReplace What: = With: = Replace all. Gord Dibben MS Excel MVP On Sat, 30 Jun 2007 16:00:01 -0700, OldHen999 wrote: I'm doing an old 2006 audit report with formulas entered...I'm saving as a 2007 report and changing the numbers...The formulas are correct, but it won't automatically accept any of my new numbers and formulate...It's like the old report was formatted or saved a certain way...That person is no longer working there and noone in the office can figure out what is wrong...I don't want to have to delete a 62 page report from the beginning...Help please............. |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Report with formuals already entered
"Gord Dibben" wrote: Do you have Automatic Calculation enabled at ToolsOptionsCalculation? If so and formulas won't update try this trick. Select all cells then EditReplace What: = With: = Replace all. Gord Dibben MS Excel MVP On Sat, 30 Jun 2007 16:00:01 -0700, OldHen999 wrote: I'm doing an old 2006 audit report with formulas entered...I'm saving as a 2007 report and changing the numbers...The formulas are correct, but it won't automatically accept any of my new numbers and formulate...It's like the old report was formatted or saved a certain way...That person is no longer working there and noone in the office can figure out what is wrong...I don't want to have to delete a 62 page report from the beginning...Help please............. Thank-you Gord...I will try this Monday morning and let you know how it works Monday evening...Oldhen999.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| New to Formuals | Excel Worksheet Functions | |||
| ROUNDING AND 2 FORMUALS IN ONE CELL | Excel Worksheet Functions | |||
| ROUNDING AND 2 FORMUALS IN ONE CELL | Excel Worksheet Functions | |||
| formuals in comments in excel | Excel Discussion (Misc queries) | |||
| excel conditional formuals | Excel Worksheet Functions | |||
Linear Mode
