Article ID: 107905 - View products that this article applies to.
This article was previously published under Q107905
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.
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:
Article ID: 107905 - Last Review: August 15, 2003 - Revision: 1.1
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.