I have a pivot table that has a lists of months in a drop down at the top.
Which when I refreshed it the pivot then blew up on me. Meaning that if I
select the drop down now it has all of the months except April which is a
blank in place of it. So when I switch the data I could tell that it was
selecting the wrong data. I have a lot of pivots do this in the past and I
was just wondering if there is a way to save this pivot with out having to
recreate from scratch.

Thanks,
--
T