Hmm... I've got to think that the problem lies with cell formatting.

Select the cell on your second worksheet where you're entering the formula.
From the FORMAT Menu, choose "Cells"
On the Number Tab, choose "General"
Click OK
Type in =
Select your first worksheet, then click on the cell to be referenced
Hit ENTER

That should work. Is it still displaying the formula instead of the
results? If so, I'm really at a loss as to why.

HTH,
Elkar


"David Gerstman" wrote:

Elkar,

I'm sorry. (And sorry about my lack of clarity.)
But neither of those solutions (I'm using Excel) 2003 is doing it.

David

"Elkar" wrote:

Ok, I misunderstood. This is probably one of two things then. Either your
cell is pre-formatted as text, thus formulas entered will be treated as text
strings. Or, your sheet settings are set to display formulas.

First off, try pre-formatting the cell as "General" then enter your formula.

If that doesn't solve the problem, then try:

In Excel 2003 or earilier:
From the TOOLS Menu, choos "Options"
On the VIEW Tab, uncheck "Formulas"
Click OK

In Excel 2007:
Click on the OFFICE Button
Click on the "Excel Options" Button
Click on the "Advanced" Tab
Scroll down to the "Display Options for this Worksheet" section
Uncheck "Show formulas in cells" option
Click OK

HTH,
Elkar


"David Gerstman" wrote:

Elkar,

Thank you for the response, but that did not do the trick.

I still get the formula displayed and not the value.

David

"Elkar" wrote:

When referencing a merged cell, only reference the top-left most cell in the
merged area. So, in your case:

='07PAGE-1'!B7

HTH,
Elkar