external references

[Guest]

I have a formula in cell a1 that links to an external file. Is there a formula to put in cell b1 that will print just the filename of that external reference? Ive tried using the =cell("filename",a1) but that didnt work. Thanks in advance.

 

[Steve Hartman]

Not sure if this will work but try:

=cell("filename",indirect(a1))

 

[Guest]

Thanks for your help. I tried that and got a ref error. Any other ideas?