Linked Workbook and External Data Connection Audit
Find fragile links between files.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
Audit the external links and data connections of a workbook. List of links, data connections, paths and refresh settings: [LINK_LIST]. Who owns the source files: [OWNERS]. Problems when opening the file: [OPEN_PROBLEMS]. Check broken paths, links to personal folders, credentials stored in connections, automatic refresh that could overwrite data, security prompts people click through, and sources nobody maintains. Recommend a simpler design where possible. Return a table with Link, Source, Risk (red, amber, green) and Fix, a score from 1 to 10 for robustness, and a migration plan that keeps a dated backup. Credentials must never be shared; rotate any that were exposed. Also suggest listing all links on a documentation sheet, replacing live links with scheduled imports where appropriate, and testing the workbook on a second computer. Note which links would fail if a person left the organisation. I will have a qualified professional verify the final findings. Present them as hypotheses with evidence, not proofs, and keep all examples generic and safe.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.