Cross-Table Reference

Cross-Table Reference helps you reference cells or ranges from other spreadsheet files in formulas within the current workbook. It provides the tools you need to link data across files and create cross-file summaries, making your work more efficient and helping you accomplish tasks with ease. With Cross-Table Reference, you can insert references by typing = or by using the formula tools, choose a target file and reference range, change existing references, and refresh all references to sync the latest source data. Whether you're consolidating data from another cloud document, updating linked values, or adjusting a referenced file or range, Cross-Table Reference helps you stay productive and complete tasks efficiently across different devices and work environments. Choose the documentation below that best matches your needs to learn more.

1:53