This is throwing a wrench in my entire reporting process. In 2003, I have a number of sheets in a workbook all pivot tables referring to another table. This will typically be 30mb or so. To distribute, I'll copy/paste special values only, then the resulting file will be <1mb and they don't have to be linked to the source table.

In 2007, copy/paste special will remove the formatting from the pivot table. I figure this is an easy fix, I just need to find out how this is done in 2007. After some googling, I'm worried this actually might not be possible. I don't know what to do, short of printing and sending as pdf which my users won't like. Manually reformatting the tables to make them look pretty is infeasible.

What do I do? Please help!