refreshing linked workbooks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Excel 97, I have cells in workbook A linked to cells in workbook B. With
both workbooks open, is there any way to refresh workbook A so that I get any
new saved data entered in workbook B without closing workbook A and
re-opening it? A hotkey or something like that?
 
If you open both workbooks in the same instance of excel, then you'll see that
behavior. But if you have each workbook open in another instance, then the
changes aren't changes to the receiving workbook until that sending workbook is
saved.

And you can refresh your links via:
Edit|links|Updates values

(After that save, though)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
How to refresh links across workbooks 1
DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET 6
Link To File That No Longer Exists 1
trouble with closed workbook 2
Refresh pivot table in workbook A when changing a cell in workbook 2
problem with linked workbook 1

Back
Top