File>option>Info>Edit links to file > Check status for your links. It will help you to get which one is failed to update.
in my shared excel, data is not updating from the linked excel, showing error in my shared excel like this. "UNABLE TO REFRESH We couldn't get updated values from a linked workbook."
in my shared excel, data is not updating from the linked excel, showing error in my shared excel like this. "UNABLE TO REFRESH We couldn't get updated values from a linked workbook."
Microsoft 365 and Office | Excel | For business | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
3 answers
Sort by: Most helpful
-
Anonymous
2023-04-28T06:45:22+00:00 -
Anonymous
2023-12-08T23:26:55+00:00 When I do File>Options I cannot go to Info because my only option is Regional Format Settings. Both my source workbook book and my destination workbook are web based and in Sharepoint. I selected a range of cell in my source workbook and Ctrl+C. Then, in my destination workbook I Paste link. My range populates but each cell says #CONNECT!
Across the top it says UNABLE TO REFRESH We couldn't get updated values from a linked workbook.
How do I fix this?
-
Anonymous
2023-12-09T03:24:37+00:00 Click Enable content button.