Prevent modification of pivot table totals

M

Matt

Dear all,

I have a Excel 2007 pivot table connected to a SQL Server Analysis Services
cube that allows writeback (modification of data in cube). I've accomplished
this by setting 'ActiveCell.PivotTable.EnableDataValueEditing = True'.

This all works fine, but I'd like to prevent users from entering values into
the pivot table totals and grand totals and instead for them to edit the
individual lines.

This would seem easy to do by checking the value of PivotCellType for when
it is xlPivotCellGrandTotal, but this does not work.

Can anyone suggest any other methods?

Thanks,

Matt
 

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

Pivot table 0
Does Anyone Have a Excel Writeback Cube Sample? 0
How edit cell in Pivot Table 1
Pivot Table Management 4
Referencing a pivot tables Grand Totals Column 1
Excel 2007 pivot table using analysis services cube as data source 0
grand totals in pivot table rows 5
Pivot Table - Grand Totals 0

Top