Excel pivot table not pulling in data from source table(s)

Question

I made a change to a cell in a spreadsheet, which several pivot tables are linked to.  One pivot table captured the change, but not the totals associated with the change.  The other pivot tables didn't capture the change at all.

Answer 1

Hi Joshua,

My table contains sensitive client data so I am not able to share.  I found assistance within my work group to solve the problem.  The table had expanded beyond the cell references listed in one of the calculation cells, and another calc cell was making calls to cells that had blank data.  Once those 2 problems were rectified, the pivot tables displayed data correctly.

Regards,

Lori

Answer 2

Hi Lori,

Thank you for sharing the solution in order that other users encounter the same issue can see it. If you have any further concern on this issue, you are always welcome to post back here.

Regards,

Joshua

Answer 3

I did that several times..... that wasn't the issue.

Answer 4

Hi,

Try once again by going to Data > Refresh All

Answer 5

Hi Lori,

To help us clarify your scenario, please provide some more information:

1. What’s your Office version? Please navigate to Excel > File > Account and show up a screenshot of the error message.
2. Does the issue occur to one file or all files? If it only occurs to one file, could you please share the file with us via private message?

Regards,

Joshua