PivotTable with No Source Data
Hi Kris
Since you say you are running macros, could you not just ensure that
there is a single "row" of data by just writing a date to cell A2 of
the data sheet e.g. A2=TODAY()
Then, the count will still include just one "blank" row of data as well
as the headers, but the grouping will work because there will be a valid
date in row 1. It will not affect any future PT reports as all other
values in that row would be null.
--
Regards
Roger Govier
wrote in message
oups.com...
Oooops, spoke too soon. The solution worked in the sense that it
produced a blank PivotTable without generating an error but it caused
a
problem with a date column in the PivotTable that's being grouped.
The PivotTable contains a date column that's grouped by Year and
Month.
Refreshing with a blank data source destroyed this grouping. My guess
is that this is because you cannot grouping a column with blank rows.
Any ideas?
Thanks,
Kris
|