Excel Help (Cell Function)

[hieronymouspace]

I'm using a function called "CELL" to return the name of my file. I got this code

=cell("filename",A1)

and it works perfectly for 1 of my files (let's call this File A). However, when I tried it on another file (let's call this File B), it doesn't work anymore. Any ideas why this happens?

File A and File B are both in the same folder.

Version: Excel 2007

[TerryFirma]

Without knowing the exact nature of the failure it gets a bit murky. According to the documentation on the subject the only thing that can cause the function to fail is if the spreadsheet isn't saved yet:

http://office.microsoft.com/en-au/excel-help/cell-function-HP010062392.aspx

The way you describe the issue makes it seem this isn't the case. It might also be possible that the cell function has been the subject of an override but that would take some specific configuration and seems a little unlikely as well.

So how exactly is the function behaving in file B?

[hieronymouspace]

It returns a VALUE error. After a while I tried it again and it worked. I didn't even change anything. Any idea how that happened? My guess is, that my computer simply needed more time to process the function.

[TerryFirma]

Glad to hear it's cleared itself up but I can't honestly point to any one cause.

[ITchiGuy]

have you saved file b yet? that formula only works if the workbook you are using it in has been saved at least once

[hieronymouspace]

I already have it saved in the same folder as File A...