Workbook links must be maintained and updated to function properly. You will need to refresh them to get the latest values and locate them in your workbook if they break.

You can remove a hyperlink from a single address, remove many links at once, turn automatic hyperlinks off, and turn off the requirement to press Ctrl to follow a hyperlink.

In the Links list, click the correct path to the linked worksheet, and then click Update now. If you don't know what happened to the external file, click Break Link.

If you can't find or don't have access to the document that you originally linked to, you can prevent Excel from trying to update the link by turning off automatic updates or removing the link.

Find and remove a circular reference. You can also learn about the circular reference warning message and iterative calculation in Excel.

To preserve the spaces in your link text, use an opening and closing chevron, as in the following examples: <\\networkshare\February Expense Report.xls> or …

Step 1: Identify the broken workbook links in the "Update broken workbook link" section and select the update link option on the presented card. Step 2: In the "Change source" option, select the …

Discusses a problem in which the hyperlinks are removed or invalid after you sort cells that contain these hyperlinks in Excel.

With SharePoint Online, if you send someone a sharing link, those people will still be able to access the same file using that link, even after you rename it. But if you previously sent them a …

Unfortunately, you can't do this in Excel. Instead, create a new column next to the column that has the cell you want to split and then split the cell. You can also split the contents of a cell into …