Excel in SharePoint doe not refresh graphs

Akbar Siddiqi 1 Reputation point

We are using our Excel in SharePoint.
In SharePoint I can’t “Refresh connections”. I receive an error message. So the pivot tables and graphs do not update.
How can I fix this error?
See attached screenshot.

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,297 questions
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,255 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,689 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emily Du-MSFT 44,071 Reputation points Microsoft Vendor

    @Akbar Siddiqi

    Whether this error occurs suddenly? Could you refresh normally before?

    How the data source is referenced? Through the same workbook or another type of data source?

    Will you get an error when you download this file then open it locally with the client application?

    Please check whether the path of the data source is correct.

    And you could backup the file, rename it and open it again, check whether this error occurs.

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.