Excel PivotTable error "Data source reference is not valid"
Symptoms
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
Cause
The cause is due to square brackets being invalid characters in an Excel workbook file name.
Resolution
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.
Related Articles
File Sharing
The main ways to share files with internal and external users are listed below. We recommend using either OneDrive or SharePoint website when sharing files. OneDrive (internal and external) SharePoint site (internal and external) Teams (mostly ...
Envoy Mobile App: Setup and Registration
Set up Step 1: Download the Envoy mobile app You can use the Envoy mobile app on any iPhone running iOS 8 or higher or Android 7.0 or higher. Download the app on the Apple app Store or get it from Google Play. Step 2: Create an account Open Envoy ...
Clear Cache for Microsoft Teams
Clearing the cache for Microsoft Teams can quickly and effectively resolve common issues, like app slowness, login problems, or glitches with loading messages and files. Removing temporary files refreshes the app and often eliminates any corrupt data ...