Recently when I open my XLSM files (Excel 2013, Macro enabled workbooks) I see this popup.
Can anyone please tell me what is the cause for this pop up?
I am not referring to any URLs using VBA in my workbook.
Recently when I open my XLSM files (Excel 2013, Macro enabled workbooks) I see this popup.
Can anyone please tell me what is the cause for this pop up?
I am not referring to any URLs using VBA in my workbook.
When a pair of spreadsheets are "Linked", it means that data from one is used in another. These links however are not dynamic, so if the data you linked to changes, the data in your spreadsheet will not change, until the link has been "updated". See here for how to link Excel documents.
See this document for instructions on how to determine the target of a link. the process varies depending on whether the link is to Cell data, used in Formulas, Charts, or other objects, so be sure to check all of them if you have no idea what links might be present.
Once you have decided whether you trust the link target(s), you can decide whether to click the "Update" button and pull in the latest data, click "Don't update" to leave the data as is, or whether to go in and remove the links if you no longer need them.