LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Shared workbook locked Aram Excel Discussion (Misc queries) 0 April 29th 08 09:07 PM
Shared Workbook - locked for editing CJZ Excel Discussion (Misc queries) 2 June 19th 07 04:34 PM
Worksheets -locked out of my own workbook. Rick M Excel Discussion (Misc queries) 1 October 13th 06 11:16 PM
Shared workbook - Locked Error Elizabeth Excel Discussion (Misc queries) 0 October 11th 06 06:00 AM
Open A Locked Workbook cal_yeo Excel Worksheet Functions 5 July 4th 05 03:33 PM


All times are GMT +1. The time now is 07:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"