| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Items in Workbook won't calc
I have a workbook with several sheets that reference each other and some
simple math on each. I have auto calc on, but at times I find formulas that will not update. I have tried F9 and as I said the auto calc is on. I have to reimput the formula or click in the cell and hit enter to recalc. Any solutions would be GREATLY appreciated. Thanks, Eric |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Items in Workbook won't calc
Hi Eric,
http://xldynamic.com/source/xld.xlFAQ0024.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Eric" wrote in message ... |I have a workbook with several sheets that reference each other and some | simple math on each. I have auto calc on, but at times I find formulas that | will not update. I have tried F9 and as I said the auto calc is on. I have | to reimput the formula or click in the cell and hit enter to recalc. | | Any solutions would be GREATLY appreciated. | | Thanks, | Eric |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Items in Workbook won't calc
replace "=" with "=" seemed to work.
The site you posted is a great reference. Thanks! Eric "Niek Otten" wrote: Hi Eric, http://xldynamic.com/source/xld.xlFAQ0024.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Eric" wrote in message ... |I have a workbook with several sheets that reference each other and some | simple math on each. I have auto calc on, but at times I find formulas that | will not update. I have tried F9 and as I said the auto calc is on. I have | to reimput the formula or click in the cell and hit enter to recalc. | | Any solutions would be GREATLY appreciated. | | Thanks, | Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Repost:Automatically inserting a row in external workbook | Excel Discussion (Misc queries) | |||
| keeping a toolbar attached to a workbook | Excel Discussion (Misc queries) | |||
| Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
| How to hyperlink from a workbook to sheets in another workbook? | Excel Worksheet Functions | |||
Linear Mode
