cell("filename") oddly linked among many sheets

[martingaleh]

I have this function
=cell("filename") on a number of sheets. In a new workbook, each sheet will yield a different value as the sheet names are different. However, I have this one weird workbook where the value of all the cells with this formula will yield the value of the last visible cell when I pressed f9. Here are things I tried:

Calculation automatic
iterations
I deleted every single sheet but two called sheet1 and sheet2
I did not remove modules etc that do not auto load when the file is open, but I have no code attached to the open event

I'd share the file, but this message board doesn't allow attachments.

 

[JoeMo]

There's a second argument to that CELL formula which anchors the formula to the sheet its in.

Try: =CELL("filename", A1)

where A1 can be replaced by any cell address on the sheet. If this cell reference is missing, the function will return the path to the workbook/worksheet where the last entry was made.

[TABLE="width: 64"]
<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>[TR]

[/TR]
[TR]
[TD="class: xl67"][/TD]
[/TR]
</tbody>[/TABLE]

 

[martingaleh]

Thanks, yes I just got it. I'm sure this was a "feature" so excel doesn't have to do the same thing twice. Is there no check for correct answer on this board? To used to stack overflow

 

[JoeMo]

Thanks, yes I just got it. I'm sure this was a "feature" so excel doesn't have to do the same thing twice. Is there no check for correct answer on this board? To used to stack overflow

You are welcome. Threads are never closed on this site.