The Select Action dialog box enables you to handle errors that affect Power Pivot tables that are linked to Excel tables. To access this dialog box, in the Errors in Linked Tables Dialog Box, click Options.
When you create a table in Excel and then generate a linked table in the Power Pivot workbook, the tables are linked by name, and have identical data in them. However, the following changes to the Excel table can cause errors:
The name of the table in Excel has changed.
The table in Excel has been deleted.
The data in the Excel table has changed data types.
When you refresh a Power Pivot linked table and the source table in Excel has changed, this dialog box presents options for fixing the errors.
List of errors by number
Click the right and left arrows to move through the list of errors, if there are multiple errors.
Error handling options
Select one of the following options for each error in the list: