Then use your Recent file list to open it when needed. On the same Excel Options dialog box, click Add-ins on the. If you don’t want Perspectives to open each time you start Excel, just do a file, open and navigate to the same tm1p.xla file. If it is not, then right-click an empty area on any ribbon tab and choose Customize the. In File, select options followed by add-ins. In an Excel workbook, press Alt+F11 to open the Visual Basic Editor. You should now see the TM1 ribbon available at the far right end of the Excel menu. The steps to add an add-in to the Excel toolbar are listed as follows: a.On the available Add-Ins selection dialog box ensure that Perspectives is ticked and then click OK again.Navigate to something like “c:\program files\ibm\cognos\tm1_64\bin” (ie the bin folder inside the TM1 installation location).What you can customize: You can personalize your ribbon to arrange tabs and commands in the order you want them, hide or unhide. If not, click on “Go” beside the Manage Excel Add-ins drop down. Excel: Customize ribbon, Add ins, quick access toolbar - YouTube.I need to add some additional options and macros to this drop down, and I cannot figure out how. There is a tab on the ribbon called 'Add-ins' and on that tab there is a section called 'menu commands' where there is a custom drop down menu that calls various macros. Other add-ins, such as the Get Startedtab, are available in other places in Excel, such as a tab on the ribbon, or through macros or customized menus. If you dont see the Add-Instab, you should exit and then restart Excel.
Go to File (or Home button in Excel 2007), Options (Excel Options in 2007).The Steps to Enable the TM1 Perspectives Excel Add-in What this does is then automatically add the Perspectives add-in to Excel on your PC so that TM1 automatically opens each time you start Excel and the TM1 Perspectives Ribbon is automatically added to your Excel ribbon.
So I thought I would do a quick blog about how to enable it. Please note that if you are using the new Planning Analytics for Excel (PAX) add-in, please see this post. I recently started working with a new PC and it did not have the TM1 Excel Perspectives add-in enabled and obviously I therefore did not have the TM1 Perspectives Ribbon included in Excel.