Create workbook links - Microsoft Support
Link workbooks from several departments and then integrate pertinent data into a summary workbook. When the source workbooks change, the summary workbook is updated. Create different views of data by creating several report workbooks that only link to pertinent data.
Manage workbook links - Microsoft Support
Workbook links must be maintained and updated to function properly. You will need to refresh them to get the latest values and locate them in your workbook if they break. Here's how to ensure that you are retrieving the latest values from your source workbooks.
Work with links in Excel - Microsoft Support
Insert a hyperlink in a worksheet cell or specific chart element to link to a related file or Web page in Excel. You can also modify or remove hyperlinks.
Open file links directly in Office desktop apps - Microsoft Support
This feature works for links to Word, Excel, or PowerPoint files, stored on OneDrive or SharePoint, that you click in Word, Excel, Outlook, or PowerPoint for Microsoft 365 on Windows or Mac. Once a user turns this feature on, it will apply to all three apps - Word, PowerPoint, and Excel. How do I turn this feature on or off?
Create a relationship between tables in Excel - Microsoft Support
Have you ever used VLOOKUP to bring a column from one table into another table? Now that Excel has a built-in Data Model, VLOOKUP is obsolete. You can create a relationship between two tables of data, based on matching data in each table.
Create, edit, and manage connections to external data
You can use Excel to create and edit connections to external data sources that are stored in a workbook or in a connection file. You can easily manage these connections, including creating, editing, and deleting them using the current Queries & Connections pane or the Workbook Connections dialog box (available in previous versions).
Insert an object in your Excel spreadsheet - Microsoft Support
You can use Object Linking and Embedding (OLE) to include content from other programs, such as Word or Excel. OLE is supported by many different programs, and OLE is used to make content that is created in one program available in another program.
Break a link to an external reference in Excel - Microsoft Support
When you break a link to the source workbook of an external reference, all formulas that use the value in the source workbook are converted to their current values. For example, if you break the link to the external reference =SUM ( [Budget.xls]Annual!C10:C25), the SUM formula is replaced by the calculated value—whatever that may be.
Collaborate on Excel workbooks at the same time with co-authoring
You and your colleagues can open and work on the same Excel workbook. This is called co-authoring. When you co-author, you can see each other's changes quickly—in a matter of seconds. And with certain versions of Excel, you'll see other people's selections in different colors.
Import data from data sources (Power Query) - Microsoft Support
Use Power Query in Excel to import data into Excel from a wide variety of popular data sources, including CSV, XML, JSON, PDF, SharePoint, SQL, and more.
Using structured references with Excel tables - Microsoft Support
To include structured references in your formula, click the table cells you want to reference instead of typing their cell reference in the formula. Let’s use the following example data to enter a formula that automatically uses structured references to calculate the amount of …