Pivot Table Issues

Fix Excel 2019 Power Pivot Error When Adding a Table to the Data Model

Tauseeq MagsiTauseeq Magsi Nov 14, 2026 868 views

Question details

Resolve an error when adding a table to the Excel 2019 Data Model with Power Pivot enabled.

Fix the Excel 2019 Power Pivot Error When Adding a Table to the Data Model
Product
Microsoft Excel 2019 Power Pivot
Device & OS
Windows
Scenario
The user wants to add a table to the Data Model for use with Power Pivot.
Observed behavior
Excel reports an error when the user tries to add the table to the Data Model.
Before you start

Note the exact error message and check whether the same action fails in a new workbook. Confirm that Power Pivot is enabled under File > Options > Add-ins > COM Add-ins.

Solution 1Recommended

Test Excel in Safe Mode and Check Whether Other Workbooks Are Affected

Use Safe Mode and a new workbook to narrow down whether the error is specific to a workbook or the Excel environment.

1
Start Excel in Safe Mode

Close Excel, press Windows+R, enter excel /safe, and select OK.

2
Test a new workbook

Create a workbook, enter sample data, select the data, and choose Insert > Table. Then try Power Pivot > Add to Data Model.

3
Compare the results

Repeat the action in the affected workbook. If the new workbook works but the original fails, focus troubleshooting on the original workbook. If the error occurs only in normal mode, review add-ins under File > Options > Add-ins.

Test Excel in Safe Mode and Check Whether Other Workbooks Are Affected
Safe Mode limitation: Safe Mode may prevent add-ins, including Power Pivot, from loading. If Power Pivot is unavailable, restart Excel normally and continue with the update and repair steps.
Free Microsoft Office alternative

Work with Excel Spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel file formats. Open existing spreadsheets to make the transition easier. WPS does not repair Microsoft Excel or its Power Pivot add-in.

Open and edit spreadsheets in a familiar interfaceWork with Microsoft Excel XLS and XLSX filesUse PivotTables to summarize spreadsheet dataUse a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

How do I check whether Power Pivot is enabled?

In Excel, open File > Options > Add-ins. Select COM Add-ins in the Manage list, choose Go, and check Microsoft Power Pivot for Excel.

What if the error occurs in every workbook?

Update Windows and Office, then repair Office through Control Panel > Programs > Programs and Features. You can also test Excel in a new Windows user profile to see whether the issue is profile-specific.

Can I add data to the Data Model without the Power Pivot button?

For data in another workbook, try Data > Get Data > From File > From Workbook. In the load options, select Only Create Connection and check Add this data to the Data Model.

What should I collect if troubleshooting does not resolve the error?

Record the exact error message, when the problem started, whether it affects all workbooks, and the Office product and version shown under File > Account. Provide these details to Microsoft support.