![]() |
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? |
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? |
All times are GMT +1. The time now is 10:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com