Remove Data Model from Pivot Table in Excel (with Easy Steps)

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.

remove data model from pivot table in excel


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.

remove data model from pivot table in excel

Read More: How to Get Data from Data Model in Excel (2 Easy Methods)


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.

remove data model from pivot table in excel

  • 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.

Read More: How to Create Calculated Field in Pivot Table Data Model


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.

remove data model from pivot table in excel

  • Finally, you will be able to remove the data model from the pivot table which has been given in the below screenshot.

Read More: How to Remove Table from Data Model in Excel (2 Quick Tricks)


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.

remove data model from pivot table in excel

➜ 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.


Conclusion

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.


Related Articles

Md. Abdur Rahim Rasel

Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo