Add in troubles

MacIntoShiba

New Member
Joined
Nov 20, 2020
Messages
1
Office Version
  1. 2016
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.
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
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
 
Upvote 0

Forum statistics

Threads
1,213,531
Messages
6,114,167
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top