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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

w2k with excel 2000

Status
Not open for further replies.

hr

Technical User
Nov 11, 2000
29
0
0
CH
have a very tricky problem, since two days the following happens:

if a formula is copied to a other cell then the resulting figures are the same as in the original cell, i.e. the formula is not refreshed or activated

does somebody know help?

 
Maybe Automatic recalculation has been deactivated. Try to press F9 after copying, if value in the cell changes then, you need to reactivate automatic recalculation in Options.
I hope it will help!
 
thanks, it's ok now!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top