AllowEdits Property - Pivot Table

[PhiberOptic]

Hi,

I tried to make the detail fields of my pivot table edit able, as described
in the msdn article:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/owcvba10/html/ocproAllowEdits.asp

Problem is, after setting the option "PivotTable1.ActiveView.AllowEdits =
True" nothing happens, the text in the detail fields still can't be changed.

Can anyone give suggestions ?

Best Regards,

PhiberOptic

 

[PhiberOptic]

Hi all,

I think I got part of the prblem by myself. If I get it right it's not
possible to write back if the source of the office web components is a select
statement joining multiple tables ?!

Problem is, that I'm using a higly normalized database and need data from
more than one table to fill the web component. Is there any other way to
enable write back, e.g. using views on my sql 2000 server, or do i have to
put all information in one big table ??