For a large collection of Excel tutorials and sample files, please visit my web site:
* www.contextures.com/tiptech.html
I’m Debra Dalgleish, an independent computer consultant who specializes in Microsoft Office programming and development. Self-employed since 1985, I’ve learned a lot about pivot tables through my own experiences and experiments (some successful, some not so much). I’ve also seen the wide variety of systems and practices that my clients use, and have learned much from assisting them with data analysis.
I’ve written three books on Excel pivot tables, and you can read the outlines here:
* Beginning Pivot Tables in Excel 2007
* Excel 2007 Pivot Tables Recipes
* Excel Pivot Tables Recipe Book
You can also find me on Google+ — +Debra Dalgleish.
__________________

I haved learned so much from your Excel Tips over the years. I have a puzzle for you: is there any way in Excel 2007 or 2010 to set sheet tab color to be solid and not “glassine”. When I have a grouped sheet selection I find it hard to see which tabs are selected.
There’s no way to change the sheet tabs to a solid colour, so we’re stuck with that glassy effect for now.