D
DS Robinson
Hello,
Does anyone have experience with altering pivottable cache?
I created a normal ADO recordset from a text file then set the
..Recordset property of the pivotcache object to the recordset. The
pivottable works fine. Now I need to alter some information in the pivot
table, preferably avoiding altering the text file and re-importing.
I've been trying to Set a new recordset to the .Recordset property of
the pivotcache, I can see it, but I can't alter it, as it's closed.
Thanks,
Dale Robinson
Does anyone have experience with altering pivottable cache?
I created a normal ADO recordset from a text file then set the
..Recordset property of the pivotcache object to the recordset. The
pivottable works fine. Now I need to alter some information in the pivot
table, preferably avoiding altering the text file and re-importing.
I've been trying to Set a new recordset to the .Recordset property of
the pivotcache, I can see it, but I can't alter it, as it's closed.
Thanks,
Dale Robinson