Excel query - Very Urgent

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.

Replies (5)

attach file so someone can help you.

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..

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

Thanks all of you for ur suggetions.

try this 

open the Excel

then click Tools Menu > Options

then click on calculation Tab 

Enable the Automatic calculation

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
ARTICLESHIP 18 November 2026
Articled Assistant

A.Singhi & Co

Kolkata

CA Inter

View Details
Company
10 November 2026
Direct Tax Manager

CAAQ CONSULTANCY PVT LTD

New Delhi

CA Final

View Details
Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
13 November 2026
Chartered Accountant - Fresher

Neeraj Bhagat & Co

New Delhi

CA

View Details
Company
Featured 17 November 2026
Chartered Accountant

M/s. A V C & Co.

New Delhi

CA

View Details
Company
Featured ARTICLESHIP 28 October 2026
CA- Inter and Articles

N N V Satish & Co.,

Hyderabad

CA Inter

View Details
Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details