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

G

Guest

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
 
S

SIR Knight

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
 
G

Guest

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking workbooks together 1
Linking Workbooks 7
summarizing data from various workbooks 3
Wrong Date when pasting/linking workbooks 2
How to create absolue path link to another workbook (Excel 2003) 1
Linking sheet between two files 4
Linking multiple ranges and worksheets to MS Word 1
multiple workbooks in one file 3

Top