Linking data between 2 workbooks
I have a general question.
You have two Workbooks open. Workbook 1 and Workbook 2.
You COPY all the data from Workbook 1 and PASTE the data as a 'Link' into Workbook 2.
You then save and close both Workbooks.
You then open Workbook 1 and edit the data. You save and close Workbook 1.
QUESTION
Will the linked data in Workbook 2 update automatically (ie without opening the file)?
The data will update when you open the file according to the tests that I have just done.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There's another slight issue. If Workbook 2 is a CSV file it doesn't seem to update...
In your test were both files saved in Excel format?
Are you able to do a test using a CSV file as Workbook 2?
Both files were Excel 2010 format. A test with a CSV file indicates that a link from the CSV file to the Excel file will work but not from the Excel file to the CSV...at least in my tests.
I'm also using Office 2010.
Do you or does anybody else know a way around this problem.
Auto updating 'linked' data from an Excel workbook to a CSV file (ideally without having to open the CSV file)?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks