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
- Nznxnc call me at the end of the day of the
- Nsje snswk fjw ed le ene djff ne enje ejdd rejje
- Hxjcif the day I have been in touch with me and
- Iska djd djrbdsjebshe sir ur rei ejr reinr the jr
- GST registration for medical shop in Karnataka
- Hsshs me know if you are free number of the
- Chu Kang and the situation of the situation and I
- How to reverse wrong transaction payment in phonep
- Paytm wrong transaction
- How to reverse wrong transaction payment in phonep
Related Threads
CAclubindia
