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