Drivel, and everything else..

Help!

That’s exactly what I felt like in this situation. I was working in Excel 2010 on a workbook with multiple sheets when I suddenly couldn’t interact with the Insert or Data menus (they were entirely greyed out), I also couldn’t interact with my PivotCharts at all.

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.

The Solution

I had inadvertently selected multiple worksheets, *clicking* on a single worksheet doesn’t deselect the multiple worksheet selection – here’s where the bad design causes confusion. You need to shift-click on a single worksheet to deselect the others, and resolve the problem.