In my excel worksheet formulas are not getting updated automatically. I have to press F9 function key for updating formula result. Pls provide help for updating formula results automatically.
5 Replies
Sathyanarayanan
(CA Final & CWA Final)
(30 Points)
Replied 21 October 2010
Hi,
Try this. Click on the top-left corner of the worksheet area ie. the point that joins rows and columns. Then click - Format-->Row-->Unhide.
See if this helps..
Ankit Jain
(Article (Final))
(110 Points)
Replied 21 October 2010
I have also faced this problem some time ago.
This problem occurs when u using long formula in same seet for long time.
Do the following u can overcome your problem.
copy entire area of sheet (not whole sheet) and past it in New sheet. Now your formula get updated. it is simple.
Thanks
CA Prateek Garg
(CA in Practice)
(1447 Points)
Replied 21 January 2011
try this
open the Excel
then click Tools Menu > Options
then click on calculation Tab
Enable the Automatic calculation
Recent Topics
- How can I check the platform number for my train?
- Gratuity under CTC
- GST refund paid as estimated tax liability
- Salary Income and Professional services income
- Sec 54 and TDS on sale of property
- Airbnb Manager - I manage properties for owners
- Wrong head ed for late fee
- Inter Company trnafer
- Job work-Reg
- Who is liable to pay GST if bank charges excl GST
Related Threads
Trending Online Classes
-
Landmark Judgments: Important Provisions of the EPF & ESI Act interpreted by the Honorable Supreme Court of India
Mr.Balamurugan Ranganathan15 November 2024
CAclubindia
