Note that you should use something like

=CELL("filename",A1)

instead. If you don't put in the cell reference, CELL() returns the name
of the last worksheet calculated, which may not be the sheet the cell
resides in.

There's no need to close the workbook and reopen it, though it does need
to be saved.

In article ,
"Ashish Mathur" wrote:

In cell C4 in the sheet1, type the following formula

=cell("filename")

Now save and close the worksheet and reopen it.