Menu
In Excel 2013, I have one table "Table1" in worksheet "Data" and I have a dozen pivot tables in another worksheet named "PivotTable". When I created the pivot tables I was unaware of the checkbox "Add this data to the data model". Is there a way to add all my existing pivot tables to the data model after-the-fact?
764
Click the “Tables” tab within the “Existing Connections” dialog box. A list of the available Excel tables within any opened workbooks then appears. Select the desired table to add to the data model. Then click the “Open” button to add that table to the data model within the workbook.
A Data Model is a new approach introduced in Excel 2013 for integrating data from multiple tables, effectively building a relational data source inside an Excel workbook. Within Excel, Data Model is used transparently, providing tabular data used in PivotTables and PivotCharts.
If you go to the existing pivot table, below the list of fields you have available, there should be a line that says More Tables.... Click on that and it'll remake your pivot table in a new tab with that data model option checked. You do lose your number formatting, but it sure beats remaking the whole stupid thing!
133
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
