2007 Men's Tourney Bracket #REF error

[Mike]

I am using Excel 2007. For some reason the entire South bracket shows a #REF
error on the 'Tracker' sheet when trying to select a team. Am I doing
something wrong? Please advise.

Thanks

 

[Johnbes]

Hi Mike, Can you send the URL of the template you downloaded and we can look
into it further.

Thanks,
John

 

[cheese]

http://office.microsoft.com/en-us/templates/CT011865541033.aspx

It's bugged for sure. Can't pick any teams after Ohio State

 

[Johnbes]

Hi, Go to the download page of the template you are having trouble with,
you'll have to click on the specific template in the category to get there.
I'm looking for a url like
http://office.microsoft.com/en-us/templates/TC102166811033.aspx?CategoryID=CT011865541033

Thanks,
John

 

[Annon]

Hi,

I just downloaded the Excel template and im using Excel'02. I am getting the
same '#REF' from cell 28-35. When i click on the drop down. The options are
'#REF'

 

[cheese]

http://office.microsoft.com/en-us/templates/TC102166811033.aspx?CategoryID=CT011865541033

this is the one that's bugged

 

[cheese]

http://office.microsoft.com/en-us/templates/TC102166811033.aspx?CategoryID=CT011865541033

Go to the second tab "Tracker" and try to select a team in cell E28, E29,
etc. #REF error.

 

[Johnbes]

Good find! This was updated last night on Office.Microsoft.Com by the
Template authors and there is indeed an error. The author is working on it
right now and hopes to get an update live by tomorrow afternoon. In the
meantime, please use the templates on http://www.Johnbes.com.

Thanks,
John

 

[matthos]

the fix is now live on the site

Good find! This was updated last night on Office.Microsoft.Com by the
Template authors and there is indeed an error. The author is working on it
right now and hopes to get an update live by tomorrow afternoon. In the
meantime, please use the templates on http://www.Johnbes.com.

Thanks,
John