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...
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.
The error check thing is in the 'Formulas' menu bar inside the 'Formula Auditing' group look for the yellow triangle.
I'm just saying that the simple formula =cell("filename") doesn't appear to have a circular reference error for me (nor do I see how it would). BUT you could have a formula like
=IF(A1<>"", A1)
and if A1 is blank then no problem but once it is no longer blank you will get a circular reference, but that circular reference really has nothing to do with what is in A1. I'm not saying it is this simple, just suggesting you use the Excel tool to clarify the cell(s) that are actually causing the circular reference error.
You can also post the workbook here (or if you can't post here you can use online service like onedrive and share a link) and we can take a look and see if we see something.
I'm just saying that the simple formula =cell("filename") doesn't appear to have a circular reference error for me (nor do I see how it would). BUT you could have a formula like
=IF(A1<>"", A1)
and if A1 is blank then no problem but once it is no longer blank you will get a circular reference, but that circular reference really has nothing to do with what is in A1. I'm not saying it is this simple, just suggesting you use the Excel tool to clarify the cell(s) that are actually causing the circular reference error.
You can also post the workbook here (or if you can't post here you can use online service like onedrive and share a link) and we can take a look and see if we see something.