troubleshooting Question

Excel online can't refresh pivot table data

Avatar of Gilberto Sanches
Gilberto SanchesFlag for Suriname asked on
Microsoft ApplicationsMicrosoft OfficeMicrosoft ExcelDB Reporting Tools
4 Comments1 Solution80 ViewsLast Modified:
Hello exports,

We use excel online for collaboration. Pivot tables work fine. But when data is changed, and we want to refresh the pivot table data it gives a error.

Error on refresh
I have no external data source, all of the pivot tables sources are in the workbook.
How can we solve this?
Gilberto Sanches
Freelance ICT Consultant

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros