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 |
All times are GMT +1. The time now is 10:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com