1. M

   Add in troubles

   Hello, I have a very nasty problem with Excel.Excel adds a path to the function, i.e.:='C:UsersMeDocumentswater97_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..

   • Thread
   • add-in wrong path
   • Replies: 1
   • Forum: Excel Questions
2. E

   Help me calculate the formulas for Data Analysis add-in

   Hi Guys,I have a big favour to ask. Within excel there is an add-in called “Data Analysis”, Which can do “Regression”I am able to get the Coefficients using the following formula as an array (if the ranges are set to be the independent and depend variable data)..

   • Thread
   • add-in data analysis
   • Replies: 1
   • Forum: Excel Questions

3. Userform in add-in must be clicked before it is 'active'

   I have created an add-in that functions perfectly except for one annoying thing.The add-in creates a new workbook by copying the add-in's first sheet. This new workbook is then populated with data from an archived workbook that the add-in has opened. This works well and I can watch the data..

   • Thread
   • add-in data transferred userform workbook
   • Replies: 4
   • Forum: Excel Questions

4. Sequence Function

   I am not sure this forum is the right place to ask about this.I use Excel 2013 and have been looking for a downloadable add-in of the sequence function.Is there such an add-in?If so where can it be found?

   • Thread
   • add-inadd-ins function functions sequence
   • Replies: 8
   • Forum: Excel Questions

5. Docking Station affecting add-ins?

   Hi allI have a client that uses a network-installed add-in. Several others use the same network-installed add-in without issue, but everyone works from a desktop that never gets disconnected from the network. Could undocking a laptop from the network break the link to the add-in? I have not..

   • Thread
   • add-inadd-ins laptop network network-installed
   • Replies: 1
   • Forum: Excel Questions

6. very hidden sheets add-in

   Hi everyone,I used to have an excel add-in that had a form that allowed me to select multiple sheets from within that spreadsheet and select whether to hide, unhide or make very hidden the selected sheets. I recently upgraded my machine and office and that old add-in no longer works. I've..

   • Thread
   • add-inadd-ins hidden sheets sheets very hidden
   • Replies: 13
   • Forum: Excel Questions
7. A

   VBA - Add In with Modules/Subroutines

   Hello,I am working with different tools based on workbooks at work.Now I don't want to write/update the code, which is over some workbooks the same, again and again in every tool.The solution should be to write this tool, which is exactly the same in every tool, in an add in, and connect..

   • Thread
   • add add-in modules tool tools
   • Replies: 0
   • Forum: Excel Questions

8. Excel Inquire COM Add-in

   Hi folks,I inadvertently removed the Inquire Excel COM Add-in this morning instead of disabling it.Developer Tab > COM Add-ins > Highlight Inquire and press Remove.I'm trying to get it back but nothing seems to work.It no longer appears in the list of COM Add-ins.My ultimate remedy will be..

   • Thread
   • add-inadd-ins excel inquire list
   • Replies: 0
   • Forum: Excel Questions
9. M

   revision cloud add-in 'cloud.xlam'

   I watched a youtube video by Amjad Pervaiz on making rev clouds in Excell. He had a add-in called 'cloud.xlam' that would convert a rectangle to a cloud. He could adjust the arc radius, color, and line thickness. Does anyone know where I can get a copy of this add-in?

   • Thread
   • add-in cloud cloud.xlam line revision
   • Replies: 1
   • Forum: Excel Questions
10. M

    revison cloud add-in

    I need a copy of the revision cloud add-in named 'cloud.xlam'.

    • Thread
    • add-in cloud copy revision revison
    • Replies: 2
    • Forum: Excel Questions
11. J

    Trying to make an add-in to copy and paste values for every sheet

    Hi everyone,I need to make an add-in that copies and pastes the values of very sheet in the workbook. I tried running this code and it worked:Sub Saveasvalue() Dim wsh As Worksheet For Each wsh In ThisWorkbook.Worksheets wsh.Cells.Copy wsh.Cells.PasteSpecial..

    • Thread
    • add-in code excel saved worksheet
    • Replies: 3
    • Forum: Excel Questions
12. W

    Cannot run macro from add-in.

    First post to this forum. Familiar enough with computer stuff, but first time user of Excel. I'm doing this to help a friend.Excel 2010 on Windows 7 (Ultimate) running in a VirtualBox VM on Debian Linux StretchMy friend downloaded a free Excel add-in (in an 'xlam' file) which is to file..

    • Thread
    • add-in clicking excel file run
    • Replies: 17
    • Forum: Excel Questions
13. L

    Power Query Get Data From SharePoint Folder Pre-2016?

    HelloI've hooked an excel file up to a SharePoint folder on my o365 machine no problem.I'm trying to hook up colleague up as well - she has excel 2013 however and has had to download the Power Query add-in.The add-in doesn't have 'From SharePoint Folder' available under 'From File'..

    • Thread
    • add-in folder power query
    • Replies: 4
    • Forum: Power BI
14. P

    Check if worksheet exists.. ?

    Trying to put a snip of code at the beginning of an Add-In I've created that will check to make sure the required worksheet exists before it tries to run the code (to avoid error). Below is not working. Any direction/guidance is appreciated. Dim sht As WorksheetDim wb As WorkbookIf wb Is..

    • Thread
    • add-in error exists sht worksheet
    • Replies: 1
    • Forum: Excel Questions

15. Is Selenium worth using?

    I spent a while trying to find out if there is an up-to-date version of the Selenium add-in, but haven't had much luck.It's an add-in that allows VBA to manipulate Chrome and Firefox as object models just like IE. This would be tremendously useful since IE is not able to navigate some..

    • Thread
    • add-in chrome found selenium vba
    • Replies: 1
    • Forum: Excel Questions
16. D

    automating query in VBA

    not sure if this can be done, but every day I download data via an Excel add-in ('transfer data from iseries') which I beleive is a way to download data from AS400.Every day, I need to click the Excel add-in, enter my user name and password (which is painful) then i tell the admin to start the..

    • Thread
    • add-in data download enter file
    • Replies: 2
    • Forum: Excel Questions
17. M

    Using Workbook Functions in Excel VBA Add-in

    I am creating an add-in that adds an option to the right-click menu that will let me run my macros. I've used the functions found here but when this is saved as an add-in this functionality doesn't work anymore. What would be needed to fix this..

    • Thread
    • add-in end excel-vba right click menu vba
    • Replies: 1
    • Forum: Excel Questions
18. P

    Custom Add-In causes Excel to crash on load

    I extracted some code from my project and created an Excel Add-In with it. The project now references the Add-In and everything seems to work fine, however if I completely close down Excel and try to open the project directly, Excel crashes.If I open some other Excel file or create a Blank..

    • Thread
    • add-in excel issue open project
    • Replies: 1
    • Forum: Excel Questions
19. W

    Worksheet Referencing Problem?

    Hi All,So I made a little program and now am in the process of making it into an Add-In. After it was loaded as an Add-In it did not work quite right. It was how the worksheets were referenced. I fixed all the bugs but this one. So what should be happening, and works fine when I'm not..

    • Thread
    • add-in code end work worksheet
    • Replies: 3
    • Forum: Excel Questions
20. K

    Reference Table w/i Add-In ???

    I have an add-in I have developed with some VBA code and 2 tables on different sheets. TableA is self contained (i.e. only relevant to the VBA code w/i the UDF in the Add-In). TableB is a Holiday table that I would like to distribute via the Add-In so other using the Add-In need not maintain..

    • Thread
    • add-in holiday reference table tableb
    • Replies: 0
    • Forum: Excel Questions

• Inquire Add In For Excel
• Excel Inquire Add In 365
• Microsoft Excel Add Ins Download

Inquire Add In For Excel

Download Spreadsheet Compare - A handy add-in for Microsoft Excel that was especially designed in order to help users perform comparisons between any two spreadsheets.

Note

• We have Office Home & Business 2013 here at work. I want to get hold of the Inquire add-in for Excel 2013. I understand from some web research that this add-in comes free with Office Professional Plus 2013. With Excel 2003 there were various add-ins that you could download as an upgrade pack. (I recall downloading an excellent statistics package.).
• Download Workbook. Enable the Inquire. More interesting things that the Inquire add-in now empowers you to do. Excel is only getting better with each version.

Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.

Symptoms

Excel Inquire Add In 365

When you look at Add-Ins section of the Options dialog box in a Microsoft 2016 or Microsoft Office 2013 program, none of your add-ins are enabled, as shown in the following figure for Outlook.

If you then open the COM Add-ins dialog box by clicking Go, you cannot enable any of the listed add-ins. When you select any add-in, the COM Add-ins dialog box displays the following text.

The add-in you have selected is disabled by your system administrator.

The warning is shown in the following figure for Outlook.

Cause

Microsoft Excel Add Ins Download

Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall the operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

This problem occurs because your administrator has configured a group policy setting to disable all COM add-ins. /xpand-vst-free-download.html.

The following registry data is used to disable all add-ins:

Key: HKEY_CURRENT_USERSoftwarePoliciesMicrosoftOfficex.0<application>Resiliency

DWORD: RestrictToList

Value: 1

Key: HKEY_CURRENT_USERSoftwareMicrosoftOfficex.0<application>ResiliencyAddinList

Note

• When this problem occurs, there is nothing listed under this key except for the Default REG_SZ value with no data.
• In the above registry data, <application> is the name of the Office program in which you are experiencing this problem.
• In the above registry key path, x.0 corresponds to version of Office (16.0 = Office 2016, 15.0 = Office 2013).

More Information

Through group policy, an administrator can manage the add-ins that are loaded in Office 2016 or Office 2013 programs. The following group policy settings are used to manage this functionality.

• List of managed add-ins

  This policy setting allows you to specify which add-ins are always enabled, always disabled (blocked), or configurable by the user. To block add-ins that are not managed by this policy setting, you must also configure the Block all unmanaged add-ins policy setting.

  To enable the List of managed add-ins policy setting, you must provide the programmatic identifier (ProgID) for each COM add-in that you want to manage. To obtain the ProgID for an add-in, use the Windows Registry Editor on the client computer where the add-in is installed. Locate the registry key names under HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice<application>Addins or HKEY_CURRENT_USERSOFTWAREMicrosoftOffice<application>Addins.

  To use this policy, you must also specify how each add-in should be managed. To specify how each add-in is managed, configure one of the following three options:

  /careueyes-activation-code-free.html. 0: The add-in is always disabled (blocked)

  1: The add-in is always enabled

  2: The add-in can be manually enabled or disabled by the user

  When you enable the List of managed add-ins policy, the following registry data is configured on the Office 2016 or Office 2013 client:

  Key: HKEY_CURRENT_USERSoftwarePoliciesMicrosoftOfficex.0<application>ResiliencyAddinList

  REG_SZ: <ProgID for the add-in>

  Values: <one of the following values>

  0 = The add-in is always disabled (blocked)

  1 = The add-ins is always enabled

  2= The add-in can be manually enabled or disabled by the user

  Note

  In the above registry key path, x.0 corresponds to version of Office (16.0 = Office 2016, 15.0 = Office 2013)

• Block all unmanaged add-ins

  This policy setting blocks all add-ins that are not managed by the 'List of managed add-ins' policy setting.

  If you enable the Block all unmanaged add-ins and List of managed add-ins policy settings, all add-ins are blocked except those that are configured in the List of managed add-ins as 1 (always enabled) or 2 (configurable by the user).

  When you enable the Block all unmanaged add-ins policy, the following registry data is configured on the Outlook client:

  Key: HKEY_CURRENT_USERSoftwarePoliciesMicrosoftOfficex.0<application>Resiliency

  DWORD: RestrictToList

  Value: 1

Note

• If RestrictToList is set to 1, but you do not enable any add-ins using the List of managed add-ins policy, all COM add-ins are disabled.
• In the above registry key path, x.0 corresponds to version of Office (16.0 = Office 2016, 15.0 = Office 2013).