When your connected spreadhseet contains this popup

Choose Edit Links The next window will reveal which links are broken

Click on the links that have the status “Error: Source not found” then select Change source to update the broken link. And … Whalla you issue is fixed.