I get this message sometimes when opening a workbook. Often the reason is that I have copied a formula from another workbook (instead of a value).
First I always want to check where these links are before modifying and possible breaking things.
I used a Microsoft support article (ignored the Edge borwser promo) to find the external links:
- Type CTRL+F (opens Find and Replace Window)
- Click [Options >>]
- Fill in these values:
- Find What: \[
- the MS article uses [, but I got some false positives from that
- Within: Workbook
- Look in: Formulas
- Click [Find Next] to search
- On the Data tab, in the Connections group, click Edit LinksHere you can optionally update (and break) the links, but you do not see in which cells they are used (that is why I searched for them first).
- Click [Startup Prompt...]
- Select the option that you want
Worked like a charm! Thank you.
ReplyDelete