Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Excel PivotTable error "Data source reference is not valid"

View products that this article applies to.


When opening an Excel workbook that contains square brackets in the name (e.g., "foo[1]"), the user will receive the following error message when attempting to create PivotTables using data from within the workbook:

Data source reference is not valid

↑ Back to the top


The cause is due to square brackets being invalid characters in an Excel workbook file name.

↑ Back to the top


This behavior is expected when these conditions occur. In order to work around this, the user would be required to remove all invalid Excel characters from the file name.

↑ Back to the top

More Information

This issue may be seen when trying to open an Excel workbook from Internet Explorer. Internet Explorer creates a copy of the file in the temporary directory, renaming the file with square brackets. This can be avoided by clicking "Save," instead of "Open," when Internet Explorer presents the file to the user.

↑ Back to the top

Keywords: kb

↑ Back to the top

Article Info
Article ID : 2862807
Revision : 7
Created on : 8/20/2020
Published on : 8/20/2020
Exists online : False
Views : 264