I have a form in Excel.
The second (work)sheet of this form references a field from the first
(work)sheet. (Specifically the name.)
So I enter the "=" and then I click on the first (work)sheet and click on
the cell I want to reference and click "enter" and this is what I get on the
second sheet.
='07PAGE-1'!B7:I7

It doesn't resolve itself into the name.

Why not?
Clicking on the accompanying error message it seems possible that it doesn't
work because the cells (both the source and the destination) have been merged.

Is that what's wrong? If so is there a workaround?

Is there a different mistake?

Thanks.

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


"David Gerstman" wrote:

I have a form in Excel.
The second (work)sheet of this form references a field from the first
(work)sheet. (Specifically the name.)
So I enter the "=" and then I click on the first (work)sheet and click on
the cell I want to reference and click "enter" and this is what I get on the
second sheet.
='07PAGE-1'!B7:I7

It doesn't resolve itself into the name.

Why not?
Clicking on the accompanying error message it seems possible that it doesn't
work because the cells (both the source and the destination) have been merged.

Is that what's wrong? If so is there a workaround?

Is there a different mistake?

Thanks.

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

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

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

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