Pivot table shows wrong data in online excel

Question

I am working with an online excel. This excel has got 10 pivot table. The problem is that the pivot tables show wrong data. However, if I work offline with the pivot data works correctly. Whi could this happen? Maybe, does not work properly the pivot datas in online excel ?

Thanks in advance

Answer 1

Hi,

Is the data source a local table?

How did you create the PivotTable?

Is there a problem with all pivot tables?

Are there any error messages? Please provide specific error information.

The online PivotTable must have certain limitations and cannot be used in the same way as the desktop version of PivotTable.

Here are a few steps you can try to resolve the issue:

1. Try manually refreshing the pivot tables in Excel Online.
2. Verify that the data source is correctly linked and accessible.
3. Turn off the "Enable Background Refresh" option if it's enabled.

Please be a bit more precise to explain your requirement or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.

---

If the response 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.