I have a workbook that imports a worksheet from another workbook which has links. When the workbook opens, a prompt appears asking if you would like to update the links (attached as Excel Links Problem.bmp). I do not want the prompt to appear and I do not want the links updated.
The Excel help documentation has the following info:
Warning This option affects all users of the workbook. If you choose to not update links, and not to prompt, users of the workbook will not know the data is out of date.<o:p></o:p>
1. On Edit menu, click Links. <o:p></o:p>
2. Click Startup Prompt. <o:p></o:p>
3. Select the option you want. <o:p></o:p>
Note You will still be notified if there are any broken links.
-----------The problem is that the links options is not enabled unless the link already exists in the workbook. It does not exist in my template until I pull it over from another workbook at run time. I have tried to:
1.) pull over the linked worksheet into my template
2.) changed the startup prompt setting to not display a message and not to update the links
3.) saved the template
4.) removed the worksheet with the links
5.) saved the template
This did not resolve the issue and the problem remains. When the workbook is opened, the end user is prompted asking to update the links. I would like this to not be displayed and for the workbook to automatically not update the links and not display a prompt.
Do you have access to this property from Excel’s object model? If so can you add a property to the workbook object to change this functionality? If not, do you have any other suggestions on how to resolve the problem.
Thank you for your help.