View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mrbill mrbill is offline
external usenet poster
 
Posts: 12
Default Workbook LOCKED - Up

091116 Workbook LOCKED - Up

hi, I have ran into a strange formula problem. a line that works follows,
the next example somehow got inserted into my sheet.

=IF(OR(COUNTIF(EO563:EP563,{"",0,"n/a"})),0,1)


This example has 3 0's, had to find this problem the hard way (deleting all
cols/rows around it till found).
SYMPTOMS: (HOW DO I DELETE ROWS, thanks)

- CAN ADD DATA & SAVE, BUT NOT CALCULATE SHEET. sheet will close as
"excel has experienced an error & must close".

- CAN NOT DELETE ROWS, same consequence.

- "CAN" copy above & below 2 problems rows, to a new sheet, but columns
are not at desired width (too many columns).

=IF(OR(COUNTIF(EO563:EP563,{"0","0","0"})),0,1)

NOTE: could not reproduce error as such, must be some kind of error hook to
these 2 rows, that have this formula.

:) you can ask for more details, but have no idea what else would pertain.