Question
If my source file is a CSV, how might that affect the 'Cannot open PivotTable source file' error?
Asked by: USER7195
97 Viewed
97 Answers
Answer (97)
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.