Many workbooks contain connections to multiple data sources, such as cubes that are in SQL Server Analysis Services, tables that are stored in SQL Server, data that is available through an OData data feed, and so on.Ĥ. Connections are made to external data sources that are used in the workbook.ģ.
Someone initiates a refresh operation to get the most recent data.Ģ. What happens when you refresh external dataġ. External data is stored someplace else, such as on a server, and requires a connection to an external database.
Native data is stored directly in the workbook, and does not require an external data connection. When you use a workbook in the browser, you are viewing data that is either native or external. Excel for the web SharePoint Server Subscription Edition SharePoint Server 2019 SharePoint Server 2016 SharePoint Server 2013 Enterprise SharePoint Server 2013 Central Admin SharePoint in Microsoft 365 OneDrive (work or school) SharePoint Server 2010 OneDrive for Mac OneDrive for Windows SharePoint in Microsoft 365 Small Business More.
