Help with install
Main Topics on this Page:
About Windows Smartscreen
Windows SmartScreen will probably block our files saying, it has protected your PC. The warning, does not provide you with any real information about the app and whether it is safe or not, it is simply a generic response, warning to you that Windows does not recognised the app.
mightymacros programs are digitally signed
Though mightymacros is a small business, we do make sure that our programs are digitally signed:
1. To ensure that the software comes from us, the publisher
2. To protect it from alteration
To view the certificate, Open File Properties and on the Digital Signatures Tab, Click ‘Details’ then ‘View Certificate’
Online Anti-Virus Testing And Installation:
If unsure about any file, then test it online with anti-virus and malware checkers before downloading:
https://opentip.kaspersky.com/
https://www.virustotal.com/gui/home/
https://metadefender.opswat.com/
If you have tested a file and found it to be safe, you should then be able to proceed with the installation as most anti-virus programs provide the option to allow or unblock a file.
Download URLs for online virus checks:
mightymacros Dat Addin:
- https://mightymacros.net/downloads/Dat_addin.zip
- https://mightymacros.net/dat/3072/1.7.0/dat_addin.exe
- https://mightymacros.net/dat/3072/1.7.0/DAT_AddinSetup.msi
mightymacros Dat Lite:
- https://mightymacros.net/downloads/mightymacros-DatLite.zip
- https://mightymacros.net/datbasic/3072/1.1.7/datbasic.exe
- https://mightymacros.net/datbasic/3072/1.1.7/DatBasicSetup.msi
mightymacros Excel Utilities:
- https://mightymacros.net/downloads/mightymacros_excel_utilities.zip
- https://mightymacros.net/downloads/utilities.chm
- https://mightymacros.net/downloads/mightymacrosAddInInstaller.zip
- https://mightymacros.net/xlaminstall/1033/1.0.4/xlamInstallSetup.msi
Installation:
mightymacros Dat Add-in and Dat add-in variants run only on Windows 8 and 10 computers with Microsoft Office installed on the machine.
To begin the install close Microsoft Excel before running the .exe file.
An installation of Microsoft SQL Server LocalDb is also required (Refer below for installation details)
1. Download and save the zip file

2. Right click the download file and select Extract All...

4. Double click the .exe file

5. Select More Info to clear Windows SmartScreen if it did not recognize the app

6. Select Run anyway to continue

7. Follow the installer guide to complete the install

8. The program installs onto Excel's ribbon

9. For more information or support
Select the About or Support button on the ribbon menu
SQL Server LocalDB Installation
- Download SQL Server Express 2019
- Download SQL Server Express 2017 (Recommended)
- Download SQL Server Express 2014
1. Download SQL Server Express and select Download Media

2. Select LocalDB option to download and run the install package

3. Open the download folder and double click the .msi package

4. Follow the installer guide to complete the install

Now check if there is an instance of LocalDB running on your PC.
SQL Server Express LocalDB comes with a command line tool called sqllocaldb.exe.
- Open the command prompt as an administrator. Press Windows+R keys to open the Run box. Type cmd and press Ctrl+Shift+Enter.
- For information of the tool at the command prompt type sqllocaldb.exe
- To check for instances of LocalDB running type sqllocaldb.exe i (i is for instances).
- If LocalDB is installed and Excel is not responding, then try resetting the instance.
- Stop the service: C:\WINDOWS\system32>sqllocaldb.exe p MSSQLLocalDB
- Delete the service: C:\WINDOWS\system32>sqllocaldb.exe d MSSQLLocalDB
- Start the service: C:\WINDOWS\system32>sqllocaldb.exe s MSSQLLocalDB
For more information contact mightymacros