MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pivot Tables


Posted by Zzyzzyth on February 15, 2002 12:22 PM

I was under the impression that you could update the underlying data within a pivot table? Is this correct?
I am generating "Daily Activity" reports from an external database (Access 2000), and I would like for the user to be able to make corrections in the pivot table and reflect in the database. Am I designing the pivot table wrong?

No one responded to my recordset question, so I guess that's not possible, so I want to try and give pivot tables a try.

My ultimate goal is to be able to let the user make corrections to update the database without giving them direct access to the database itself. Any suggestions would be greatly appreciated.


Posted by Mark W. on February 15, 2002 12:27 PM

No, PivotTables are for output not input.

Posted by Zzyzzyth on February 15, 2002 12:36 PM

How do I go about this then?

What is the best way for a user to update data without allowing them into the database? I can pull in a recordset, but I don't know how to send it back to the database with the changes/updates.

Posted by Mark W. on February 15, 2002 1:29 PM

Re: How do I go about this then?

You could use Microsoft Query. What's wrong
with using Access itself?