Excel 2010: Insert / Data menus greyed out, can’t click on PivotCharts / PivotTables

Now group mode is very useful when you are editing several worksheets at once, all changes you make to one worksheet are made to all others in the group as well, but certain functions, such as all “Data” tools are disabled.

I was playing around with Excel spreadsheets and wanted to perform some filtering but for some weird reason all items in the quick access toolbar under “Data” was not available to me.

Resolution:

Here is the article which resolves my issue:

http://www.dracata.net/2011/07/excel-2010-insert-data-menus-greyed-out-cant-click-on-pivotcharts-pivottables