| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
NCAA 2007 NCAA Bracket and Tracker
Error in Tracker tab, cell E28. Any suggestions on how to solve the 'Pick A
Team' without the reference error message? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NCAA 2007 NCAA Bracket and Tracker
No idea what you're talking about. Provide more detail about your problem.
Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. " wrote: Error in Tracker tab, cell E28. Any suggestions on how to solve the 'Pick A Team' without the reference error message? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NCAA 2007 NCAA Bracket and Tracker
Down load the Microsoft Excel Template '2007 NCAA men's bracket w/tracker'.
Once the program is opened. Go to the 'Tracker' Tab and try to pick either Ohio St. or C. Conn St. Even further, try picking from E29 down to E35. The team names do not show due to a referncing error #Ref! I am trying to figure out how to change the #Ref! in [ Pick a team ] to the correct choices. Thank you for requesting further information. I hope this helps. "Dave F" wrote: No idea what you're talking about. Provide more detail about your problem. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. " wrote: Error in Tracker tab, cell E28. Any suggestions on how to solve the 'Pick A Team' without the reference error message? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NCAA 2007 NCAA Bracket and Tracker
Ignore this line: "Then go to cell"
(I changed horses in midstream and didn't fix the grammar.) Dave Peterson wrote: There's a hidden worksheet in that workbook. Window|unhide and unhide Validation Then go to cell 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. wrote: Down load the Microsoft Excel Template '2007 NCAA men's bracket w/tracker'. Once the program is opened. Go to the 'Tracker' Tab and try to pick either Ohio St. or C. Conn St. Even further, try picking from E29 down to E35. The team names do not show due to a referncing error #Ref! I am trying to figure out how to change the #Ref! in [ Pick a team ] to the correct choices. Thank you for requesting further information. I hope this helps. "Dave F" wrote: No idea what you're talking about. Provide more detail about your problem. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. " wrote: Error in Tracker tab, cell E28. Any suggestions on how to solve the 'Pick A Team' without the reference error message? -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NCAA 2007 NCAA Bracket and Tracker
For myself and others who will be pulling this subject up - Thank you! This
resolved the referencing issue and works great. Also, the hiding of the validation sheet is a must for those reading Dave's response. Thank you Dave Peterson and Dave F. "Dave Peterson" wrote: Ignore this line: "Then go to cell" (I changed horses in midstream and didn't fix the grammar.) Dave Peterson wrote: There's a hidden worksheet in that workbook. Window|unhide and unhide Validation Then go to cell 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. wrote: Down load the Microsoft Excel Template '2007 NCAA men's bracket w/tracker'. Once the program is opened. Go to the 'Tracker' Tab and try to pick either Ohio St. or C. Conn St. Even further, try picking from E29 down to E35. The team names do not show due to a referncing error #Ref! I am trying to figure out how to change the #Ref! in [ Pick a team ] to the correct choices. Thank you for requesting further information. I hope this helps. "Dave F" wrote: No idea what you're talking about. Provide more detail about your problem. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. " wrote: Error in Tracker tab, cell E28. Any suggestions on how to solve the 'Pick A Team' without the reference error message? -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NCAA 2007 NCAA Bracket and Tracker
I have the same problem, but I have a trail version of excel 2007 and there
is not an option to unhide the pages. Is there anything else I can do? cas "Dave Peterson" wrote: Ignore this line: "Then go to cell" (I changed horses in midstream and didn't fix the grammar.) Dave Peterson wrote: There's a hidden worksheet in that workbook. Window|unhide and unhide Validation Then go to cell 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. wrote: Down load the Microsoft Excel Template '2007 NCAA men's bracket w/tracker'. Once the program is opened. Go to the 'Tracker' Tab and try to pick either Ohio St. or C. Conn St. Even further, try picking from E29 down to E35. The team names do not show due to a referncing error #Ref! I am trying to figure out how to change the #Ref! in [ Pick a team ] to the correct choices. Thank you for requesting further information. I hope this helps. "Dave F" wrote: No idea what you're talking about. Provide more detail about your problem. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. " wrote: Error in Tracker tab, cell E28. Any suggestions on how to solve the 'Pick A Team' without the reference error message? -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I modify the NCAA bracket with tracker template for a 3 state. | Excel Discussion (Misc queries) | |||
| How do I incorporate the points system for the NCAA bracket in my. | Setting up and Configuration of Excel | |||
| Does any know how to add more columns in the NCAA Excel Tracker? | Excel Discussion (Misc queries) | |||
| NCAA Template Excel | Excel Discussion (Misc queries) | |||
| I have been looking for Pivot table for NCAA Basketball 2004-2005. | Excel Worksheet Functions | |||
Hybrid Mode
