Pivot table will not group date

[EXCEL DODO]

Hi

I am challenged/very frustrated with my pivot table which will not group dates (returns an error message).

In reading other posted questions, I see that my problem is caused by empty date cells. Is there a way around this?

My spreadsheet will be used daily to input Invoice details - part of which is the date of invoice. If I were to select 'refresh data', this would not be pulling through any new data as it wouldn't be in the range. I had made my range A1:K1500 to incorporate future entries, but then I have empty date cells as to date there are only 200 entries.

Hope this makes sense!! Would really appreciate any suggestions.

Many thanks
Lyn

 

[Brian from Maui]

You can take advantage of 2003's Data/List function, which creates a dynamic range automatically. This is especially useful for things like refreshing PT's.

 

[EXCEL DODO]

Thank you both. That certainly tricked it. I REALLY appreciate all the help. This has been very frustrating and I couldn't have done it without all your help.

Sincere thanks
Lyn