Re: Array Formula

According to the download page for SP3, it has SP2 fixes included (as well as SP1 also). I don't know if this has anything to do with your problem or not, but putting "Features that are unavailable in shared workbooks" in the Help Search field in the work*** window and clicking that same article title says that for shared workbooks, you cannot "change or delete array formulas" but that "existing array formulas continue to calculate correctly". I also did a quick Google search and found a reference to that same error (but from a "hiding" issue) and the solution involved removing a Comment that was attached to one of the cells. Just figured I would mention these "in case".

Rick


"sharon t" <sharont@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:E17FE888-5FD5-4EBF-BC23-1165E9B54438@xxxxxxxxxxxxxxxx
No VBA code running which is trying to set a FormulaArray property of a
range. The fix is out under Help and support, article ID 885245. States SP2
fixes this error. I have SP3 loaded since updated computer a couple weeks ago
and now receiving this error. I would think SP3 would contain all fixes
included in SP2 but doesn't appear to be the case. Never had the problem
prior to upgrade. I use the conditional sum array formula all the time-never
had a problem prior to this.

"Rick Rothstein (MVP - VB)" wrote:

Hopefully someone more knowledgeable about this stuff will come along to
help you; however, that formula appears to work correctly on my system. I'm
not sure if this will help you to focus in on the problem or not; but I do
note that the original error message you reported, namely...

"Run-time error "1004": unable to set the
FormulaArray property of the Range class"

looks like a VBA error message (from, say, a macro or UserForm code module)
and not a work*** error message. Do you have any VBA code running that is
trying to set a FormulaArray property of a range (perhaps one that is
overlapping the cell(s) you are putting your formula into)?

Rick


"sharon t" <sharont@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A3DF7124-64A5-487C-AAB9-DBDE71ECCBE5@xxxxxxxxxxxxxxxx
> =SUM(IF('Grand Total-All Detail'!$B$3:$B$14="Jane",IF('Grand Total-All
> Detail'!$A$3:$A$14="Doe",IF('Grand Total-All
> Detail'!$C$3:$C$14=2007,'Grand
> Total-All Detail'!$L$3:$L$14,0),0),0))
>
> The "Grand Total-All Detail" is one of many spreadsheets in the > workbook
> and
> am writing the array formula in another "summary" spread***. It will
> work
> if I enter on same spread*** but don't want it there. Have always > been
> able
> to write this formula to show summaries on a separate spread*** > within
> the
> same workbook.
>
> "Rick Rothstein (MVP - VB)" wrote:
>
>> It might help if you show us your code
>>
>> Rick
>>
>>
>> "sharon t" <sharont@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:E29EC74E-5394-481E-9EDB-86153DCEC18D@xxxxxxxxxxxxxxxx
>> >I am receiving a Run-time error "1004": unable to set the >> >FormulaArray
>> > property of the Range class.
>> >
>> > Stated fix is to install SP2. I have SP3 installed. Does anyone know >> > if
>> > SP3
>> > included that fix that was in SP2? If so, why am I still receiving >> > the
>> > error
>> > and the formula does not work correctly. Thanks.
>>
>>



.