To Refresh Data and Layout in a Table Placed from an Excel Workbook

If you have a table placed from an Excel workbook and the Retain Association option is turned on, any changes made in both data and layout to the source file can be updated in your table using this procedure.
  1. To update both data and table layout from the source file, select the table and right-click any cell, row, or column headings.


  2. Click Refresh Data and Layout from the contextual menu.
    The data and table layout are updated in the table.