How to show file path in formual bar when linking workbooks?
 

Hi,

I am creating a worksheet using data from other worksheets. I am trying to
get the formula bar to display the file path of the workbook I am linking to.
Instead it just shows the file name, sheet, and cell I am linked to. Let me
know if you now how to fix this.

Thanks
Mascot

How to show file path in formual bar when linking workbooks?
 

Mascot,

You will always see this when you have the linked file open. If you
close the file you are linking to, you should then see the full path in
the formula bar

HTH

Steve

How to show file path in formual bar when linking workbooks?
 

Hi Mascot,

Excel will shows the path of the source file if it is close, when it's open
excel will show just the file name.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Mascot" escreveu:

Hi,

I am creating a worksheet using data from other worksheets. I am trying to
get the formula bar to display the file path of the workbook I am linking to.
Instead it just shows the file name, sheet, and cell I am linked to. Let me
know if you now how to fix this.

Thanks
Mascot