ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formulas (https://www.excelbanter.com/excel-worksheet-functions/184850-formulas.html)

Sue Parsons

Formulas
 
Hi,
Can you place a file path in a formula within a cell ie if i wanted a file
to go to this file path.

An alternative to linking a file?
--
sue

Pete_UK

Formulas
 
You can link like this:

='full_path[filename.xls]Sheetname'!A1

Is that what you mean?

Hope this helps.

Pete

On Apr 23, 2:46*pm, Sue Parsons
wrote:
Hi,
Can you place a file path in a formula within a cell ie if i wanted a file
to go to this file path.

An alternative to linking a file?
--
sue




All times are GMT +1. The time now is 04:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com