On 3/29/08 6:16 AM, in article
jemcgimpsey-978D26.07164129032008@news.microsoft.com, "JE McGimpsey"
<jemcgimpsey@mvps.org> wrote:
>> I have little green indicators on the top left of every cell that are the
>> sum of other cells that some may not have a value.
>> How do I disable this feature
>
> Preferences/Error Checking, uncheck the "Enable background error
> checking" checkbox.
Is there a way to ONLY disable error checking of selected cells in a
specific spreadsheet?
Or, if not, is there a way to turn off error checking for ONLY the whole of
a specific spreadsheet?
(Background: The spreadsheet in question has monthly entries over the years
in a number of columns and rows. Up to a couple times each year, several
no-longer-active rows are moved to the bottom of the spreadsheet where
they're kept for historic purposes. But such moves cause neighboring cells
and still-active-cells' totals to be marked as errors even when no errors
exist.)
Respectfully, Norm
Bob Greenblatt - 31 Mar 2008 13:33 GMT
On 3/29/08 6:39 PM, in article
C4141346.67D4%nnager@vnoxsxpxaxmv.fullerton.edu, "Norman R. Nager, Ph.D."
<nnager@vnoxsxpxaxmv.fullerton.edu> wrote:
> On 3/29/08 6:16 AM, in article
> jemcgimpsey-978D26.07164129032008@news.microsoft.com, "JE McGimpsey"
[quoted text clipped - 21 lines]
>
> Respectfully, Norm
The error checking parameters are global to excel. You can turn it off for
specific error types, but not for specific cells, or worksheets.

Signature
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom