PowerPoint graphs do not update based on changes made in Excel via SharePoint (Office 365)

Question

I have had a continuing problem where PowerPoint graphs do not update when I make changes to the originals in Excel when using Office 365 via files in SharePoint.

The feature works fine when files are stored locally on my computer, but it never reliably works when working on SharePoint. The refresh data button used to give me errors, but now it just gives me false positives, telling me the graph is updated when it is in fact not.

The few times it has worked, it immediately breaks if any of the files are opened through desktop applications and saved which is incredibly annoying since I am not the only one working on these files and office 365 apps are hard to work with compared to the desktop applications with more features and more user friendly experience.

I can't even link objects to other files on SharePoint, the option is greyed out and inaccessible. This means I have to constantly delete and re-copy paste all objects and graphs on a presentation with over 10+ objects I have to replace very week.

Is there some workaround to this?

Answer 1

Dear LJose_Perez_2,

Greetings! We appreciate your post on the Microsoft Community and we’re here to assist you.

I'm truly sorry for the inconvenience you are experiencing because of the PowerPoint graphs which do not update based on changes made to the SharePoint Excel file. We understand that this issue can be frustrating, and we sincerely apologize for any inconvenience caused. We value your understanding.

After carefully analyzing your issue description and conducting further investigations on our end, we have concluded that this issue requires more resources and expertise than our forum team currently possesses. Therefore, I recommend that you create a support ticket with Microsoft Support directly by following steps from this link: Get support - Microsoft 365 admin | Microsoft Learn

If you are not an admin, you can contact your admin to contact Microsoft support. You can look for the way to find your admin through this link: How do I find my Microsoft 365 admin? - Microsoft Support

Please accept my sincere apologies for not being able to resolve the problem and for redirecting you to the related development team. I regret any inconvenience this may cause. The fix to your concern can be identified through the background logs, and I suggest you raise a support ticket from the Office 365 admin center, where the related team will investigate the problem further by collecting the necessary background logs.

Once again, I apologize for the inconvenience this has caused. We appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Ralph Chawatama | Microsoft Community Moderator