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/36770

From BetaArchive Wiki

“Can’t Change Part of Table” Error Message PSS ID Number: Q36770 Article last modified on 02-26-1993 PSS database name: W_eXceL

2.x 3.00



If you try to insert a new row or column into a defined array table, you will receive the following error message:

Can’t Change Part of Table

In order to insert a new value into an array table, do the following:

  1. Select the range containing the array formulas generated by the table.
  2. Use the Edit Clear command to erase the formulas.
  3. Insert the new row or column using the Edit Insert command.
  4. Add the new value to the row or column of values to be substituted into the input cell.
  5. Select the new table range including inserted row or column.
  6. Redefine the array table using the Data Table command.

Additional reference words: 2.10 2.1 3.0 3.00

Copyright Microsoft Corporation 1993.