Forum Discussion
Unable To Refresh: We couldn't get updated values from a linked workbook
It seems like you're encountering an issue with refreshing data from a linked workbook. This error message typically occurs in software like Microsoft Excel or Google Sheets when
there's a problem with updating data from an external source. Here are some common steps you can take to troubleshoot this issue:
Check the Connection: Ensure that the linked workbook or data source is accessible and hasn't been moved or deleted. Sometimes, the link can break if the source file's location changes.
Permissions: Make sure you have the necessary permissions to access the linked workbook or data source. If it's on a network drive or a shared folder, check if your access privileges are still valid.
Internet Connection: If the linked workbook is stored online or in a cloud service (e.g., OneDrive, Google Drive), verify that you have a stable internet connection. Sometimes, a weak or interrupted connection can prevent data refresh.
Credentials: If the linked workbook requires authentication (e.g., username and password), ensure that you've entered the correct credentials, and they are up to date.
Refresh Settings: Check the refresh settings in your spreadsheet software. Make sure that automatic refresh is enabled if you want the data to update automatically. You can usually find these settings in the data connection or data source properties.
Data Source Changes: If the structure or location of the data source has changed, you may need to update the connection information in your spreadsheet. Verify that the connection details (e.g., file path, URL) are accurate.
Refresh Method: Experiment with different refresh methods. Some software allows you to choose between a full refresh (retrieving all data) and an incremental refresh (only updating changed data). Try both to see if one works better.
Software Updates: Ensure that your spreadsheet software is up to date. Sometimes, software updates include bug fixes that can resolve refresh issues.
Error Details: Look for additional error details or error codes in the error message. This can provide more specific information about what went wrong.
Support Resources: If you're still unable to resolve the issue, consider reaching out to your software's support or community forums. They may be able to provide more tailored assistance based on the specific software you're using.
By following these steps, you should be able to diagnose and hopefully resolve the "Unable To Refresh" issue with your linked workbook or data source.
- promnwJan 24, 2024Copper Contributor
This seems long and unnecessary - Try another version of Excel ?
I can update same query files in Excel 2007 but cannot in 2021. What on earth. I thought we were suppose to be progressing. Seems to come and go. I have turned off all firewall and virus software.