Apr 10 2023 09:56 AM
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 returns a circular reference. I tried:
=cell("filename",A1) and either filename formula returns as a Circular Reference.
Any thoughts?
Apr 10 2023 11:02 AM
Apr 11 2023 10:24 AM
@mtarler I didn’t use error checking. I know what a circular reference is.
old formulas =cell)”file name”) work. All new ones entered return a circular reference error.
any other thoughts? I will look for the error checking thingy.
Apr 11 2023 11:09 AM
Apr 17 2023 09:07 AM
Apr 17 2023 09:27 AM
@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'.