>>I've never used this but I just created a real neat pivot table using the PivotTable Wizard in VFP. Now, the user wants to edit the data and can't. How can I enable editing on this PivotTable?
>
>

---

John,
>Pivot tables are summary tables. You cannot edit its data directly (like a readonly SQL cursor). To be able to edit you should pastespecial the values onto a new sheet (assuming your pivottable is on sheet named "PivotSheet") :
>

#define xlValues  -4163
>with oExcel
>    .Sheets("PivotSheet").Cells.Copy && Copy pivot table to clipboard
>    .Sheets.Add  && Add a new sheet to paste
>    .ActiveSheet.Name = "PivotCopy" && Name the sheet
>    .Range("A1").PasteSpecial(xlValues) && Pastespecial values
>endwith

Now they could edit it (copy).
>Cetin

---

BTW I didn't only copy pivottable but all cells of sheet where pivottable is.
Cetin