creating Links

[Guest]

I am using Excel version 2002. In previous versions I have been able to just
type in the path to the workbook I am linking to. In this version everytime
I key a the path to the link example: =([budget.xls]nov05!c5) it opens the
file directory in which you are working and wants you to select the file [by
clicking it], and then click "open".

Is there anyway to make excel recognize the file name without having to
click the link everytime? It is very time consuming to click the link
everytime, as at the moment we have 12 sheets in the workbook with
approximately 120 links.

Any tips would be appreciated. Thanks!

 

[Dave Peterson]

I use xl2003 and it works the nice way you describe.

My first guess is that you are mistyping something--either the workbook name or
sheet name.

Or maybe...

In my simple tests, it sure looked like xl just used the default folder location
to get the correct path. Could it be that your file isn't in that location?

I am using Excel version 2002. In previous versions I have been able to just
type in the path to the workbook I am linking to. In this version everytime
I key a the path to the link example: =([budget.xls]nov05!c5) it opens the
file directory in which you are working and wants you to select the file [by
clicking it], and then click "open".

Is there anyway to make excel recognize the file name without having to
click the link everytime? It is very time consuming to click the link
everytime, as at the moment we have 12 sheets in the workbook with
approximately 120 links.

Any tips would be appreciated. Thanks!

 

[Guest]

Thank you Dave! I finally figured out what xl did not like, thanks to your
queston about whether something was mistyped! We had a dash in the workbook
name, which xl didn't like, and was removing when we typed in the formula.
We renamed the workbook, minus the dash, and now it brings the data without
opening up the directory.

I very much appreciate the help!

SD

I use xl2003 and it works the nice way you describe.

My first guess is that you are mistyping something--either the workbook name or
sheet name.

Or maybe...

In my simple tests, it sure looked like xl just used the default folder location
to get the correct path. Could it be that your file isn't in that location?

I am using Excel version 2002. In previous versions I have been able to just
type in the path to the workbook I am linking to. In this version everytime
I key a the path to the link example: =([budget.xls]nov05!c5) it opens the
file directory in which you are working and wants you to select the file [by
clicking it], and then click "open".

Is there anyway to make excel recognize the file name without having to
click the link everytime? It is very time consuming to click the link
everytime, as at the moment we have 12 sheets in the workbook with
approximately 120 links.

Any tips would be appreciated. Thanks!

 

[Dave Peterson]

Glad you found a solution.

Another thing you may want to try is to surround the workbook name and sheet
name with apostrophes:

='[book-2.xls]Sheet1'!A1

(worked ok for me)

Thank you Dave! I finally figured out what xl did not like, thanks to your
queston about whether something was mistyped! We had a dash in the workbook
name, which xl didn't like, and was removing when we typed in the formula.
We renamed the workbook, minus the dash, and now it brings the data without
opening up the directory.

I very much appreciate the help!

SD

I use xl2003 and it works the nice way you describe.

My first guess is that you are mistyping something--either the workbook name or
sheet name.

Or maybe...

In my simple tests, it sure looked like xl just used the default folder location
to get the correct path. Could it be that your file isn't in that location?

I am using Excel version 2002. In previous versions I have been able to just
type in the path to the workbook I am linking to. In this version everytime
I key a the path to the link example: =([budget.xls]nov05!c5) it opens the
file directory in which you are working and wants you to select the file [by
clicking it], and then click "open".

Is there anyway to make excel recognize the file name without having to
click the link everytime? It is very time consuming to click the link
everytime, as at the moment we have 12 sheets in the workbook with
approximately 120 links.

Any tips would be appreciated. Thanks!