If my source file is a CSV, how might that affect the 'Cannot open PivotTable source file' error?

Responsive Ad Header

Question

Grade: Education Subject: Support
If my source file is a CSV, how might that affect the 'Cannot open PivotTable source file' error?
Asked by:
97 Viewed 97 Answers

Answer (97)

Best Answer
(307)
If your source is a CSV file, the error could be due to the CSV file being renamed, moved, or deleted. Ensure the CSV file is saved with a .csv extension and not something else. Also, verify that the file path in the PivotTable's data source setting correctly points to the current location of the CSV file.