Share via

Can't create a Pivot Table

Anonymous
2019-06-04T17:40:54+00:00

When I try to create a Pivot table it send me an error " Data source Reference is not Valid"  i have the table as far I know correct but i am unable to create a pivot table

Microsoft 365 and Office | Excel | For home | 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
2019-06-04T17:48:31+00:00

Hi CovertEight9,

Thanks for your query in this community.

Based on the error message you received, there is an official article which detailed illustrate on this error:

Excel PivotTable error "Data source reference is not valid"

Please check if there are brackets in your file name. If so, try changing the file name and then create a pivot table.

If this is not your scenario, to help us understand your scenario better, we would like to confirm the following information:

1.A screenshot of the Excel version you are currently running on.

2.The detailed steps that you took to create the pivot table.

Regards,

Alex Chen

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
    2019-06-06T20:54:13+00:00

    Hi CovertEight9,

    Have you checked my suggestions?  Please let us know if you still need help on this issue.

    Feel free to post back when you have time. We will keep monitoring on this thread.

    Regards,

    Alex Chen

    Was this answer helpful?

    0 comments