Excel 2007 : Adding blank future dates to a pivot table

Hi,

I am currently working on a spreadsheet that will show data from 2006-2008. I am working with data pulled from an excel query. Since the data only goes up to the present date I am unable to see future months that do not have data yet. Is there a way for me to display October-December 2008 in my pivot table? So far the only way I have come up with is to create a dummy record that shows no data for October-December. Is there a better way to do this?

Hi and welcome to the board,
do you really want to see these empty months or are you preparing your range for the future data ?
In the latter case you might what to use dynamic ranges

HTH

Thanks for the response. I am looking to see the empty months on my pivot table with no data next to them. It's mainly for cosmetic reasons. Since it is only September right now my company has no sales data for October-December. I simply want those future months to appear in my pivot table even though they have no data. In fact, the months are not even in the data retrieve that the pivot table is being created from. The only solution I have come up with is to create a blank sales record for these future months. When I refresh the query in Excel the blank sales records are erased and I have to enter them again. I was just wondering if there is a quicker solution to this. Any help would be appreciated and I hope that I am not confusing anyone.

I suppose your empty records are erased because your range was not adapted, otheriwse, they would stay.
Have a look at the site I suggested for creating dynamic ranges.
If still in doubt post a sample of your data
Cheers