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."

Anonymous
2023-04-28T05:13:55+00:00

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.

0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Anonymous
    2023-04-28T06:45:22+00:00

    File>option>Info>Edit links to file > Check status for your links. It will help you to get which one is failed to update.

    1 person found this answer helpful.
    0 comments No comments
  2. 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?

    0 comments No comments
  3. Anonymous
    2023-12-09T03:24:37+00:00

    Click Enable content button.

    0 comments No comments