 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2007error when you get to ohio st
how do I fix? 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. > how do I fix? 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. > how do I fix?  SignatureDave Peterson Make that Format|Sheet|Unhide (not Window|Unhide). If you're using xl2007, then rightclick on any tab and select Unhide... > There's a hidden worksheet in that workbook. > [quoted text clipped - 19 lines] > > Dave Peterson SignatureDave Peterson 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> SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- 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/templates/TC102166811033.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. > 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> [quoted text clipped - 4 lines] > xdemechanik > --- SignatureDave Peterson Thanks for clarifying, Dave My apologies for misreading your earlier response No way I would have been able to unravel it earlier SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- There was a post in another newsgroup that gave me the hint. > Thanks for clarifying, Dave > My apologies for misreading your earlier response [quoted text clipped - 5 lines] > xdemechanik > --- SignatureDave Peterson 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? SignatureRegards Roger Govier > There was a post in another newsgroup that gave me the hint. > [quoted text clipped - 7 lines] >> xdemechanik >> --- I couldn't make it. Besides, someone has to be here to answer: Tools|Options|General Tab|Uncheck R1C1 Reference style > Hi Dave > [quoted text clipped - 22 lines] > > > > Dave Peterson SignatureDave Peterson 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> SignatureRegards Roger Govier >I couldn't make it. > [quoted text clipped - 27 lines] >> > >> > Dave Peterson 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. > Hi Dave > >I couldn't make it. [quoted text clipped - 42 lines] > > > > Dave Peterson SignatureDave Peterson Dave I'm still here being helping with the Tools>Options questions. Gord >I couldn't make it. > [quoted text clipped - 27 lines] >> > >> > Dave Peterson I sent you a private message for a different question (that I failed with). Maybe you can jump in there????? > Dave > [quoted text clipped - 33 lines] > >> > > >> > Dave Peterson SignatureDave Peterson I'll try to have a shot at it. Gord >I sent you a private message for a different question (that I failed with). > [quoted text clipped - 37 lines] >> >> > >> >> > Dave Peterson > 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> SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace@mailinator.com with @tiscali.co.uk > There was a post in another newsgroup that gave me the hint. > [quoted text clipped - 7 lines] >> xdemechanik >> --- For the benefit of all, would MS be correcting the template at source? SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > There was a post in another newsgroup that gave me the hint. It's fixed now. > For the benefit of all, would MS be correcting the template at source? > -- [quoted text clipped - 4 lines] > --- > > There was a post in another newsgroup that gave me the hint. SignatureDave Peterson Glad to hear that. SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > It's fixed now. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.