| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
why won't my excel spreadsheet formulas update when I copy them?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
why won't my excel spreadsheet formulas update when I copy them?
A little more detail would help, but perhaps you have absolute
addresses in the formula, so they will always calculate to the same value. Perhaps your worksheet is set to Manual Calculation mode (click on Tools | Options | Calculation tab to change it). Or maybe the cell is formatted as text - format the cell(s) as General, then F2 followed by <Enter to change them. Hope this helps. Pete On Apr 7, 9:32*pm, Espresso Wendy <Espresso wrote: |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
why won't my excel spreadsheet formulas update when I copy them?
On Tuesday, 8 April 2008 00:32:03 UTC+4, Espresso Wendy wrote:
thank you very much....its a new lesson for me .// past few days am trying to solve the issue.. thanks.....now its working |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why wont my formulas copy all the way down my excel spreadsheet??? | Excel Worksheet Functions | |||
| hOW DO i COPY FORMULAS FROM ONE SPREADSHEET TO ANOTHER IN EXCEL | Excel Discussion (Misc queries) | |||
| How do i copy a spreadsheet with the formulas? | Excel Discussion (Misc queries) | |||
| Update all formulas on spreadsheet - Apr05! to May05! | Excel Discussion (Misc queries) | |||
| copy worksheet ... formulas do not update | Excel Worksheet Functions | |||
Linear Mode
