I have a file open right now that has 46,916 styles. I do a lot of copy paste between files. What causes the explosion in styles? Is there an easy way to remove the unneeded styles?

Yes it was a shock. It took a while to understand the logic of what was on each tab. I was contantly looking for pivot tables under data.

That happens when there is text of blank cells in a data record. When I get count, I go back to the data table and it's usually the cause. Cells need to have at least a 0.

2 - I learned by recording key strokes for a process, then taking apart the recorded macro in VBA. It also helped to "step into" a macro and run it one step at a time. I also like the MrExcel.com website forums.