Troubleshooting "Unable to Refresh" in Excel Linked Workbooks
Power Troubleshooting Techniques:
Go to data --> Connections --> Edit links. A prompt will open that shows all the connection to the work book. Select each source link and choose what happens to it. You can choose to update the data using Update Value button.
You can change the source, open the source, break the links, or check status of the connection. And check for the problematic connection and solve it.
After linked file> click File> Options> Trust Center> Trust Center Settings>External content> Enable Dynamic Data Exchange Server
Launch and check the below settings.
Helpful Resources:
https://answers.microsoft.com/en-us/msoffice/forum/all/how-to-update-excel-links-in-word/ea5288e8-8466-48e4-ba1a-a788015da415
Power Troubleshooting Techniques:
Go to data --> Connections --> Edit links. A prompt will open that shows all the connection to the work book. Select each source link and choose what happens to it. You can choose to update the data using Update Value button.
You can change the source, open the source, break the links, or check status of the connection. And check for the problematic connection and solve it.
After linked file> click File> Options> Trust Center> Trust Center Settings>External content> Enable Dynamic Data Exchange Server
Launch and check the below settings.
Helpful Resources:
https://answers.microsoft.com/en-us/msoffice/forum/all/how-to-update-excel-links-in-word/ea5288e8-8466-48e4-ba1a-a788015da415
Follow my journey
Get my latest posts and updates. Join the Tini community.
