Editing cells in a pivot table

D

Dan Ricker

OWC10 has the capability of editing relational data. There
are some limitations but typically, if the relational data
source is a table, and the table has a primary key, then
the PivotTable "Details" can be used to edit the data.

For more complex relational structures, try creating an
MSAccess DataPage (Office2000 and greater). MSAccess can
be used as a front end for SQL Server. DataPages can be
built for (SQL or MDB) view and editing data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Create a chart from a table in word thats dynamic 0
Creating a Search using a combo box and then creating a report. 4
OWC11 pivot table export to excel fail: missing tag row (seems to 0
Changing pivot table ADO recordset 0
Pivot Table Management 4
VBA Pivot Table: Determining item from one field based on anotherfield item 0
owc11 pivot table and relational database 0

Top