In the last blog post, you saw how to turn off buttons and drop downs in an Excel 2007 pivot table. In the comments, Jon Peltier suggested a simple Copy and Paste Values instead, but that doesn't paste the pivot table style formatting.

Then, John Walkenbach pointed us to one of his articles, which describes how to paste the pivot table style formatting from the Office Clipboard. Thanks! So, if you want to send someone a pivot table that's not really a pivot table, you can use that technique.

Pivot It Old School (Old Skool?)

While we're on the topic of pivot table formatting, someone asked me how to make an Excel 2007 pivot table look like an old-fashioned Excel 2003 pivot table. He didn't explain why he wanted the old formatting, but maybe it's for consistency in a published document. It's easier to make a couple of new

Continue reading Pivot Table Formatting Old Style