| 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 |
|
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
error when you get to ohio st
Hi Dave
Why aren't you in Seattle? Or are you there and you have skipped some of the sessions to come on line and answer a few more posts? -- Regards Roger Govier "Dave Peterson" wrote in message ... 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 |
|
#10
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
error when you get to ohio st
"Dave Peterson" wrote in message
... There was a post in another newsgroup that gave me the hint. And there was me thinking that it was a mind reading act again <g -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "Dave Peterson" wrote in message ... 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 |
|
#11
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
error when you get to ohio st
I couldn't make it.
Besides, someone has to be here to answer: Tools|Options|General Tab|Uncheck R1C1 Reference style Roger Govier wrote: Hi Dave Why aren't you in Seattle? Or are you there and you have skipped some of the sessions to come on line and answer a few more posts? -- Regards Roger Govier "Dave Peterson" wrote in message ... 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 -- Dave Peterson |
|
#12
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
error when you get to ohio st
Hi Dave
I couldn't make it. Shame, I'm sure you'll be sorely missed. On the other hand, great for us that you're still around whilst everyone else is drinking (I mean working)<vbg -- Regards Roger Govier "Dave Peterson" wrote in message ... I couldn't make it. Besides, someone has to be here to answer: Tools|Options|General Tab|Uncheck R1C1 Reference style Roger Govier wrote: Hi Dave Why aren't you in Seattle? Or are you there and you have skipped some of the sessions to come on line and answer a few more posts? -- Regards Roger Govier "Dave Peterson" wrote in message ... 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 -- Dave Peterson |
|
#13
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
error when you get to ohio st
From what it sounds like, there's a lot of working during the days. And I think
they all do "homework" to prepare for the next day's meetings. Roger Govier wrote: Hi Dave I couldn't make it. Shame, I'm sure you'll be sorely missed. On the other hand, great for us that you're still around whilst everyone else is drinking (I mean working)<vbg -- Regards Roger Govier "Dave Peterson" wrote in message ... I couldn't make it. Besides, someone has to be here to answer: Tools|Options|General Tab|Uncheck R1C1 Reference style Roger Govier wrote: Hi Dave Why aren't you in Seattle? Or are you there and you have skipped some of the sessions to come on line and answer a few more posts? -- Regards Roger Govier "Dave Peterson" wrote in message ... 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 -- Dave Peterson -- Dave Peterson |
|
#14
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
error when you get to ohio st
Dave
I'm still here being helping with the ToolsOptions questions. Gord On Tue, 13 Mar 2007 10:57:34 -0500, Dave Peterson wrote: I couldn't make it. Besides, someone has to be here to answer: Tools|Options|General Tab|Uncheck R1C1 Reference style Roger Govier wrote: Hi Dave Why aren't you in Seattle? Or are you there and you have skipped some of the sessions to come on line and answer a few more posts? -- Regards Roger Govier "Dave Peterson" wrote in message ... 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 |
|
#15
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
error when you get to ohio st
I sent you a private message for a different question (that I failed with).
Maybe you can jump in there????? Gord Dibben wrote: Dave I'm still here being helping with the ToolsOptions questions. Gord On Tue, 13 Mar 2007 10:57:34 -0500, Dave Peterson wrote: I couldn't make it. Besides, someone has to be here to answer: Tools|Options|General Tab|Uncheck R1C1 Reference style Roger Govier wrote: Hi Dave Why aren't you in Seattle? Or are you there and you have skipped some of the sessions to come on line and answer a few more posts? -- Regards Roger Govier "Dave Peterson" wrote in message ... 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 -- Dave Peterson |
|
#16
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
error when you get to ohio st
For the benefit of all, would MS be correcting the template at source?
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Dave Peterson" wrote in message ... There was a post in another newsgroup that gave me the hint. |
|
#17
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
error when you get to ohio st
I'll try to have a shot at it.
Gord On Wed, 14 Mar 2007 14:25:22 -0500, Dave Peterson wrote: I sent you a private message for a different question (that I failed with). Maybe you can jump in there????? Gord Dibben wrote: Dave I'm still here being helping with the ToolsOptions questions. Gord On Tue, 13 Mar 2007 10:57:34 -0500, Dave Peterson wrote: I couldn't make it. Besides, someone has to be here to answer: Tools|Options|General Tab|Uncheck R1C1 Reference style Roger Govier wrote: Hi Dave Why aren't you in Seattle? Or are you there and you have skipped some of the sessions to come on line and answer a few more posts? -- Regards Roger Govier "Dave Peterson" wrote in message ... 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 |
|
#18
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
error when you get to ohio st
It's fixed now.
Max wrote: For the benefit of all, would MS be correcting the template at source? -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Dave Peterson" wrote in message ... There was a post in another newsgroup that gave me the hint. -- Dave Peterson |
|
#19
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
error when you get to ohio st
Glad to hear that.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Dave Peterson" wrote in message ... It's fixed now. |
| 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) | |||
Linear Mode
