Startup Prompt External Links

Re: Annoying Startup Prompt

You've already adjusted the menu's Edit [COLOR="Red"]->[/COLOR] Links [COLOR="red"]->[/COLOR] Start-up Prompt [COLOR="red"]->[/COLOR] Don't Display the Alert and Update Links [COLOR="red"]->[/COLOR] OK settings, and it still won't prevent this from occurring? What exactly does your message say?

Quote from Muppley

:smash: I have linked a data worksheet to a workbook in the same folder, but even though I have selected "Automatic Update" and "don't prompt", I am still getting the Startup Prompt when I open the workbook.

The status of the linked worksheet is "OK" and there doesn't seem to be any issue regarding the link. I have checked the settings in Tools>Options>Edit and the "Ask to update..." option is unchecked.

Does anyone have the answer to this annoying "pop-up" for me?

Re: Startup Prompt External Links

Well, providing you've already gone through the menu process as previously noted, I really have no idea why this would occur--unless of course you've got a broken link, in which case you'd see an Error when you go to Edit Links box and would need to update it.

Quote from Muppley

It says "this workbook contains one or more links than cannot be updated" withe options to "Continue" or "Edit Links..." I click edit links and the status is showing "OK" and Update is "A", which I guess means Automatic.

Re: Startup Prompt External Links

there might be named ranges referring to missing files, a macro button pointing to a macro in a missing file.

Re: Startup Prompt External Links

H1H
I don't know if that advice fixed the Muppley's problem, but I've been having similar issues with worksheets (that were copied, then revised and re-used) where I was unable to get rid of old links that no longer existed. When I checked for named ranges, there they were, so I deleted and problem gone!

Thanks!!!
Steve:

No question asked, so this is OK.