So please help us in understanding on how to establish the multiple broken links in one go.
I have one Master excel file called "00" containing 3 sheets "00", "01", "02". I need to have 2 separate excel files called "01" and "02" that connect to "01" and "02" sheets in master file "00".
It is impossible to have two places where you can view and edit cells that are updated both ways.
The key problem is here that the data doesn't have one authentic source and in general, this is a bad design pattern.
For example, you might want to verify that it is the workbook that you want the external reference to point to, or make changes to the source workbook.
You can also easily change the source workbook in an external reference.
Dear all, At this moment I have an Excel report which has over 10 different sheets.Microsoft is conducting an online survey to understand your opinion of the Technet Web site.If you choose to participate, the online survey will be presented to you when you leave the Technet Web site. As part of document migration to Share Point Online, we have link established documents.Post- migration we need to establish the broken links between the documents in Share Point Online.I am moving files to a faster server and the files now exist in "\10.1.0.250\production\file.pdf".I tried find and replace, but that doesn't work for hyperlinks. So I'll give you two alternatives that might come close to what you want.Embed or link The best option (as far as I understand your situation) is that you embed or link from the 00 file to the other files?Down below you will see a simple picture to make sure you fully understand me: In the ideal situation people would change the cell from f.e.February 2016 to March 2016 -- clicking on the macro should update all the links that are stored in this folder.