J
Jason Horner
I'm using Excel 2002 I have an existing spreadsheet that
pulls information from a SQL server 2000 DB to populate a
pivot table. It does not use a microsoft query file
I need to be able to change the name of the table that
populates the pivot table in excel I want to maintain the
existing formating and the fields from the new table are
the same just the name of the table changed I have tried
using some VBA but i can't seem to locate the right
property in the pivottable object
pulls information from a SQL server 2000 DB to populate a
pivot table. It does not use a microsoft query file
I need to be able to change the name of the table that
populates the pivot table in excel I want to maintain the
existing formating and the fields from the new table are
the same just the name of the table changed I have tried
using some VBA but i can't seem to locate the right
property in the pivottable object