When trying to access F9 in Microsoft Excel the F9 tab does not show.
Make sure both the Excel Add-in and the COM Add-in are marked for use.
1. In Excel go to File, Options, Add-Ins 2. At the bottom of the Excel Options window set the Manage: dropdown to Excel Add-Ins and click Go... 3. Make sure the checkbox for F9v*.Connect Add-In is marked. 4. Click OK. 5. Repeat steps 1 and 2. 6. Set the Manage: dropdown to COM Add-Ins and click Go... 7. Make sure the checkbox for F9v* is marked and click OK.
Note: * indicates version number of F9 (i.e. F9v5 for version 5)