Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas
I regularly copy worksheets on from month to month then just change the data
not the formulas. This time, although the correct formula is in the cell, the formula doesn't work. Any ideas please? -- Es |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas
What is your formula and what kind of data are you entering that will affect
the formulas. "ES" wrote: I regularly copy worksheets on from month to month then just change the data not the formulas. This time, although the correct formula is in the cell, the formula doesn't work. Any ideas please? -- Es |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas
Check that <tools<options<calculate is not set to manuel
"ES" wrote: I regularly copy worksheets on from month to month then just change the data not the formulas. This time, although the correct formula is in the cell, the formula doesn't work. Any ideas please? -- Es |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas
bj, you're a genius! You've saved me hours of frustration and trial and
error. Thank you very much and thank you Tim m for your interest. -- Es "bj" wrote: Check that <tools<options<calculate is not set to manuel "ES" wrote: I regularly copy worksheets on from month to month then just change the data not the formulas. This time, although the correct formula is in the cell, the formula doesn't work. Any ideas please? -- Es |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |