Errors in Linked Tables Dialog Box

The Errors in Linked Tables dialog box enables you to view errors that affect PowerPivot tables that are linked to Excel tables. When you create a table in Excel and then generate a linked table in the PowerPivot workbook, the tables are linked by name and have identical data in them. However, as you continue to make changes to the data in Excel, errors can occur. You can fix the errors by editing the table directly or by using the Select Action Dialog Box (Linked Table Repairs), which is available from the Options button.

  • Options
    Click to open a dialog box that presents options for fixing the errors.

  • OK
    Click OK to ignore the error and continue working.

See Also

Other Resources

Add Data by using Excel Linked Tables

Take a Tour of the PowerPivot UI