Try repairing your office installation (Quick repair is good enough).
If you don't have product key, skip this. Do this only if you have product key of Office 2010.
Same can be also be accessed through View > Immediate Window > Type "? application.StartupPath" without quotes and press enter > You will have your path below.ģ. Open Excel > ALT+F11 > If Immediate Window is not visible, type CTRL+G. Excel folder contains XLSTART folder in itself (In case, your XLSTART path is not in Appdata) Note - If the above path is not applicable for your installation, you need to find XLSTART path. Now open Excel and see if the problem disappears or not. Move those files to some other location (i.e create a backup of those files / folders and delete all files / folders from here). Please look into C:\Users\User_Name\AppData\Roaming\Microsoft\Excel (replace user name with your user name, you can directly reach here by copy and pasting following without quotes in Explorer address bar - "%appdata%\Microsoft\Excel") and see if is contains few files / folders. You can select BallotName and pivot it in PQ (you will have to indicate in the next step the Values column), but you will no longer be able to create the pivot in the structure you mentioned, data for pivot tables must be in tabular. To disable add-in > File > Options > Add-ins > Down below you have Manage: Com Add-in : Press Go > Untick the Add-ins to disable and tick to enable themĢ. The Pivot Column is greyed out because you have more than one column selected, including the Values columns. If yes, then start application normally and disable add-ins one by one and start application again every time you disable an add-in to determine the culprit add-in. Hold CTRL key and click on application icon and don't release the CTRL key till it asks you for Safe mode confirmation. To determine, if add-in is a problem start your application in safe mode and see if problem has gone away. Select Excel Add-ins from the Manage drop-down menu, and then click on. Please try these options one by one and check after each option.ġ. For example, you cant see Data Analysis in Excel, Data Analysis is greyed out.
#EXCEL ADD INS GREYED OUT MAC#
Centralized Deployment supports three desktop platforms Windows, Mac and Online Office apps. Check whether you copy of Office is activated or not.ī. Add-ins no longer appear for users if the admin turns off or deletes the add-in, or if the user is removed from Azure Active Directory or from a group that the add-in is assigned to. I am here to work with you on this problem.Ī. Greetings! I am Vijay, an Independent Advisor.