Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|