banner_ad

Excel query - Very Urgent

Excel for Finance 1049 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


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
21 May 2026
Associate

PWC

Kolkata

CA

View Details
Company
ARTICLESHIP 09 June 2026
Article Trainee

Numbertree LLP

Mumbai

CA Inter

View Details
Company
09 June 2026
Accounts Associate

S Madan and CO

Delhi

Graduate (Any)

View Details
Company
26 May 2026
CA / MBA (Finance) / CMA / M.Com (Finance)

Sri Aurobindo Gnostic Centre of Education

New Delhi

CA

View Details
Company
26 May 2026
Education Content Creator

Adyayam Education LLP

Bengaluru

CA Foundation

View Details
Company
ARTICLESHIP 31 May 2026
Article Assistant

KPRS And Associates

New Delhi

CA Inter

View Details
Company
26 May 2026
Senior Accountant cum purchase Manager

Vardhaman Group of India

Pimpri Chinchwad

CA Inter

View Details
Company
16 May 2026
Audit clerk

mgirt & co

Bengaluru

CA Inter

View Details