| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
error when you get to ohio st
how do I fix?
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
error when you get to ohio st
It would make it much easier for us to understand the question, if you
actually provided a full question with information we can work with. Give some details. "GWMOORE" wrote: how do I fix? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
error when you get to ohio st
There's a hidden worksheet in that workbook.
Window|unhide and unhide Validation The formula in Y2 should be: =Bracket!R40 The formula in Y3 should be: =Bracket!R42 The Formula in Z2 should be: =Bracket!R44 The Formula in Z2 should be: =Bracket!R46 Each column is the previous cell +4 rows (R40, R44, R48, ... or R42, R46, R50, ....) Then rehide the Validation sheet (to keep prying fingers off it!). I didn't look any further, though. GWMOORE wrote: how do I fix? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
error when you get to ohio st
Make that Format|Sheet|Unhide (not Window|Unhide).
If you're using xl2007, then rightclick on any tab and select Unhide... Dave Peterson wrote: There's a hidden worksheet in that workbook. Window|unhide and unhide Validation The formula in Y2 should be: =Bracket!R40 The formula in Y3 should be: =Bracket!R42 The Formula in Z2 should be: =Bracket!R44 The Formula in Z2 should be: =Bracket!R46 Each column is the previous cell +4 rows (R40, R44, R48, ... or R42, R46, R50, ...) Then rehide the Validation sheet (to keep prying fingers off it!). I didn't look any further, though. GWMOORE wrote: how do I fix? -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
error when you get to ohio st
There's probably no "ohio st" that I know of where I am, Dave.
But think I could try your steps to uncover it <g -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
error when you get to ohio st
The NCAA College basketball tournament is starting this week.
MS provides a template for office pools, er, entertainment purposes only: http://office.microsoft.com/en-us/te...166811033.aspx But there's a problem with a couple of formulas--and the cells with the formulas are used as a list in some Data|Validation cells. Ohio State University was awarded a number one seed (so they'll play a #16 seed). They've had a very good year. Max wrote: There's probably no "ohio st" that I know of where I am, Dave. But think I could try your steps to uncover it <g -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
error when you get to ohio st
Thanks for clarifying, Dave
My apologies for misreading your earlier response No way I would have been able to unravel it earlier -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
error when you get to ohio st
There was a post in another newsgroup that gave me the hint.
Max wrote: Thanks for clarifying, Dave My apologies for misreading your earlier response No way I would have been able to unravel it earlier -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
| Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
| I have Error 1919 Error Configuring ODBC dataSource Database | Excel Discussion (Misc queries) | |||
| Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
Hybrid Mode
