Forum Discussion
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 wher...
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.