There's a function,
=cell("filename")
The description says, returns filename of the file containing the reference.
But it leaks data, it actually returns the filename that the user is currently editing! Make 2 spreadsheets, toggle between them with both on the screen, and hit F9.
=cell("filename")
The description says, returns filename of the file containing the reference.
But it leaks data, it actually returns the filename that the user is currently editing! Make 2 spreadsheets, toggle between them with both on the screen, and hit F9.