Excel in SharePoint doe not refresh graphs

Akbar Siddiqi 1 Reputation point
2021-10-04T16:09:06.737+00:00

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.
137504-screenshot-24.png

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,206 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,561 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,638 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Du-MSFT 41,691 Reputation points Microsoft Vendor
    2021-10-05T09:59:39.927+00:00

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