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 |
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 |
All times are GMT +1. The time now is 05:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com