Hey guys,
So, I have a word doc that has several excel references setup as a "Microsoft Excel Worksheet Object". Everything is working beautifully and everyone is excited about how quick this is. BUT....when I want to make a copy of the doc and the excel file so I can have various scenarios or change customer data, the links in the doc stay attached to the old excel file. Alright, so I got into the file and edit links to change the source. When I do that, either the link doesn't updated and acts like I did nothing at all, or it is changing everything to a single worksheet in the workbook that has about 12 tabs. And it doesn't seem to pick up the same references.
original link:
updated link:
I love the functionality, but do I have to relink every time I want to go from Customer 1 to Customer 2?
Thank you guys!
So, I have a word doc that has several excel references setup as a "Microsoft Excel Worksheet Object". Everything is working beautifully and everyone is excited about how quick this is. BUT....when I want to make a copy of the doc and the excel file so I can have various scenarios or change customer data, the links in the doc stay attached to the old excel file. Alright, so I got into the file and edit links to change the source. When I do that, either the link doesn't updated and acts like I did nothing at all, or it is changing everything to a single worksheet in the workbook that has about 12 tabs. And it doesn't seem to pick up the same references.
original link:
updated link:
I love the functionality, but do I have to relink every time I want to go from Customer 1 to Customer 2?
Thank you guys!
