Excel query - Very Urgent

1076 views 5 replies

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 16 July 2026
CA Inter, CA Intermediate, CA IPCC, CA CPT, CA SemiQualified

Vakilsearch.com

Chennai

CA Inter

View Details
Company
ARTICLESHIP 16 July 2026
Article Assistant

G A R U D & Associates

New Delhi

CA Inter

View Details
Company
23 July 2026
Semi qualified CA

Garg Bros & Associate CA

New Delhi

CA Inter

View Details
Company
16 July 2026
Manager - Finance & Accounts

Aliens Group

Hyderabad

CA Final

View Details
Company
Featured 18 July 2026
CA Articleship

apricus india

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 30 June 2026
Taxation Content Writer Intern

Interactive Media Pvt Ltd.

New Delhi

CA Inter

View Details
Company
13 July 2026
AVP / VP - PCG Advisory

Workforce Connect

Mumbai

MBA

View Details
Company
06 July 2026
Chartered Accountant (Indirect Taxation)

Gowra Ventures Pvt Ltd

Hyderabad

CA

View Details