Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Shared workbook locked | Excel Discussion (Misc queries) | |||
Shared Workbook - locked for editing | Excel Discussion (Misc queries) | |||
Worksheets -locked out of my own workbook. | Excel Discussion (Misc queries) | |||
Shared workbook - Locked Error | Excel Discussion (Misc queries) | |||
Open A Locked Workbook | Excel Worksheet Functions |