Insert Pivot Table only inserts a blank sheet

[Dave H]

I am trying to create a pivot table. I have done thousands of them. I am using excel 2010 I have selected my data headers and all, click insert pivot table to a new worksheet. The only thing I get is a new worksheet that is totally blank. Any ideas as to what is going wrong, and how to fix the issue? Thanks

[Dave H]

I figured out the cause. Too many cell formats. Once I ran the macro to remove the corrupted formats, it inserts the pivot table.