View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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