I wish to get some suggestions on using which methods to link workbook A with workbook B . The situation is I still manage to get updated data from closed workbook, when open either one workbook only (A or B).
I using Ms 2003, My doubts are:
1. Which method easier for me, as I need to link quite a lot of data from A to B.
2. If I share the workbook on the network, once the network name change, all linking GONE? I have to change one by one?
* I found this formula but do know how to use ='\\myserver\myshare\[source.xls]Prices'!B5 , suggested in Ms Excel website.
3. If using VBA will can work well, can give me some suggestions ?
The Method using COPY ----> PATSE SPECIAL ---> PASTE LINK, cannot work well with update data from closed workbook and sharing workbooks on the network. The reason is once the network name gone = all gone. Please help me, I already finish all the formula for calculation, just the linking part bother me a lot. THANKS A LOT
Last edited by Kenji; 10-26-2009 at 01:50 PM. Reason: Add attachment for clearer understanding
When building workbooks with external links it is always good practice to make sure that all users have the same drive mappings and that the file names will not be be changed without both workbooks being open at the same time.
If you view the contens of the cell you applied the paste special to it will resemble something to the effect of (=[test2.xlsx]Sheet1!$A$1) as long as the source workbook remains open. Once the source workbook is closed the link will change to something like (='C:\Documents and Settings\l53vmc\Desktop\[test2.xlsx]Sheet1'!$A$1).
Yeah, I know this. However, It won't update data from a closed workbook untill the closed workbook is open. I read some website suggest me to use indirect EXT but I dunno how to use it @@
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks