Hi Kathie

Yes file received and message sent back.
Also sent a file which appears to have gone, Tried sending another file this
morning but it got bounced back. Will try again.

Your problem was caused by having Top 10 Months selected.
Once you got to September, (with Months from previous November present)
February didn't feature in the top 10. Deselecting any month, so there are
only 10 months, caused it to appear again.

Double click on Months filedAdvanced removing the Top 10 selection
and all will be well.

In the workbook I have sent, and the new one I am trying to send, I have
made a number of suggestions about using GetPivotData which will cut down
enormously on the amount of work you are having to do each month to prepare
your reports.
--
Regards
Roger Govier



"KO" wrote in message
...
Roger - did you get my email? Thanks for any help!

"Roger Govier" wrote:

Hi

If you want to mail me a copy of the file, I will be happy to see if I
can
resolve the problem.
to mail direct
roger at technology4u dot co dot uk
Do the obvious with the at and dots.

--
Regards
Roger Govier



"KO" wrote in message
...
I haven't changed the data range in all the time I've worked with this
file.
Crazy thing is, if I uncheck a certain month, the month I am missing
(which
happens to be Feb 07) shows up. If I check "all" Feb 07 disappears. I'm
just
stumped and have tried everything I can think of! Thanks in advance for
any
other suggestions.

"Debra Dalgleish" wrote:

Does the source data range include all the rows? Perhaps the missing
month is at the bottom of the source data range, and not included in
the
pivot table source.

KO wrote:
I have been working with a certain pivot table and data base monthly
for a
couple years. One of my fields is "month" and all of a sudden one of
the
months I have selected in my database is not showing up. It has
shown
up all
other months. Any suggestions?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html