Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/107905

From BetaArchive Wiki
Knowledge Base


"Cannot Change Part of an Array" Error Message

Article ID: 107905

Article Last Modified on 8/15/2003



APPLIES TO

  • Microsoft Excel 97 Standard Edition



This article was previously published under Q107905

SYMPTOMS

In Microsoft Excel, you may receive the error message "Cannot change part of an array" when you attempt to edit one of the cells that make up an array formula.

WORKAROUND

To cancel the error message, click OK, and then click the "X" button in the formula bar (or press ESC).

To determine which cells make up the array, use either of the following methods to highlight the range that makes up the array formula:

  • Choose one of the cells that you know is in the array formula. On the Formula menu, click Select Special, and then click Current Array. In Microsoft Excel versions 5.0 and later, follow these steps:


1. On the Edit menu, click Go To. Or, press F5.

2. In the Go To dialog box, click Special.

3. In the Go To Special dialog box, click Current Array, and then click OK.

-or-

  • Press CTRL+SHIFT and double-click a cell that you know makes up that array. After selecting the entire range that contains the array formula, edit the formula and press CTRL+SHIFT+ENTER if you are using Microsoft Excel for Windows, or COMMAND+RETURN if you are using Microsoft Excel for the Macintosh to reenter the array formula.



Additional query words: 4.00a 5.00a 5.00c 7.00a 97 XL97 XL7 XL5 XL4 XL

Keywords: kberrmsg kbprb KB107905