| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
why is excell not updating my formula data within a workbook?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
why is excell not updating my formula data within a workbook?
Make sure calculation is set to automatic.
ToolsOptionsCalculation tabAutomaticOK -- Biff Microsoft Excel MVP "jimmy" wrote in message ... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
why is excell not updating my formula data within a workbook?
T. Valko wrote:
Make sure calculation is set to automatic. ToolsOptionsCalculation tabAutomaticOK F9 do it too. Right ? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
why is excell not updating my formula data within a workbook?
Make sure calculation is set to automatic.
ToolsOptionsCalculation tabAutomaticOK F9 do it too. Right ? Well, yes, sort of; F9 will recalculate the sheet... once. What Biff posted is a permanent re-setting of the option (well, permanent until changed again at least<g). Rick |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
auto update formula data in linked workbook ?
And me also get a message
'Unable to read file' after I click OK when Excel give the options to update the links or not. How to solve this? I want the automatic update everytime I open my workbook. Please help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically updating a workbook from a different workbook day by | Excel Discussion (Misc queries) | |||
| My workbook links are not updating (its 30,000 KB size workbook). | Excel Discussion (Misc queries) | |||
| Stopping a workbook updating | Excel Discussion (Misc queries) | |||
| Updating data makes formula wrong | Excel Discussion (Misc queries) | |||
| Auto updating a workbook with data from another workbook | Excel Discussion (Misc queries) | |||
Linear Mode
