Forum Discussion
=cell("filename")
In the past, I have been using the formula in a spreadsheet cell: =cell("filename") It returns the path and filename of the current sheet residing in. Using Excel O365 now this same formula ret...
I posted a file with the error message in it, but don't see it here!
dlassalle1gmailcom i see the file, it is attached.
When I open it (after excel does it's check) I get a #N/A error not a circular reference error:
as soon as I hit 'enter' inside the cell is resolves for me:
The #N/A error will happen for a number or reasons but 2 likely cases are:
a) the file is not saved
b) you are accessing this file in the browser
That all said, you say it didn't work for you but yet when it first opens it shows me a path I assume is from YOUR system so it did appear to 'work'.
