| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AUTOCALCULATION IN EXCEL IS NOT WORKING WHEN FORMULAS ARE COPIED
I have an existing spreadsheet with multiple calcs.
If I copied an existing formula to the next line the answer is incorrect and will copy the previous calculation as what was shown in the previous calc solution. IE the calculation does not take into account the new variables. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
AUTOCALCULATION IN EXCEL IS NOT WORKING WHEN FORMULAS ARE COPIED
Do you have the fomula set as absolute?
"stan k" wrote: I have an existing spreadsheet with multiple calcs. If I copied an existing formula to the next line the answer is incorrect and will copy the previous calculation as what was shown in the previous calc solution. IE the calculation does not take into account the new variables. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copied graphs not working | Charts and Charting in Excel | |||
| copied formulas on Excel the value doesn't change | Excel Worksheet Functions | |||
| Bug? Autocalculation turns itself on... | Excel Discussion (Misc queries) | |||
| Copied worksheet not working | Excel Discussion (Misc queries) | |||
| Delete the formulas of webpage, copied & pasted on excel sheet | Excel Discussion (Misc queries) | |||
Linear Mode
