See if the range is referring to the cells that you want to analyze through the pivot table. Use the Add method to add a PivotTable cache, and then create a PivotTable report based on the cache. 5.On the Step 2 page of the wizard, select the range of data on which you want to base the new PivotTable report, and then click Next. In order to fix the error of pivot data source reference is not valid, you need to make sure the reference for the named range is valid. 3.In the list, select PivotTable and PivotChart Wizard, click Add, and then click OK.-4.On the Step 1 page of the wizard, click Microsoft Office Excel list or database, and then click Next. Ensure the Reference for the Named Range Is Valid You can successfully create the pivot table without encountering the error data source reference is not valid. You can type it out yourself or use the built-in selector.Īfter that, the range is defined. Then use the Refers to box to set the cells that you want to use for the range. In the Name Manager window, click on New and name the range that you are going to create. > Indicates to tap the previous key, releasing it before pressing the next key. #Pivot table wizard excel 2019 mac how to
Click the Formulas tab from the ribbon bar and then click Name Manager to continue. Excel Shortcuts List for Mac and PC (Searchable) How to Use this Shortcut List: + Indicates to hold the previous key, while pressing the next key. So, in order to fix this issue, you need to make sure that the range exists and it is defined. If you are trying to insert a Pivot Table is a non-existing or not defined range, you may come across the error data source reference is not valid. Wizard to link all your data into one PivotTable or PivotChart. Ensure that Range Exists and It’s Defined When all steps are finished, check whether the error of data source reference is not valid is solved. Next, save the Excel file on your physical drive. 
In this case, you need to save this Excel file to the local drive. In this case, the file will be opened from a temporary file, which will trigger this issue. The issue data source reference is not valid may occur if you are opening a file directly from a website or directly from email attachments. Frankly, this is no longer available on Mac.
Then go ahead and remove brackets from the name of the file since Pivots table is not configured to support them.Īfter that, recreate the pivot table and check whether the error of data source reference is not valid is fixed. Excel offers an excellent pivot table help agent that aids you in your creation and editing of pivot tables. Next, right-click it and choose Rename. Then navigate to the location of the Excel file. Close the Excel window that is currently using the file. In order to fix the error of data source reference is not valid, you can try to remove brackets from the file name. In this part, we will show you how to fix the error of data source reference is not valid. 
Read More 4 Ways to Data Source Reference Is Not Valid
0 kommentar(er)
