| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I refresh the formulas in Excel?
I created a templet. I entered some formulas as total, averages, etc, but,
later when I enter some data those formulas don't work, and I have to get those results manually, could you help me? |
|
#2
|
|||
|
|||
|
If you press F9, does it compute?
Check that the calc mode is not inadvertently set at: "Manual" : Click Tools Options Calculation tab Ensure "Automatic" is checked OK -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Lucy V" <Lucy wrote in message ... I created a templet. I entered some formulas as total, averages, etc, but, later when I enter some data those formulas don't work, and I have to get those results manually, could you help me? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: Clear all cell entries EXCEPT formulas? | Excel Discussion (Misc queries) | |||
| Refresh Imported Data - Does the Excel file have to be open? | Excel Discussion (Misc queries) | |||
| How to refresh a Excel workbook with pivot & ADO query report in batch mode | Excel Discussion (Misc queries) | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
| How Excel & ACCPAC 6.1 calculate formulas???? | Excel Worksheet Functions | |||
Linear Mode
