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.