ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   error when you get to ohio st (https://www.excelbanter.com/new-users-excel/134537-error-when-you-get-ohio-st.html)

GWMOORE

error when you get to ohio st
 
how do I fix?

Wood Grafing

error when you get to ohio st
 
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.

"GWMOORE" wrote:

how do I fix?


Dave Peterson

error when you get to ohio st
 
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

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

Max

error when you get to ohio st
 
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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Dave Peterson

error when you get to ohio st
 
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/te...166811033.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.




Max wrote:

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


--

Dave Peterson

Max

error when you get to ohio st
 
Thanks for clarifying, Dave
My apologies for misreading your earlier response
No way I would have been able to unravel it earlier
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Dave Peterson

error when you get to ohio st
 
There was a post in another newsgroup that gave me the hint.

Max wrote:

Thanks for clarifying, Dave
My apologies for misreading your earlier response
No way I would have been able to unravel it earlier
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


--

Dave Peterson

Roger Govier

error when you get to ohio st
 
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?

--
Regards

Roger Govier


"Dave Peterson" wrote in message
...
There was a post in another newsgroup that gave me the hint.

Max wrote:

Thanks for clarifying, Dave
My apologies for misreading your earlier response
No way I would have been able to unravel it earlier
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


--

Dave Peterson




Sandy Mann

error when you get to ohio st
 
"Dave Peterson" wrote in message
...
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

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Dave Peterson" wrote in message
...
There was a post in another newsgroup that gave me the hint.

Max wrote:

Thanks for clarifying, Dave
My apologies for misreading your earlier response
No way I would have been able to unravel it earlier
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


--

Dave Peterson




Dave Peterson

error when you get to ohio st
 
I couldn't make it.

Besides, someone has to be here to answer:
Tools|Options|General Tab|Uncheck R1C1 Reference style


Roger Govier wrote:

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?

--
Regards

Roger Govier

"Dave Peterson" wrote in message
...
There was a post in another newsgroup that gave me the hint.

Max wrote:

Thanks for clarifying, Dave
My apologies for misreading your earlier response
No way I would have been able to unravel it earlier
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


--

Dave Peterson


--

Dave Peterson

Roger Govier

error when you get to ohio st
 
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

--
Regards

Roger Govier


"Dave Peterson" wrote in message
...
I couldn't make it.

Besides, someone has to be here to answer:
Tools|Options|General Tab|Uncheck R1C1 Reference style


Roger Govier wrote:

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?

--
Regards

Roger Govier

"Dave Peterson" wrote in message
...
There was a post in another newsgroup that gave me the hint.

Max wrote:

Thanks for clarifying, Dave
My apologies for misreading your earlier response
No way I would have been able to unravel it earlier
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

--

Dave Peterson


--

Dave Peterson




Dave Peterson

error when you get to ohio st
 
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.

Roger Govier wrote:

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

--
Regards

Roger Govier

"Dave Peterson" wrote in message
...
I couldn't make it.

Besides, someone has to be here to answer:
Tools|Options|General Tab|Uncheck R1C1 Reference style


Roger Govier wrote:

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?

--
Regards

Roger Govier

"Dave Peterson" wrote in message
...
There was a post in another newsgroup that gave me the hint.

Max wrote:

Thanks for clarifying, Dave
My apologies for misreading your earlier response
No way I would have been able to unravel it earlier
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

Gord Dibben

error when you get to ohio st
 
Dave

I'm still here being helping with the ToolsOptions questions.


Gord

On Tue, 13 Mar 2007 10:57:34 -0500, Dave Peterson
wrote:

I couldn't make it.

Besides, someone has to be here to answer:
Tools|Options|General Tab|Uncheck R1C1 Reference style


Roger Govier wrote:

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?

--
Regards

Roger Govier

"Dave Peterson" wrote in message
...
There was a post in another newsgroup that gave me the hint.

Max wrote:

Thanks for clarifying, Dave
My apologies for misreading your earlier response
No way I would have been able to unravel it earlier
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

--

Dave Peterson



Dave Peterson

error when you get to ohio st
 
I sent you a private message for a different question (that I failed with).

Maybe you can jump in there?????

Gord Dibben wrote:

Dave

I'm still here being helping with the ToolsOptions questions.

Gord

On Tue, 13 Mar 2007 10:57:34 -0500, Dave Peterson
wrote:

I couldn't make it.

Besides, someone has to be here to answer:
Tools|Options|General Tab|Uncheck R1C1 Reference style


Roger Govier wrote:

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?

--
Regards

Roger Govier

"Dave Peterson" wrote in message
...
There was a post in another newsgroup that gave me the hint.

Max wrote:

Thanks for clarifying, Dave
My apologies for misreading your earlier response
No way I would have been able to unravel it earlier
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

--

Dave Peterson


--

Dave Peterson

Max

error when you get to ohio st
 
For the benefit of all, would MS be correcting the template at source?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dave Peterson" wrote in message
...
There was a post in another newsgroup that gave me the hint.




Gord Dibben

error when you get to ohio st
 
I'll try to have a shot at it.

Gord

On Wed, 14 Mar 2007 14:25:22 -0500, Dave Peterson
wrote:

I sent you a private message for a different question (that I failed with).

Maybe you can jump in there?????

Gord Dibben wrote:

Dave

I'm still here being helping with the ToolsOptions questions.

Gord

On Tue, 13 Mar 2007 10:57:34 -0500, Dave Peterson
wrote:

I couldn't make it.

Besides, someone has to be here to answer:
Tools|Options|General Tab|Uncheck R1C1 Reference style


Roger Govier wrote:

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?

--
Regards

Roger Govier

"Dave Peterson" wrote in message
...
There was a post in another newsgroup that gave me the hint.

Max wrote:

Thanks for clarifying, Dave
My apologies for misreading your earlier response
No way I would have been able to unravel it earlier
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

--

Dave Peterson



Dave Peterson

error when you get to ohio st
 
It's fixed now.



Max wrote:

For the benefit of all, would MS be correcting the template at source?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dave Peterson" wrote in message
...
There was a post in another newsgroup that gave me the hint.


--

Dave Peterson

Max

error when you get to ohio st
 
Glad to hear that.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dave Peterson" wrote in message
...
It's fixed now.





All times are GMT +1. The time now is 10:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com