Cross-Table Reference
Cross-Table Reference helps you reference cell or range data from other spreadsheet files in formulas in the current workbook. It provides the tools you need to link data and summarize information across files, making your work more efficient and helping you accomplish tasks with ease. With Cross-Table Reference, you can trigger references by entering =, insert references by selecting a source file and target range, change an existing reference to a different file or range, and update all references to sync the latest source data. Whether you're working with cloud documents or local workbooks, Cross-Table Reference helps you stay productive by supporting cross-file aggregation while requiring valid paths, access permissions, and supported spreadsheet formats such as .xlsx and .csv. Choose the documentation below that best matches your needs to learn more.