refreshing a linked sheet

  • Thread starter Thread starter ayl322
  • Start date Start date
A

ayl322

If i have a sheet that takes info from another sheet, and i update inf
in the second sheet, is there a way to "refresh" the first sheet s
that it is updated with the new data in the second sheet?
Currently I'm closing and reopening the sheet for it to update, but i'
wondering if there's a faster way.

Thanks
 
Something doesn't sound right.

If *both* sheets are open, then the link should update automatically and
immediately, *UNLESS* you have calculation set to *manual*.
If this is unintentional, set calc to auto by:
<Tools> <Options> <Calculation> tab,
And check "Automatic".

If, for some reason, you have calc set to manual, and you wish to keep it
that way, then simply hit <F9>, and the sheet will update, without having to
close and open it.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

If i have a sheet that takes info from another sheet, and i update info
in the second sheet, is there a way to "refresh" the first sheet so
that it is updated with the new data in the second sheet?
Currently I'm closing and reopening the sheet for it to update, but i'm
wondering if there's a faster way.

Thanks!
 
Back
Top