formula doesn't work when copy /pasted.

[Todd]

I am using the formula pasted below to read the sheet
name. It works on the origonal sheets I made with it but
does not work when I move the worksheet or try to copy the
formula from the working page into the copy (into the same
same cell). I can't figure out why. Can someone help?


=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))
+1,255)


TIA


Todd

 

[Frank Kabel]

Hi
what does happen (what is the exact error)?
Does hitting F9 help?

 

[Vasant Nanavati]

Note that this will only work on a file that has been saved.

 

[Todd]

I get "Value". I copied several months of the worksheets
on friday. A few worked as a copy and most did not. So
far today I haven't been lucky and none work. I tried F9
and that hasn't worked either.

Thank you.

-----Original Message-----
Hi
what does happen (what is the exact error)?
Does hitting F9 help?

--
Regards
Frank Kabel
Frankfurt, Germany

I am using the formula pasted below to read the sheet
name. It works on the origonal sheets I made with it but
does not work when I move the worksheet or try to copy the
formula from the working page into the copy (into the same
same cell). I can't figure out why. Can someone help?


=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))
+1,255)


TIA


Todd

.

 

[Todd]

Its working! Apparently, I didn't have the work sheet
saved. Thought I did.

Thank you very much.


Todd

-----Original Message-----
Hi
what does happen (what is the exact error)?
Does hitting F9 help?

--
Regards
Frank Kabel
Frankfurt, Germany

I am using the formula pasted below to read the sheet
name. It works on the origonal sheets I made with it but
does not work when I move the worksheet or try to copy the
formula from the working page into the copy (into the same
same cell). I can't figure out why. Can someone help?


=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))
+1,255)


TIA


Todd

.