Array
 

Sometimes I get an error message, "You can't change part of an array". Two
cells apparently get linked. How do I get out of this.

Array
 

Checkout the below

http://support.microsoft.com/default.aspx/kb/214054

--
Jacob


"PAL" wrote:

Sometimes I get an error message, "You can't change part of an array". Two
cells apparently get linked. How do I get out of this.

Array
 

Select all the cells which are using the array formula, before entering the
formula with control shift enter.
--
David Biddulph

"PAL" wrote in message
...
Sometimes I get an error message, "You can't change part of an array".
Two
cells apparently get linked. How do I get out of this.

Array
 

Formula is already there. Do I have to redo formula?

"David Biddulph" wrote:

Select all the cells which are using the array formula, before entering the
formula with control shift enter.
--
David Biddulph

"PAL" wrote in message
...
Sometimes I get an error message, "You can't change part of an array".
Two
cells apparently get linked. How do I get out of this.


.

Array
 

You said you were trying to change the formula.
--
David Biddulph

"PAL" wrote in message
...
Formula is already there. Do I have to redo formula?

"David Biddulph" wrote:

Select all the cells which are using the array formula, before entering
the
formula with control shift enter.
--
David Biddulph

"PAL" wrote in message
...
Sometimes I get an error message, "You can't change part of an array".
Two
cells apparently get linked. How do I get out of this.


.

Array
 

PAL wrote...
Sometimes I get an error message, "You can't change part of an array". *Two
cells apparently get linked. *How do I get out of this.

If you want to 'unlink' the cells, meaning each of these cells'
formulas would become regular formulas, hold down a [Ctrl] and a
[Shift] key and double click on the cell with the problem formula to
select all the cells in the array, press [F2] to edit the formula,
then hold down a [Ctrl] key and press [Enter]. The formulas in all the
selected cells will now be separate, regular formulas, but it's
possible they may all return #VALUE!. That depends on what the
formulas are.