REQ: Where does this =Core1!B13 come from? TIA
 

=Core1!B13
I found the above in a worksheet that figured a person's age based on
their birthday. The thing that has me puzzled is that the cell that
contained birth date is not B13...there isn't (apparently) anything
in B13. Secondly, I couldn't find the term CORE anywhere in the help
file. Any answers. I USED to be reasonably knowledgeable in Excel, but
apparently, they've added some things...or more likely, I wasn't as
proficient as I thought I was. :o)
nonapp

REQ: Where does this =Core1!B13 come from? TIA
 

Hi,

Did you check if there are any sheets named 'Core1'. The formula refers
to cell B13 in the sheet 'Core1'.Unhide the sheets if they are not
visible ordinarily.

Regards

Govind.

nonapp wrote:
=Core1!B13
I found the above in a worksheet that figured a person's age based on
their birthday. The thing that has me puzzled is that the cell that
contained birth date is not B13...there isn't (apparently) anything
in B13. Secondly, I couldn't find the term CORE anywhere in the help
file. Any answers. I USED to be reasonably knowledgeable in Excel, but
apparently, they've added some things...or more likely, I wasn't as
proficient as I thought I was. :o)
nonapp

REQ: Where does this =Core1!B13 come from? TIA
 

Thanks for getting back to me so soon...what you said made sense to
me, but I went back and unprotected, unhid, and pretty much tore it to
pieces and the only two places CORE is mentioned (I did a search by
row AND column...throughout all sheets) is in those two fields. One
(=Core1!B13) determines their current age; two (the one directly below
it which says "=Core1!B21") determines age nearest birthday. There is
NO data in ANY sheet in those two fields. I've spent several hours
searching every known source and I can't figure it out. It's beginning
to be an effort of diminishing returns! Curiosity CAN kill the cat.

On Wed, 25 Jan 2006 13:24:24 +1100, Govind
wrote:

Hi,

Did you check if there are any sheets named 'Core1'. The formula refers
to cell B13 in the sheet 'Core1'.Unhide the sheets if they are not
visible ordinarily.

Regards

Govind.

nonapp wrote:
=Core1!B13
I found the above in a worksheet that figured a person's age based on
their birthday. The thing that has me puzzled is that the cell that
contained birth date is not B13...there isn't (apparently) anything
in B13. Secondly, I couldn't find the term CORE anywhere in the help
file. Any answers. I USED to be reasonably knowledgeable in Excel, but
apparently, they've added some things...or more likely, I wasn't as
proficient as I thought I was. :o)
nonapp

REQ: Where does this =Core1!B13 come from? TIA
 

Well, one thing is for sure Core1 is the name of a sheet, maybe it is
hidden? Look at the sheet tabs not the cells

if the formula works which assume it does since you don't have an error
message, select the formula, do toolsformula auditing, select "Trace
Precedents", double click the line with the arrow, now you should be able to
see the name of the workbook and the sheet and the cell in a dialogue box,
double click the name and you will be taken there if it is not hidden, if
it's hidden you'll go back again to the arrow, if so try formatsheetunhide

--
Regards,

Peo Sjoblom

Portland, Oregon




"nonapp" wrote in message
...
Thanks for getting back to me so soon...what you said made sense to
me, but I went back and unprotected, unhid, and pretty much tore it to
pieces and the only two places CORE is mentioned (I did a search by
row AND column...throughout all sheets) is in those two fields. One
(=Core1!B13) determines their current age; two (the one directly below
it which says "=Core1!B21") determines age nearest birthday. There is
NO data in ANY sheet in those two fields. I've spent several hours
searching every known source and I can't figure it out. It's beginning
to be an effort of diminishing returns! Curiosity CAN kill the cat.

On Wed, 25 Jan 2006 13:24:24 +1100, Govind
wrote:

Hi,

Did you check if there are any sheets named 'Core1'. The formula refers
to cell B13 in the sheet 'Core1'.Unhide the sheets if they are not
visible ordinarily.

Regards

Govind.

nonapp wrote:
=Core1!B13
I found the above in a worksheet that figured a person's age based on
their birthday. The thing that has me puzzled is that the cell that
contained birth date is not B13...there isn't (apparently) anything
in B13. Secondly, I couldn't find the term CORE anywhere in the help
file. Any answers. I USED to be reasonably knowledgeable in Excel, but
apparently, they've added some things...or more likely, I wasn't as
proficient as I thought I was. :o)
nonapp

REQ: Where does this =Core1!B13 come from? TIA
 

Thanks for getting back to me so soon...what you said made sense to
me, but I went back and unprotected, unhid, and pretty much tore it to
pieces and the only two places CORE is mentioned (I did a search by
row AND column...throughout all sheets) is in those two fields. One
(=Core1!B13) determines their current age; two (the one directly below
it which says "=Core1!B21") determines age nearest birthday. There is
NO data in ANY sheet in those two fields. I've spent several hours
searching every known source and I can't figure it out. It's beginning
to be an effort of diminishing returns! Curiosity CAN kill the cat.

On Wed, 25 Jan 2006 13:24:24 +1100, Govind
wrote:

Hi,

Did you check if there are any sheets named 'Core1'. The formula refers
to cell B13 in the sheet 'Core1'.Unhide the sheets if they are not
visible ordinarily.

Regards

Govind.

nonapp wrote:
=Core1!B13
I found the above in a worksheet that figured a person's age based on
their birthday. The thing that has me puzzled is that the cell that
contained birth date is not B13...there isn't (apparently) anything
in B13. Secondly, I couldn't find the term CORE anywhere in the help
file. Any answers. I USED to be reasonably knowledgeable in Excel, but
apparently, they've added some things...or more likely, I wasn't as
proficient as I thought I was. :o)
nonapp

REQ: Where does this =Core1!B13 come from? TIA
 

You were correct! I knew it had to be...Merlin has been dead for
centuries, so there had to be a "Core" sheet. But I swear I looked at
un-hide EVERYTHING. I don't know how I missed it. I guess
that's why we pool our ignorance on these News Groups. Thanks so very
much. There is a ton of great stuff on "Core1" that will really help
me in my business. May you have a warm feeling for helping me that has
nothing to do with wetting your pants! :o)
Thanks,
nonapp

On Tue, 24 Jan 2006 19:59:59 -0800, "Peo Sjoblom"
wrote:

Well, one thing is for sure Core1 is the name of a sheet, maybe it is
hidden? Look at the sheet tabs not the cells

if the formula works which assume it does since you don't have an error
message, select the formula, do toolsformula auditing, select "Trace
Precedents", double click the line with the arrow, now you should be able to
see the name of the workbook and the sheet and the cell in a dialogue box,
double click the name and you will be taken there if it is not hidden, if
it's hidden you'll go back again to the arrow, if so try formatsheetunhide