I want to import certain rows of data from one workbook into another workbook (From A.xls to B.xls). I set up the link just fine when both of the workbooks are open. If i change one, the other will change. However if I make a change to A, save it and close it, and then I open B, the spreadsheet is filled with reference errors. How can I make it to update when only B is open?
Bookmarks