Edit Links Dialog

link - https://docs.microsoft.com/en-us/office/troubleshoot/excel/update-external-links
SS

OK, no action is required. The link is working and is current.
Unknown, click Check Status to update the status for all links in the list.
Not applicable, the link uses OLE or Dynamic Data Exchange (DDE). Excel cannot check the status of these types of links.
Error: Source not found, click Change Source, and then select the appropriate workbook for the link.
Error: Worksheet not found, click Change Source, and then select the appropriate worksheet in the appropriate file. The source may have been moved or renamed.
Warning: Values not updated, click Update Values. The link was not updated when the workbook was opened.
Warning: Source not recalculated, click Open Source, and then press F9 to calculate the workbook. The workbook may be set to manual calculation in the source file. To set the workbook to automatic calculation, click the Microsoft Office Button, and then click Excel Options. On the Formulas tab, click Automatic under Calculation options.
Error: Undefined or non-rectangular name, some names cannot be resolved until you open the source workbook. Click Open Source, switch back to the destination workbook, and then click Check Status. If this does not resolve the issue, make sure that the name is not missing or misspelled. Switch to the source workbook, click the Formulas tab, click Define Name, and then look for the name.
Warning: Open source to update values, click Open Source. The link cannot be updated until you open the source.
Source is open, the source is open. No action is required unless you receive worksheet errors.
Values updated from file name, no action is required. The values have been updated.
Error: Status indeterminate, Excel cannot determine the status of the link. The source may contain no worksheets. Alternatively, the source may be saved in an unsupported file format. Click Update Values.

link - https://support.microsoft.com/en-gb/help/925893/external-links-may-be-calculated-when-you-open-a-workbook-that-was-las