Solution C: You may have enabled Track Changes, to undo this go to the Review tab and click on the Track Changes option and deactivate it/accept the changes.
The Solution, i had inadvertently selected multiple worksheets, *clicking* on a red faction 2 game single worksheet doesnt deselect the multiple worksheet selection heres where the bad design causes confusion.Click on the Review tab, then Share Workbook, then, under Editing uncheck Allow changes by).Update 2 (12/01/16 Yes, these solutions are still going strong!You need to shift-click on a single worksheet to deselect the others, and resolve the problem.I spent half an hour scouring the Internet and reading that it may be to do with my Sharing or Protected Workbook options, but my workbook was neither shared nor protected.My favourite comment so far has to be: 17 Margaret (September 28th, 2012 I found this just moments before committing Seppekku Thank God.
Keep the comments coming people, especially if none of the above work and you find an alternative solution.
I was working in Excel 2010 on a workbook with multiple sheets when I suddenly couldnt interact with the Insert or Data menus (they were entirely greyed out I also couldnt interact with my PivotCharts at all.
Some people have found that this hasnt worked for them, thanks to commentor Laci who has posted another solution which seems to cause the same behavior: Solution B: Excel Options, advanced, display options for this workbook, for objects, show.
Thats exactly what I felt like in this situation.
Update 2 (08/04/13 If neither of the two solutions above work for you, commenter maurita has another solution if youve found your data options are unavailable in Excel.
Update 1 (07/04/13 Ive had a lot of people commenting thanking for the above youre welcome!I still receive lots best keylogger detector 2015 of comments from you guys saying that one of the solutions either from here or in the comments fix your issues with Excel 2010, 2013, 2016, Solution D added: Solution D: It might be a shared Workbook, so youll need.Slicers option is greyed out in, excel, i have created.Insert Slicer In Pivot Tables Charts Excel 2010.This post will explain how you can use Slicer with Pivot Table and.If slicer is greyed out.I m using a dynamic pivot table - the slicer is greyed out.Using Excel 2010, created a Pivot Table with VBA and now the slicer controls are greyed out.Creating the same Pivot Table manually does allow use of the slicer controls.Excel 2010 2013: Insert / Data menus greyed out.