Link to linked spreadsheet not updating

Or if not, at the very least, you’ll be aware of the possible issues.

Let’s explore this area and hopefully by the end you will see why it’s so risky.

I want the destination workbook to be automatically updated each time I open the destination workbook. Sincerely, Dan Simhony If the linked workbooks (precedent and dependent) are both open, and Calculation mode is set to either Semi-automatic or Automatic, the dependent workbook will be updated automatically whenever any change occurs in the precedent workbook - no manual intervention required.

Normally, if you have linked information in your workbook, the information is updated whenever you open the workbook.

Back in In Design we see this warning triangle which tells us that the table in the Excel file has been modified. Here is the table in In Design before (left) and after (right) the update.

Double-click on the triangle to automatically update the linked table. As you can see, the updated table lost its header settings.

This tip (7556) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Office 365.

You can find a version of this tip for the older menu interface of Excel here: Updating Links.