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

Refresh Excel formula results???

Status
Not open for further replies.

flip79

MIS
Jul 5, 2002
23
0
0
US
A coworker has a spreadsheet where the results of a formula on 1 worksheet are not being refreshed as new information is being inserted on another sheet (the new information is used in the formula). Is there any way to do a refresh for an entire worksheet? Currently, she has to go into each formula and hit enter for the correct results to show up. Thanks so much for any help!!
 
Hi,

Have you tried pressing the F9 key. Or turning on Automatic recalc. Tools/Options/Calculation tab.

Rgds
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top