It works thank you so much.
Cassie

"Dave Peterson" wrote:

First, I made a mistake. It isn't window|Unhide window.

It was Format|Sheet|Unhide sheet

In xl2007, you can rightclick on any sheet tab and select Unhide...

Mark found the location (without my help), but he should have yelled at me
<vbg!

cassie wrote:

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


--

Dave Peterson