What is the best way to refresh Word links to Excel? 1

[hoghoopfan]

I have a Word document with fields that link to Excel cells? I want to:<br>
1) Verify that the links are still intact when the user opens the Word document.<br>
2) If the links are broken, pull up a windows dialog box and allow the user to select an Excel spreadsheet and do the refresh.<br>
<br>
Chris

 

[Dreamboat]

1) When you open a Word document that contains links, a dialog box appears that asks if you would like to update them. If you hit No, and decide later that you want to update them, hit ctrl-a to select all, then hit the F9 key.<br>
<br>
2) Select Yes when asked if you would like to update the links and, if Word can't find the Excel file, it should automatically ask what file you want to link to.<br>
<br>
To &quot;reclaim&quot; links, all you have to do is hit Edit-Links.<br>
<br>
Make sure that &quot;update automatic links at open&quot; is selected under Tools-Options-General tab.

 

[Storyteller]

Hello, <br>
<br>
If your users want to see what is linked to the Word Doc try this:<br>
<br>
1. &lt;Edit&gt; select &lt;Links&gt;<br>
2. They will then be able to &lt;Change Source&gt;, &lt;Update&gt;, etc<br>
<br>
Hoe this helps<br>
<br>
MO