A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Hello , Jeff Hass
Welcome to Microsoft Community and appreciate your time taken for sharing detailed information. I understand that you want to know why Microsoft Office has identified a potential security concern and how to recover the link.
To solve your problem, you can add the .pub file as a trusted document as well, or list the publisher of the file as a trusted publisher. Then see if the problem recurs. Active content (macros, ActiveX controls, data connections, and so on) opens without the Message Bar warning after you mark the file as trusted. For a trusted document, there is no prompt when you open the file, even if new active content was added, or changes are made to the existing active content. However, the prompt does appear if the file was moved since you last trusted the file.
Not all files can be listed as trusted documents. As for which documents do not meet the criteria, and other things to be aware of, check out: Trusted documents (microsoft.com)
How to add a trusted location or trusted publisher, see:
Add, remove, or change a trusted location (microsoft.com)
Add, remove, or view a trusted publisher (microsoft.com)
Feel free to post back if you have any additional questions.
Best Regard,
Yuhao Li| Microsoft Community Support Specialist