cell referencing

[djohns158]

I have a workbook with 20 pages. On one page I am trying to reference
cells from other pages. Example: I want cell B2 on the Shipping page
to emulate cell C7 on the PO-1 page. I type the following command in
Shipping B2: ='PO-1'C7 however, when I hit enter, the formula
shows in Shipping B2. If I go and put a number in PO-1 C7, nothing
changes on the Shipping cell. It continues to show the formula which
I typed in. The cells are not formatted or conditionally formatted.
Are there any other possible solutions? Where would you start to
look? I appreciate your help. Thank you.

 

[Tyro]

You formula is wrong. It should be =PO-1!C7 Also, it appears that B2 is
formatted as text. Make sure the cell B2 is formatted as general and then
select B2 and press F2 then enter.

Tyro

 

[djohns158]

I have a workbook with 20 pages.  On one page I am trying to reference
cells from other pages.  Example:  I want cell B2 on the Shipping page
to emulate cell C7 on the PO-1 page.  I type the following command in
Shipping B2:  ='PO-1'C7     however, when I hit enter, the formula
shows in Shipping B2.  If I go and put a number in PO-1 C7, nothing
changes on the Shipping cell.  It continues to show the formula which
I typed in.  The cells are not formatted or conditionally formatted.
Are there any other possible solutions?  Where would you start to
look?  I appreciate your help.  Thank you.

addendum: The formula I typed in is actually ='PO-1'!C7

 

[T. Valko]

Well, for one thing, the formula is incorrect. It should be:

='PO - 1'!C7

If that's what's showing in the cell then try this:

Select the cell in question
Goto the menu Format>Cells>Number tab>GENERAL>OK
Press function key F2 then hit ENTER

 

[djohns158]

Well, for one thing, the formula is incorrect. It should be:

='PO - 1'!C7

If that's what's showing in the cell then try this:

Select the cell in question
Goto the menu Format>Cells>Number tab>GENERAL>OK
Press function key F2 then hit ENTER

--
Biff
Microsoft Excel MVP






- Show quoted text -

Thank you very much. That worked perfectly!!! Thanks again.
Daryl

 

[T. Valko]

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP

Well, for one thing, the formula is incorrect. It should be:

='PO - 1'!C7

If that's what's showing in the cell then try this:

Select the cell in question
Goto the menu Format>Cells>Number tab>GENERAL>OK
Press function key F2 then hit ENTER

--
Biff
Microsoft Excel MVP






- Show quoted text -

Thank you very much. That worked perfectly!!! Thanks again.
Daryl