Forum Discussion
embedded word document loses links when saving Excel to new name
I have a main takeoff form in excel that I want to automatically populate to my word document quote form. I embedded the word document quote form into my excel takeoff form and created the necessary formatted links. Everything works properly until I save my generic takeoff excel form as new name.
What can I do to make the link follow the excel takeoff even when renaming it?
Thanks in advance.
- Use relative paths where applicable.
Update links in the embedded Word document if they break.
Consider using VBA to handle automatic updates.
Store the Word document in a shared location if feasible.
