![how to see developer tab in excel how to see developer tab in excel](https://www.spreadsheetweb.com/wp-content/uploads/2019/06/How-to-display-Developer-tab-in-Excel-00.png)
If that doesn't resolve it, make sure that if 32bit Excel is being used that 32bit Perspectives (tm1p.xla) is also being used. In some cases the above may not resolve the issue. IBM is, so far, unable to reproduce this issue in-house, so we have been unable to log a defect. The majority of users will not be developing and will not need the Developer option in Excel anyway.
#How to see developer tab in excel how to#
Then when TM1 is needed, simply launch TM1 directly from the tm1p.xla file or from Start > All Programs > IBM Cognos TM1. These step-by-step instructions show you how to add the Developer tab to the Ribbon in Word and Excel 2016 and Office 365, and to use it to launch the Visual Basic Editor and access Visual Basic. Logically, it should be possible to utilize the Developer tab when launching Excel without TM1. So, it's only Access where it's missing (see image, note that the 'Dev' tab in the image is a workaround customized tab created by me). I have checked Excel and Outlook and the Developer is available and can be enabled. Note: If the TM1 ribbon is set to auto=load when launching Excel, setting it not to do that may also be a contributory factor in this issue. However, the Developer tab which needs to be enabled is not there.
![how to see developer tab in excel how to see developer tab in excel](https://d1rytvr7gmk1sx.cloudfront.net/wp-content/uploads/2017/11/exceldevelopertab.jpg)
It may also be necessary to disable the Developer tab by going to Customize the Ribbon (right-click on ribbon) and unchecking the Developer option.Ĭlick the Microsoft Office Button, and then click Excel Options.Ĭlick Popular, and then de-select the Show Developer tab in the Ribbon check box. Click the Excel Option button at the bottom, then you will enter the Excel Option window Click the Popular button at the left Under Top Option for Working with Excel, check the Show Developer tab in the Ribbon option. To do that in MS Excel 2010 go to File > Options > Trust Center > Trust Center Settings > Trusted Locations and add new location Click Popular, and then de-select the Show Developer tab in the Ribbon check box. For Excel 2007: Click the Microsoft Office Button, and then click Excel Options. Solution is to trust the tm1p.xla location (the TM1 x86 bin folder) in Excel. It may also be necessary to disable the Developer tab by going to Customize the Ribbon (right-click on ribbon) and unchecking the Developer option.