| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. . |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. . |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complex conditional summing - array COUNT works, array SUM gives#VALUE | Excel Worksheet Functions | |||
| Array formula: how to join 2 ranges together to form one array? | Excel Worksheet Functions | |||
| Prevent cell/array references from changing when altering/moving thecell/array | Excel Discussion (Misc queries) | |||
| meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
| combining cells and array from different sheets into an array to pass to IRR() | Excel Discussion (Misc queries) | |||
Linear Mode
