Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

location of add-in basis moved

location of add-in basis moved

location of add-in basis moved

I am not experienced in excel. Please bear with me whilst I describe problem in my own idiosyncratic way.

I have a number of excel files which have had the add-in for properties of water and steam, www.cheresources.com/iapwsif97.shtml.

Unfortunately, the source file for this add-in, water97_v13, has had to be moved from one directory to another, and the old directory no longer exists.

Now, whenever I open an excel file which is supposed to be linked to the add-in, the connection is not there.

How can I, from the excel file, redirect the file to the new location of the add-in?

RE: location of add-in basis moved


If you know the new location, then select TOOLS, ADD-INS and press the Browse button you can then select the directory where the files are. Just follow the windows.

Hope this helps.

maybe only a drafter
but the best user at this company!

RE: location of add-in basis moved

simple process...

determine where the add-in is located.

go ahead and open the xl file and select 'no' for updating links.

from the menu bar,
select 'Edit' 'Links'.

you will note the options available for updating links.

select the 'Open Source' or 'Change Source' option and then browse to the location in which the add-in is located.

Select the add-in and then proceed with your work!

good luck!

RE: location of add-in basis moved


onlyadrafter written procedure is correct.

the procedure i wrote is for updating links between workbooks.


RE: location of add-in basis moved

Gentlemen, thank you. Problem solved.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close