PDA

View Full Version : Disable link prompt from showing



chi
07-31-2007, 03:43 PM
I have created a link in my workbook (destination). Everytime the workbook opens, a message displays "This workbook contains one or more links that cannot be updated." It gives the option to "Continue" or "Edit Links".
I've tried to do the following but the message still displays everytime it is open:
1. Tools, Options, Edit, deselect "Ask to update automatic links"
2. Tools, Options, Calculation, select "Automatic
3. Edit, Links, Startup Prompt, "Don't display the alert and update links"

None of these steps have stoped the display from showing.
However, the prompt does not show when the source workbook is also opened but I dont want to have the source workbook opened everytime I or someone elses opens the workbook (destination).
Any suggestions???