1. Open windows Explorer


2. Click on Organize


3. Click on Folder and search options > Click on View > Click on Show hidden files, folders and drives > Click on Apply > Click on OK

4. Once done you will have the visibility of all folders and you will be able to save the apps in the correct folder.

In case this option is disabled, please follow these instructions:

1. Open windows Explorer


2. Once you are here:


3. Please manually input this:\AppData and then press “Enter”.
4. This will redirect you to this folder: C:\Users\User.Name\AppData


5. And now you have visibility of Roaming folder in which you can save the Excel Add-Ins by following the instructions below.
6. If file already exist in location %UserProfile%\AppData\Roaming\Microsoft\Addins, please delete it before installing new one.

1. Close Excel. If Excel is running, the add-in cannot be installed.
2. To download Excel add hoc reporting Add-Ins click following link Click here to begin the download process.

3. Save file AdHocReporting.xla at following location %UserProfile%\AppData\Roaming\Microsoft\Addins.

4. Double click saved file to install Add Ins.

5. Excel will open and you might be prompted to Enable Macros, if so click Enable Macros button.




6. You should see Add Ins tab in Excel Menu bar.




7. Close Excel and open it again before you try to generate report.
Note: It is important to do step 7 or you might get an error like following.

Issues with the Add In not displaying in Excel



1. Go to File --> Options --> Add-ins. Next to Manage: Excel Add-ins at the bottom, click "Go..."



2. Make sure Adhocreporting is checked. Click Ok and restart Excel.