Remove a reference

[Niklas]

Hi
I have added an reference to an XLA file at
C:\Temp\MyFile.xla, but when I wanted to change the
location of the file to C:\MyProg\MyFile.xla....it fails.
Excel always points to the old one! How do I change the
location of a refernece?
Best regards
/Niklas

 

[Bob Phillips]

Niklas,

Go into Tools>References select the item and Browse to the new file.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Wei-Dong Xu [MSFT]]

Hi Niklas,

From my understanding to your issue, does this reference mean add one hyperlink in one cell or some thing else? If it is the hyperlink, you can right-
click the hyperlink and select "edit the hyperlink" to specify another file.

Please feel free to let me know if you have any questions.

Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Niklas]

Hi
I have selected a XLA file in Tools>References and later
on I have copyed the file to a new location.
I go into Tools>References and diselect the old file and
browse the new file. When I click OK and go back to
Tools>Reference, the reference still points to the old
file. I have to physicly delete the old file before I can
move the reference to a new location.
Best regards
/Niklas

-----Original Message-----
Hi Niklas,

From my understanding to your issue, does this reference

mean add one hyperlink in one cell or some thing else? If
it is the hyperlink, you can right-

 

[Wei-Dong Xu [MSFT]]

Hi Niklas,

Thank you for replying!

Does that issue still remain? If so, please feel free to let me know.

Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Niklas]

Hi
Yes, it still remains. It is not possible to registera XLA
file in Tools->References and then move the file to
another folder. Your XLS file will still point to the
first XLA file.
Best regards
/Niklas

 

[Wei-Dong Xu [MSFT]]

Hi Niklas,

Thank you for replying!

Based on my experience on this issue, I'd suggest you put the xla file with your xls file in the same directory. There is one kb article for you on this
issue which may give you one workaround for this issue. Please go to:
214333 XL2000: References Are Missing After Moving Files from Windows to
http://support.microsoft.com/?id=214333

Please feel free to let me know if you have any further questions.

Does this answer your question? Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Niklas]

I have a workaround that works, so I am not stuck. Instead
of doing a copy & past I do a cut & paste of the XLA file.
Best regards
/Niklas

-----Original Message-----
Hi Niklas,

Thank you for replying!

Based on my experience on this issue, I'd suggest you put

the xla file with your xls file in the same directory.
There is one kb article for you on this

 

[Wei-Dong Xu [MSFT]]

Hi Niklas,

Thank you for replying!

You are very welcome!

Thank you once more for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.