Excel Err Msg: "Cannot Change Part of an Array"

Last reviewed: February 2, 1998
Article ID: Q107905

The information in this article applies to:
  • Microsoft Excel for Windows versions 3.0, 4.0, 4.0a, 5.0, 5.0c
  • Microsoft Excel for the Macintosh versions 3.0, 4.0, 5.0, 5.0a
  • Microsoft Excel for Windows 95, versions 7.0, 7.0a
  • Microsoft Excel 97 for Windows
  • Microsoft Excel 98 Macintosh Edition

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, do either of the following 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 re-enter the array formula.


Additional query words: 3.00 4.00 4.00a 5.00 5.00a 5.00c 7.00 7.00a 97 98
XL98 XL97 XL7 XL5 XL4
Keywords : kberrmsg
Version : WINDOWS:3.0,4.0,5.0,5.0c,7.0,97; MACINTOSH:3.0,4.0,5.0,98
Platform : MACINTOSH WINDOWS
Issue type : kbprb


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.