Share via

#N/A error on pivot table

Anonymous
2018-05-04T19:38:24+00:00

Hi All,

In Excel, I have been updating a table for 9 months to feed a pivot table that summarizes the results.

Today when I updated the table and then clicked on refresh to update the pivot table, 3 out of 7 results are showing a N/A error. 

I have not been able to fix it, there are not spaces or data missing, and the data I added is in the same format as the data I have been adding for 9 months.

If anyone has any suggestion on how to fix it, it will be much appreciated.

Thanks.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2018-05-04T20:50:16+00:00

Hi Jason,

I solved, it was a problem of format, I one of the values I copied today had a formula that was causing the problem.

Thanks for your response.

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-05-04T20:29:46+00:00

    Are you able to save a non-confidential copy to OneDrive and post the link here?

    Was this answer helpful?

    0 comments