Fix Excel 2019 Power Pivot Error When Adding a Table to the Data Model
Question details
Resolve an error when adding a table to the Excel 2019 Data Model with Power Pivot enabled.

- 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.
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.
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.
Close Excel, press Windows+R, enter excel /safe, and select OK.
Create a workbook, enter sample data, select the data, and choose Insert > Table. Then try Power Pivot > Add to Data Model.
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.

Update Windows and Repair Microsoft Office
Use this approach if the problem persists across workbooks or points to the Excel installation.
Load a Table into the Data Model Through Power Query
Try this alternative when the table is stored in another workbook and the direct Power Pivot command fails.
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.

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.




