Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Cells do not update.

Status
Not open for further replies.

yamcha

Technical User
Jan 31, 2001
76
MX
Hi.
I have a problem with a worksheet in Excel, I have an Operation with SUM, and i see the Result Ok, but when i try to use this Result in another Cell, this appear Ok the first time, when the Cell with the SUM changes, the other cell keep same, and i have to push <F9> to update the Cell.
I take the SUM result with &quot;=N128&quot; operation, to use in another Cell.

I want to the value update automatically.

I am working in the Same Sheet, and i have Win2000 Prof with Office 2000.

Any Idea ?
Thank You.
 
Check Tools, Options, Calculation Tab. Make sure &quot;automatic&quot; is selected.
 
I already check that, but the problem do not disappear.

Any other Idea?

Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top