<div>
it says cannot delete part of a data table
</div>


<div>
Thanks, finnstone.<br />
<br />
It should be the same in 2007 as 2010. Please post a redacted version of the file (with the same problem) and a screenshot showing the error and the table.<br />
<br />
Thanks,<br />
Brian.
</div>


<div>
The error means exactly what it says - you cannot delete part of a data table (since it's an array formula). You will have to clear out the =TABLE(...) formula before you can do that.
</div>


<div>
<div class="content wysiwyg-content">
i am trying to delete column in tab &quot;scores&quot;, how do i do that?
</div>
</div>


i am trying to delete column in tab "scores", how do i do that?

it says cannot delete part of a data table

Thanks, finnstone.

It should be the same in 2007 as 2010. Please post a redacted version of the file (with the same problem) and a screenshot showing the error and the table.

Thanks,
Brian.

The error means exactly what it says - you cannot delete part of a data table (since it&#39;s an array formula). You will have to clear out the =TABLE(...) formula before you can do that.

cannot change part of a table (see attached)

i am trying to delete column in tab &quot;scores&quot;, how do i do that?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.