Niklas,

Go into ToolsReferences 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)

"Niklas" wrote in message
...
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