Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
refreshing linked workbooks
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
refreshing linked workbooks
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) mike47338 wrote: 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? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linked cells to workbooks in different folders | Excel Discussion (Misc queries) | |||
LINKED WORKBOOKS - TOTAL CONFUSION | Excel Worksheet Functions | |||
Finding linked cells to other workbooks | Excel Discussion (Misc queries) | |||
Updating linked workbooks | Excel Discussion (Misc queries) | |||
Controlling Linked Data to Workbooks | Excel Worksheet Functions |