Power Pivot is primarily used for managing data tables and the relationships between them, which makes it easier to analyze data from several tables. Either straight from the PowerPivot Ribbon or when constructing a PivotTable, you may add an Excel table to the Data Model. Today, in this article, we’ll learn three quick and suitable steps to remove the data model from a pivot table in Excel effectively with appropriate illustrations.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
3 Quick Steps to Remove Data Model from Pivot Table in Excel
Let’s say, we have a dataset that contains information about several Sales representatives of XYZ group. The Name of the Sales representatives and their Identification Number, types of Products, and revenue earned by the Sales representatives are given in columns B, C, D, and E respectively. From our dataset, firstly, we will create a data model from the Pivot Table in Excel. Further, we will remove the data model from the pivot table. Here’s an overview of the dataset for our today’s task.
Step 1: Create Data Model with Proper Parameters
In this portion, we will create a dataset to remove the data model from a pivot table in Excel. We will make a dataset that contains information about several sales representatives. We create a data model from the pivot table using our dataset. So, our dataset becomes.
Step 2: Make Data Model from Pivot Table
After creating a dataset, we will make a pivot table using our dataset. This is an easy and time-saving task also. Let’s follow the instructions below to create a data model from the pivot table!
- First of all, select cells range from B4 to E14. Hence, from your Insert ribbon, go to,
Insert → Tables → PivotTable → From Table/Range
- Hence, a PivotTable from table or range dialog box will appear in front of you. From the PivotTable from table or range dialog box, firstly, check the Existing Worksheet.
- Further, type ‘Pivot Table’!$G$4 in the Location typing box.
- At last, press the OK option.
- As a result, you will be able to create a Data Model from Pivot Table using the dataset which has been given in the below screenshot.
Step 3: Remove Data Model from Pivot Table
In this section, we will remove the data model from the creating pivot table. This is an easy and time-saving task also. Let’s follow the instructions below to learn!
- First of all, select cells range from G6 to G11.
- After that, place your cursor on the chart and press right-click on Mouse. As a result, a window will appear in front of you. From that window, select the Remove “Product” option.
- Finally, you will be able to remove the data model from the pivot table which has been given in the below screenshot.
Things to Remember
➜ You can also remove the data model from the pivot table. To do that, simply uncheck the Product option from the PivotTable Fields.
➜ While a value can not found in the referenced cell, the #N/A! error happens in Excel.
➜ #DIV/0! error happens when a value is divided by zero(0) or the cell reference is blank.
I hope all of the suitable methods mentioned above to remove the data model from the pivot table will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.