To create a new reference, click + Create. Unused: References that are not in any formulas in your sheet.In Use: References you’re using in cross-sheet formulas.Broken: Deleted source rows, columns, or cells.Processing: References loading updates from the source data.
Use a conventional naming structure for your references such as sheet name_columns referenced.Ĭlick the All References drop-down list to set the filter to Active, Processing, Broken, In Use, or Unused.įilters help you easily find, categorize, or review references. In the Search list… box, type keywords to find references you need to use. Use the following table for details on each of the features in the Cross Sheet References manager: See Cell Links: Consolidate or Maintain Consistency of Data for more information about cell links. You’ll be taken to the Cross Sheet References manager by default, but you can switch to the Cell Link References manager using the left panel. To open it, right-click any cell in your sheet and select Manage References… In the Sheet Reference Manager, you can see and modify all Cross Sheet References and Cell Link References in your sheet. View, Modify, and Delete References with the Sheet Reference Manager To work around this, consider using time-based or recurring automated workflows. To prevent infinite approval loops, cells that contain cross-sheet formulas or cell links will not trigger automation that changes the sheet (e.g., Move row, Copy row, Lock row, etc.). Here’s an example of how your formula should appear: That’s it! You should now see your reference added in your formula. If you don’t enter a name, the reference will be assigned a default name based on the sheet name and the number of times that sheet has been referenced.
When this happens, the data in cells with cross-sheet formulas will be affected. Any sheet reference you delete will also be removed from users who have access to the file you changed. If you have a permission to edit a sheet, be careful in deleting sheet references. Insert a formula in the destination sheetĭelete sheet references used in cross-sheet formulas View and reference data in the source sheet