{"_id":"575a270ce12cf20e002f2ec9","category":{"_id":"574a3bc0d1d1381900b73faf","version":"574a3bc0d1d1381900b73fae","project":"574a3bc0d1d1381900b73fab","__v":0,"sync":{"url":"","isSync":false},"reference":false,"createdAt":"2016-05-29T00:45:52.959Z","from_sync":false,"order":1,"slug":"documentation","title":"Introduction"},"user":"574bfb9290d8b32000864973","version":{"_id":"574a3bc0d1d1381900b73fae","project":"574a3bc0d1d1381900b73fab","__v":7,"createdAt":"2016-05-29T00:45:52.939Z","releaseDate":"2016-05-29T00:45:52.939Z","categories":["574a3bc0d1d1381900b73faf","574be6d52aa7221700c51bed","574c0b6d281b010e00008f89","574c1afbcf99610e00ef7d2b","574d13b9a1f0be2000ae3803","574d14140db0870e0075382d","591eb3a72c1b1f0f000fa9f2"],"is_deprecated":false,"is_hidden":false,"is_beta":false,"is_stable":true,"codename":"","version_clean":"3517.0.0","version":"3517"},"githubsync":"","__v":66,"parentDoc":null,"project":"574a3bc0d1d1381900b73fab","metadata":{"title":"","description":"","image":[]},"updates":[],"next":{"pages":[],"description":""},"createdAt":"2016-06-10T02:33:48.069Z","link_external":false,"link_url":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[]},"settings":"","auth":"required","params":[],"url":""},"isReference":false,"order":4,"body":"The software uses Microsoft Excel as its primary data source and reporting platform.  Microsoft Excel can be installed as either a 32-bit or 64-bit application.  The software determines between these versions when it is originally installed.  If Microsoft Excel 32-bit is subsequently uninstalled and replaced with Microsoft Excel 64-bit (or Microsoft Excel 64-bit replaced with the 32-bit version) an incompatibility with the Microsoft Access Database Engine will occur.\n\nTo fix this incompatibility the versions of both the Microsoft Access Database Engine and the Tigermoth User Interface need to be changed.\n\nAfter Microsoft Excel has been reinstalled, each of the Steps below needs to be followed sequentially.\n<br />\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Step 1 - Close All Open Applications and Windows\"\n}\n[/block]\nBefore proceeding further it is important that all open applications and windows such as Excel and Outlook etc are closed apart from the internet browser showing these instructions.  There should be no other applications running on the desktop before continuing.  All Tigermoth windows and instances should also be closed.\n<br />\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Step 2 - Download the Microsoft Access Database Engine\"\n}\n[/block]\nDownload the Microsoft Access Data Engine from the following link and save it to a temporary location on your hard drive.  The example in these instructions shows the location that the file is saved to as being `C:\\Temp`.\n\nMake sure that you choose the correct version of the installer for the version of Excel that you are running, i.e. if you have changed to Microsoft Excel 32-bit choose the file called `AccessDatabaseEngine.exe`, if you have changed to Microsoft Excel 64-bit then choose the file called `AccessDatabaseEngine_x64.exe`.\n\nThe latest and correct version of the Access Database Engine is 2010 Service Pack 2.  Currently there is no 2013 or 2016 version of the Access Database Engine released or planned.  The 2010 version works correctly with all Office 2013 and 2016 installations.\n[block:embed]\n{\n  \"html\": false,\n  \"url\": \"http://www.microsoft.com/en-us/download/details.aspx?id=13255\",\n  \"title\": \"Microsoft Access Database Engine 2010 Redistributable\",\n  \"favicon\": \"http://www.microsoft.com/favicon.ico?v2\",\n  \"image\": \"http://c.s-microsoft.com/en-us/CMSImages/office_symbol_clr_56x56.png?version=7eba901e-49a1-9255-cc0a-27de320be050\"\n}\n[/block]\n<br />\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Step 3 - Open an Admminstrator Command Prompt\"\n}\n[/block]\nThe Microsoft Access Database Engine needs to be manually installed via the Command Line if Microsoft Excel has been changed from 32-bit to 64-bit (or from 64-bit to 32-bit). \n\nOpen a Command Prompt window with local administrator rights.  To do this navigate to \"Start/All Programs/Accessories\" and right-click the entry called \"Command Prompt\" and select \"Run as Administrator\".  In Windows 8 and Windows 10 right click the bottom left corner of the Desktop and select \"Command Prompt (Admin)\".\n\nThe system may ask for the user name and password of a local administrator to continue.  Supply this information and a Command Prompt window will open.\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/fRMSkRw8QOmvtTpJCZqO_support-problem-admin-cmd.jpg\",\n        \"support-problem-admin-cmd.jpg\",\n        \"915\",\n        \"552\",\n        \"#35617a\",\n        \"\"\n      ],\n      \"sizing\": \"full\"\n    }\n  ]\n}\n[/block]\n<br />\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Step 4 - Install the Microsoft Access Database Engine\"\n}\n[/block]\nType each of the three commands shown below and press `Enter` after each.\n\nIf the name of the directory is different from the example value of `C:\\Temp` then replace this example directory value with the location of the `AccessDatabaseEngine_x64.exe` file if changing to Microsoft Excel 64-bit (or the `AccessDatabaseEngine.exe` file if changing to Microsoft Excel 32-bit).\n\nNote that if these commands are successful there will not be a notification of such to the end-user.  During the installation process a window should open and then automatically close.  A notification will be given only if an error is encountered.\n\nThe commands that need to be issued are shown below:\n```\nCD\\\nCD Temp\nAccessDatabaseEngine_x64 /passive\n```\n\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/2nnXLEFgRvSP2PXNh8Zn_support-problem-ade-install.jpg\",\n        \"support-problem-ade-install.jpg\",\n        \"677\",\n        \"343\",\n        \"#6ba7ed\",\n        \"\"\n      ],\n      \"caption\": \"Installation example for Microsoft Access Database Engine 64-bit\",\n      \"sizing\": \"smart\"\n    }\n  ]\n}\n[/block]\n<br />\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Step 5 - Uninstall the existing Tigermoth User Interface\"\n}\n[/block]\nUnder Windows 7 & Windows 10 click on 'Start/All Programs/Tigermoth/Uninstall' and this will open the 'Uninstall' application.  Under Windows 8 then locate the Tigermoth menu within the Windows Start Page Menu entries.  Examples of these alternatives are shown below.\n\nRun the 'Uninstall' application and follow the prompts to proceed and remove the Tigermoth User Interface.\n\n**Do not remove the Tigermoth Run-Time Environment via Control Panel**.  The RTE component does not need to be altered, changed or uninstalled.\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/UPcL96qzQdSbrgadUJ3q_software-uninstall.jpg\",\n        \"software-uninstall.jpg\",\n        \"736\",\n        \"448\",\n        \"#7796a9\",\n        \"\"\n      ],\n      \"sizing\": \"80\"\n    }\n  ]\n}\n[/block]\n<br />\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Step 6 - Request the Tigermoth User Interface\"\n}\n[/block]\nThe Tigermoth User Interface needs to be installed for each user of the local machine.  This installation file does not need full administrator rights on the local machine.  The user interface should be installed when each user is logged into the machine using their standard day-to-day username.\n\nIt is important to request the correct version of the Tigermoth User Interface according to the version of Microsoft Excel that is installed.  Create a screenshot of the current version of Microsoft Excel and paste it into the email request for the interface.\n\nIf needed, a link to the instructions for determining the installed version of Microsoft Excel is below.\n\n[**Is Microsoft Excel a 32-bit or 64-bit Installation?**](doc:system-requirements#check-2-is-microsoft-excel-a-32-bit-or-64-bit-inst)\n\nTo proceed, click on the link below to generate an email request for the Tigermoth User Interface and paste the screenshot of the Microsoft Excel version into this email.  Send this email and await the return of the download location of the latest Tigermoth User Interface.\n\n[**Request the Installation Files for the Tigermoth Interface**](mailto:support:::at:::tigermoth.com?subject=Tigermoth Interface Request - Excel Version Attached&body=[...Please paste a screenshot of your Microsoft Excel version in this email - the screenshot needs to show if Excel is 32-bit or 64-bit...see the System Requirements webpage for details on how to find this information...])\n<br />\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Step 7 - Install the Tigermoth User Interface\"\n}\n[/block]\nA link to the correct version of the Tigermoth User Interface will be returned via email.  Download the installation file to the local machine's hard drive (for example to `C:\\Temp`) and then double click this file to begin the software installation.  Installation from a network drive is not recommended.\n\nThe default installation directory is `%LOCALAPPDATA%` which maps to the end user's local profile.  This is the recommended location for installation because the interface does not require local administrator rights to install and does not need to access the local machine's registry.  Installation is a simple file copy process.\n\nIn some enterprise environments users cannot use the default location to run executable applications, or the end user's profiles are located on a network drive.  In these situations the software can be located in any directory on the local machine's hard drive (for example `C:\\Tigermoth`) and users are free to choose the software location as needed when the option is presented during installation as shown below.\n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/3gCQeCt2QLOMjOOCp1Do_installation-interface-location.jpg\",\n        \"installation-interface-location.jpg\",\n        \"1008\",\n        \"390\",\n        \"#bf3d45\",\n        \"\"\n      ],\n      \"sizing\": \"full\"\n    }\n  ]\n}\n[/block]\nClick `Install' to unpack and install the software.  An icon will be added to the users desktop and the Windows Start menu.  Installation is now complete and the software is ready to use.  Further licensing of the software is not necessary when the Tigermoth User Interface is simply uninstalled and reinstalled.","excerpt":"What to do if Microsoft Excel was upgraded or changed from 32-bit to 64-bit (or 64-bit to 32-bit)","slug":"changing-excel","type":"basic","title":"Upgrading Excel"}

Upgrading Excel

What to do if Microsoft Excel was upgraded or changed from 32-bit to 64-bit (or 64-bit to 32-bit)

The software uses Microsoft Excel as its primary data source and reporting platform. Microsoft Excel can be installed as either a 32-bit or 64-bit application. The software determines between these versions when it is originally installed. If Microsoft Excel 32-bit is subsequently uninstalled and replaced with Microsoft Excel 64-bit (or Microsoft Excel 64-bit replaced with the 32-bit version) an incompatibility with the Microsoft Access Database Engine will occur. To fix this incompatibility the versions of both the Microsoft Access Database Engine and the Tigermoth User Interface need to be changed. After Microsoft Excel has been reinstalled, each of the Steps below needs to be followed sequentially. <br /> [block:api-header] { "type": "basic", "title": "Step 1 - Close All Open Applications and Windows" } [/block] Before proceeding further it is important that all open applications and windows such as Excel and Outlook etc are closed apart from the internet browser showing these instructions. There should be no other applications running on the desktop before continuing. All Tigermoth windows and instances should also be closed. <br /> [block:api-header] { "type": "basic", "title": "Step 2 - Download the Microsoft Access Database Engine" } [/block] Download the Microsoft Access Data Engine from the following link and save it to a temporary location on your hard drive. The example in these instructions shows the location that the file is saved to as being `C:\Temp`. Make sure that you choose the correct version of the installer for the version of Excel that you are running, i.e. if you have changed to Microsoft Excel 32-bit choose the file called `AccessDatabaseEngine.exe`, if you have changed to Microsoft Excel 64-bit then choose the file called `AccessDatabaseEngine_x64.exe`. The latest and correct version of the Access Database Engine is 2010 Service Pack 2. Currently there is no 2013 or 2016 version of the Access Database Engine released or planned. The 2010 version works correctly with all Office 2013 and 2016 installations. [block:embed] { "html": false, "url": "http://www.microsoft.com/en-us/download/details.aspx?id=13255", "title": "Microsoft Access Database Engine 2010 Redistributable", "favicon": "http://www.microsoft.com/favicon.ico?v2", "image": "http://c.s-microsoft.com/en-us/CMSImages/office_symbol_clr_56x56.png?version=7eba901e-49a1-9255-cc0a-27de320be050" } [/block] <br /> [block:api-header] { "type": "basic", "title": "Step 3 - Open an Admminstrator Command Prompt" } [/block] The Microsoft Access Database Engine needs to be manually installed via the Command Line if Microsoft Excel has been changed from 32-bit to 64-bit (or from 64-bit to 32-bit). Open a Command Prompt window with local administrator rights. To do this navigate to "Start/All Programs/Accessories" and right-click the entry called "Command Prompt" and select "Run as Administrator". In Windows 8 and Windows 10 right click the bottom left corner of the Desktop and select "Command Prompt (Admin)". The system may ask for the user name and password of a local administrator to continue. Supply this information and a Command Prompt window will open. [block:image] { "images": [ { "image": [ "https://files.readme.io/fRMSkRw8QOmvtTpJCZqO_support-problem-admin-cmd.jpg", "support-problem-admin-cmd.jpg", "915", "552", "#35617a", "" ], "sizing": "full" } ] } [/block] <br /> [block:api-header] { "type": "basic", "title": "Step 4 - Install the Microsoft Access Database Engine" } [/block] Type each of the three commands shown below and press `Enter` after each. If the name of the directory is different from the example value of `C:\Temp` then replace this example directory value with the location of the `AccessDatabaseEngine_x64.exe` file if changing to Microsoft Excel 64-bit (or the `AccessDatabaseEngine.exe` file if changing to Microsoft Excel 32-bit). Note that if these commands are successful there will not be a notification of such to the end-user. During the installation process a window should open and then automatically close. A notification will be given only if an error is encountered. The commands that need to be issued are shown below: ``` CD\ CD Temp AccessDatabaseEngine_x64 /passive ``` [block:image] { "images": [ { "image": [ "https://files.readme.io/2nnXLEFgRvSP2PXNh8Zn_support-problem-ade-install.jpg", "support-problem-ade-install.jpg", "677", "343", "#6ba7ed", "" ], "caption": "Installation example for Microsoft Access Database Engine 64-bit", "sizing": "smart" } ] } [/block] <br /> [block:api-header] { "type": "basic", "title": "Step 5 - Uninstall the existing Tigermoth User Interface" } [/block] Under Windows 7 & Windows 10 click on 'Start/All Programs/Tigermoth/Uninstall' and this will open the 'Uninstall' application. Under Windows 8 then locate the Tigermoth menu within the Windows Start Page Menu entries. Examples of these alternatives are shown below. Run the 'Uninstall' application and follow the prompts to proceed and remove the Tigermoth User Interface. **Do not remove the Tigermoth Run-Time Environment via Control Panel**. The RTE component does not need to be altered, changed or uninstalled. [block:image] { "images": [ { "image": [ "https://files.readme.io/UPcL96qzQdSbrgadUJ3q_software-uninstall.jpg", "software-uninstall.jpg", "736", "448", "#7796a9", "" ], "sizing": "80" } ] } [/block] <br /> [block:api-header] { "type": "basic", "title": "Step 6 - Request the Tigermoth User Interface" } [/block] The Tigermoth User Interface needs to be installed for each user of the local machine. This installation file does not need full administrator rights on the local machine. The user interface should be installed when each user is logged into the machine using their standard day-to-day username. It is important to request the correct version of the Tigermoth User Interface according to the version of Microsoft Excel that is installed. Create a screenshot of the current version of Microsoft Excel and paste it into the email request for the interface. If needed, a link to the instructions for determining the installed version of Microsoft Excel is below. [**Is Microsoft Excel a 32-bit or 64-bit Installation?**](doc:system-requirements#check-2-is-microsoft-excel-a-32-bit-or-64-bit-inst) To proceed, click on the link below to generate an email request for the Tigermoth User Interface and paste the screenshot of the Microsoft Excel version into this email. Send this email and await the return of the download location of the latest Tigermoth User Interface. [**Request the Installation Files for the Tigermoth Interface**](mailto:support@tigermoth.com?subject=Tigermoth Interface Request - Excel Version Attached&body=[...Please paste a screenshot of your Microsoft Excel version in this email - the screenshot needs to show if Excel is 32-bit or 64-bit...see the System Requirements webpage for details on how to find this information...]) <br /> [block:api-header] { "type": "basic", "title": "Step 7 - Install the Tigermoth User Interface" } [/block] A link to the correct version of the Tigermoth User Interface will be returned via email. Download the installation file to the local machine's hard drive (for example to `C:\Temp`) and then double click this file to begin the software installation. Installation from a network drive is not recommended. The default installation directory is `%LOCALAPPDATA%` which maps to the end user's local profile. This is the recommended location for installation because the interface does not require local administrator rights to install and does not need to access the local machine's registry. Installation is a simple file copy process. In some enterprise environments users cannot use the default location to run executable applications, or the end user's profiles are located on a network drive. In these situations the software can be located in any directory on the local machine's hard drive (for example `C:\Tigermoth`) and users are free to choose the software location as needed when the option is presented during installation as shown below. [block:image] { "images": [ { "image": [ "https://files.readme.io/3gCQeCt2QLOMjOOCp1Do_installation-interface-location.jpg", "installation-interface-location.jpg", "1008", "390", "#bf3d45", "" ], "sizing": "full" } ] } [/block] Click `Install' to unpack and install the software. An icon will be added to the users desktop and the Windows Start menu. Installation is now complete and the software is ready to use. Further licensing of the software is not necessary when the Tigermoth User Interface is simply uninstalled and reinstalled.