external references

Mar 12th, 2002, 10:47 AM

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 · Mar 12th, 2002, 10:59 AM

Not sure if this will work but try:

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

Mar 12th, 2002, 11:09 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 10:47 AM	#1
Guest Posts: n/a	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.

Mar 12th, 2002, 10:59 AM	#2
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	Not sure if this will work but try: =cell("filename",indirect(a1))

Mar 12th, 2002, 11:09 AM	#3
Guest Posts: n/a	Thanks for your help. I tried that and got a ref error. Any other ideas?