B
Bugzee
Hi all,
I’m attempting to extract transaction details from an OLAP data source by
selecting a cell in a pivot table and issuing the following instruction:
ActiveCell.ServerActions("GL Details").Execute
I’m getting a “Run-time error ‘1004’†with explanation
“The cell that you are trying to change is protected and therefore
read-only…â€
The underlying visible sheet is the one created by the ‘.Severactions’
statement for displaying the retrieved data. Cell A1 contains a long string
which commences
“Retrieving data for ‘GL Details’ (…â€
On clicking the ‘debug’ button, the data then appears. The macro code
appears with the instruction immediately following the ’.Serveractions’
highlighted:
Range("M4").Formula = " = f4 & ""-"" & worksheetfunction.left(g4,3) &
""-"" & h4"
Is there anything wrong with this instruction (Excel 2007)?
Can anyone please point me in the right direction?
Thanks
Bugzee
I’m attempting to extract transaction details from an OLAP data source by
selecting a cell in a pivot table and issuing the following instruction:
ActiveCell.ServerActions("GL Details").Execute
I’m getting a “Run-time error ‘1004’†with explanation
“The cell that you are trying to change is protected and therefore
read-only…â€
The underlying visible sheet is the one created by the ‘.Severactions’
statement for displaying the retrieved data. Cell A1 contains a long string
which commences
“Retrieving data for ‘GL Details’ (…â€
On clicking the ‘debug’ button, the data then appears. The macro code
appears with the instruction immediately following the ’.Serveractions’
highlighted:
Range("M4").Formula = " = f4 & ""-"" & worksheetfunction.left(g4,3) &
""-"" & h4"
Is there anything wrong with this instruction (Excel 2007)?
Can anyone please point me in the right direction?
Thanks
Bugzee