Run-time error '1004' on server extraction
Hi all,
Im 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
Im 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
|