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. We can add an Excel table to the Data Model either straight from the PowerPivot Ribbon, or when constructing a PivotTable. In this article, we’ll demonstrate how to add and then remove a Data Model from a Pivot Table.


Suppose we have the dataset below, containing information about several Sales representatives. From this dataset, first we will create a data model from the Pivot Table, then we will remove it.

remove data model from pivot table in excel


Step 1 – Create Data Model with Proper Parameters

Create a Data Model from the pivot table using our dataset.

  • Select the dataset, including the headers (cells B4 to E14).
  • From the Insert tab, select Pivot Table.
  • Select From Table/Range.

remove data model from pivot table in excel


Step 2 – Make Data Model from Pivot Table

The PivotTable from table or range dialog box appears.

  • Check Existing Worksheet.
  • Enter ‘Pivot Table’!$G$4 in the Location box.
  • Click OK.

remove data model from pivot table in excel

The Data Model from Pivot Table is created.


Step 3 – Remove Data Model from Pivot Table

  • Select the range G6 to G11.

  • Place your cursor on the chart and right-click the mouse.
  • Select Remove “Product” from the context menu.

remove data model from pivot table in excel

  • The Data Model is removed from the Pivot Table.


Things to Remember

  • You can also remove the data model from the Pivot Table itself. Simply uncheck the Product option from the PivotTable Fields.

remove data model from pivot table in excel

  • When a value can not be found in the referenced cell, the #N/A! error is returned.
  • A #DIV/0! error will appear if a value is divided by zero (0) or the cell reference is blank.

Download Practice Workbook


<< Go Back to Pivot Table Data ModelPivot Table in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Abdur Rahim Rasel
Md. Abdur Rahim Rasel

MD. ABDUR RAHIM is a marine engineer proficient in Excel and passionate about programming with VBA. He views programming as an efficient means to save time while managing data, handling files, and engaging with the internet. His interests extend to Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning, reflecting his versatile skill set. He earned a B.Sc in Naval Architecture & Marine Engineering from BUET, and now he has become a content developer, creating technical content... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo