Add in troubles

[MacIntoShiba]

Hello,

I have a very nasty problem with Excel.

Excel adds a path to the function, i.e.:
='C:\Users\Me\Documents\water97_v13.xla'!tSatW(10)
But than this gives a #NAME? error.

When I manually remove the path, i.e.:
=tSatW(10)

Than the function works fine. I could manually remove all the paths, however when I reopen the Excel file it automatically appends the path again.

I'm using Microsoft Office Proffesional Plus 2016.

I read that you can uninstall and reinstall the add in. However when I click: File >>> Options >>> Add-ins >>> GO then the Add-ins dialog box opens, but I cannot uninstall the add-in.

I can also click: File >>> Edit Links to Files, than I get the Edit Links dialog box. I tried all the buttons here. Change source, Update Values, Check status, nothing works. When I click the: Open Source button I get the error message:
Sorry, Excel can't open two workbooks with the same name at the same time.

Please help.

 

[pedro-egoli]

You may find the link below helpful. It is for deleting an an old add-in and inserting a new add-in .
The add-in is xl2bb and is used to post parts of files on Mr Excel and allows viewers to download that file to their own computer .
It was developed by dmorguz and is a handy add in and can be downloaded Here
The instructions for deleting and inserting, whilst not for your exact add-in but would be the same steps, are on this Link
Instructions read
Installation

• Uninstall the previous version of XL2BB if any.
  • Launch Excel, click the File tab, click Options, and then click the Add-Ins category.
  • Find XL2BB add-in in the Add-ins list and get the installation location in the Location column.
  • In the Manage box, click Excel Add-ins, and then click Go.
    The Add-Ins dialog box appears.
  • Deselect the XL2BB add-in in the Available Add-ins box, click OK and quit Excel.
  • Go to the add-in location and delete the xl2bb.xlam file.
  • Continue installing the new version by following the instructions below.
• Download the add-in.
• Launch Excel, click the File tab, click Options, and then click the Add-Ins category.
• In the Manage box, click Excel Add-ins, and then click Go. The Add-Ins dialog box appears.
• Click the Browse button to locate the add-in, and then click OK.

Note: If you have difficulties installing the add-in, please refer to Jon Peltier's amazing article - Install an Excel Add-in.

If you care to share part of your excel file via add-in xl2bb , if you run into trouble that can be posted on Mr excel for expert attention