| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking WorkBOOKS across directories | Excel Worksheet Functions | |||
| Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
| Can't find AutoRecover file in path specified in Options dialog. | Excel Discussion (Misc queries) | |||
| Reflect file path (show drive letters) in Excel 2000 | Excel Discussion (Misc queries) | |||
| How to change the Excel Title Bar to show the full file path na... | Excel Discussion (Misc queries) | |||
Hybrid Mode
