D
Dale
Can more than one pivot table be created and saved as a
Data Access Page for a particular query?
Basically, I'm wanting to take my data and develop one
pivot table that reflects FY04 information. Then I want
a different table reflecting FY05 info coming from the
same query.
I've already created and saved one FY04 pivot table.
When I access the query used to develop the table and go
to Pivot table view the same pivot table opens up and I'm
afraid if I overwrite it to make a FY05 table/link, I'll
lose the link I want to the FY04 html(i.e. data access
page) item.
Data Access Page for a particular query?
Basically, I'm wanting to take my data and develop one
pivot table that reflects FY04 information. Then I want
a different table reflecting FY05 info coming from the
same query.
I've already created and saved one FY04 pivot table.
When I access the query used to develop the table and go
to Pivot table view the same pivot table opens up and I'm
afraid if I overwrite it to make a FY05 table/link, I'll
lose the link I want to the FY04 html(i.e. data access
page) item.