Share via

Add Linked Table to Data Model in Excel 365

Anonymous
2020-10-14T14:54:23+00:00

When I add a table to Data Model using Excel 2016, there will be a "link" icon before the table name and the "Linked Table" ribbon tab shows.

But in Excel 365, when adding table to Data Model, both "link" icon and "Linked Table" ribbon tab disappear.

How to get "Linked Table" back for Excel 365?

[ 由 “中文 (简体)” 移动至 “英语 ” 区域，操作人：KaiXiu Gao (VM) ]

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Anonymous
    2020-10-14T15:58:54+00:00

    Hi Eli,

    Unfortunately, the Linked Table tab is not existing any more in Excel 365 version.

    It has been replaced with the refreshable tables. 

    You may use the refresh button under the Home tab to keep your data model updated. 

    Refresh and Manage Power Pivot External Data Connections

    Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.​

    Your understanding is highly appreciated. 

    Regards,

    Alex Chen

    0 comments