Forum Discussion

NicolasIlg's avatar
NicolasIlg
Copper Contributor
Aug 25, 2023

Referencing Spreadsheet Named in a Cell

Hi! 

 

I have Spreadsheet 1 where multiple cells are functions of cells in a different spreadsheet. For Example  =SUM('[Other Spreadsheet.xlsx]Tab'!$I$131:$K$131) 

I would like to have a cell where I name the Other Spreadsheet and if I change this name to Other Spreadsheet Number 2, then all the formulas on Spreadsheet 1 will start referring to a different spreadsheet called Other Spreasheet Number 2.

All those spreadsheets would be on sharepoint and accessible to other people in my company. 

 

Any ideas on how to do this?

Thanks a lot in advance!

Formulas and Functions

1 Reply

  • mathetes's avatar
    mathetes
    Gold Contributor
    Aug 26, 2023

    NicolasIlg 

     

    The INDIRECT function can do that when all files being referenced are open. Whether that works on Sharepoint I have no idea. But read up on INDIRECT here and try it out. Be forewarned that if you use it a LOT in your spreadsheet, INDIRECT can slow things down considerably.

Resources