Share via

Using pivot table and it states DATA SOURCE REFERENCE IS NOT VALID

Anonymous
2023-09-24T16:40:18+00:00

I was using pivot table and decided to pull the dates out of my time stamp and now pivot table reads data source reference is not valid

Any suggestions

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-09-25T01:46:03+00:00

    The error message "Data source reference is not valid" in a PivotTable usually indicates that the data source range for the PivotTable has been changed or deleted. To resolve this issue, you can try the following steps:

    1. Check the data source range: Make sure that the data source range for the PivotTable is correct and includes all the data that you want to analyze. To check the data source range, click anywhere inside the PivotTable, then go to the "PivotTable Analyze" tab on the ribbon and click "Change Data Source" in the "Data" group.
    2. Refresh the PivotTable: If the data source range is correct, try refreshing the PivotTable to update the data. To refresh the PivotTable, click anywhere inside the PivotTable, then go to the "PivotTable Analyze" tab on the ribbon and click "Refresh" in the "Data" group.
    3. Recreate the PivotTable: If the above steps do not resolve the issue, you may need to recreate the PivotTable from scratch.

    9 people found this answer helpful.
    0 comments