Excel PivotTable error "Data source reference is not valid"

Excel PivotTable error "Data source reference is not valid"


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


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


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 ...
    • Setting Up GoToConnect Mobile App

      With the GoToConnect mobile app, you can stay connected without having to be tied down to a traditional desk phone. Instead of having calls forwarded to your personal cell phone, keep track of all business-related calls from your mobile device! ...
    • Setting Up GoToConnect Desktop

      In addition to the Mobile App, you can also stay connected with the GoToConnect Desktop App! In order to use GoToConnect's soft phone options, you will need to have an existing line configured for you. If you need a direct line and extension, please ...
    • GoTo Meeting: Setting Up + Features

      GoTo Meeting is an online meeting, desktop sharing, and video conferencing software that allows you to organize and meet with other users in real time. Setting Up To kick off the process, you should've received a welcome email prompting you to log ...