Array

  • Thread starter Thread starter PAL
  • Start date Start date
P

PAL

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.
 
PAL said:
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.
Click to expand...

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.
 
Back
Top