Blanks in a pivot

T

tmusur

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top