Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update of linked files
Dear all,
Does anybody knows how to update linked files, when we are working in the first one and it needs to get information in the second one, without need to open the second? Example, in the first one we have a VLOOKUP funtion and we have the table in the second file that is closed. When the 2nd file is closed it appears #Value when we open it it works well. We are working in Excel2003, in Excel97 it worked... Thanks about your help. Kind regards, Pedro Mestre |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update of linked files
If you choose to not update the links when you open the file, you'll see an
error. This behavior is different than what you saw in xl97. Jim Rech posted a registry tweak: http://groups.google.com/groups?thre...GP11.phx .gbl Pedro Mestre wrote: Dear all, Does anybody knows how to update linked files, when we are working in the first one and it needs to get information in the second one, without need to open the second? Example, in the first one we have a VLOOKUP funtion and we have the table in the second file that is closed. When the 2nd file is closed it appears #Value when we open it it works well. We are working in Excel2003, in Excel97 it worked... Thanks about your help. Kind regards, Pedro Mestre -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to update linked files | Excel Discussion (Misc queries) | |||
update linked pages | Excel Worksheet Functions | |||
Linked Cells Staying With Cells Once Linked Workbook Update. | Excel Worksheet Functions | |||
Linked cells won't update | Excel Discussion (Misc queries) | |||
2 files, mass update comments between files | Excel Worksheet Functions |