Skip to main content
Participating Frequently
May 25, 2022
Question

Broken links to excel

  • May 25, 2022
  • 2 replies
  • 654 views

Hi!

I have a document that has several links to excel. Some of these links were broken.

Any ideas why a link would give me the red triangle error and not allow me to either update the current link or even relink the table to excel. Is there any way to fix this red triangle error (i have attached screenshot). The excel file has not been moved to another location.

This topic has been closed for replies.

2 replies

Diane Burns
Inspiring
May 25, 2022

To add to Bob's reply, assume you still have spreadsheet linking set in Preferences > File Handling? Also, what happens if you simply re-link the Excel file?

Participating Frequently
May 26, 2022

Hi Diane, thanks for the reply. When i re-link the file it gives me the same error. Could a change of tab name potentially be causing this? Yes spreadsheet linking is still set.

BobLevine
Community Expert
Community Expert
May 26, 2022

Yes, it absolutely would cause an error. Once you place the file, you're pretty much committed to not changing anything but the content.

BobLevine
Community Expert
Community Expert
May 25, 2022

Turn off the smart sync feature in OneDrive so the files are fully sync'ed to your hard drive.

Participating Frequently
May 25, 2022

Hi. Thanks so much! I am not 100% sure what you mean. Do you mean that the file needs to have a green tick next to it on onedrive? I can't seem to find the smart sync feature you are referring to.

Thanks!

BobLevine
Community Expert
Community Expert
May 25, 2022

Yes, that's what it means. In File Explorer, right-click the folder containing this project and choose "Always keep on this device."