On page 1 of a workbook in cell A1 I have the formula =A723. The dollar
amount that appears in A723 is displayed. On page 2 of the same workbook in
cell A1 I have the formula =Sheet1!A1. This gives me #VALUE! Instead of the
dollar amount that I need. Please help me.

I have a complicated reason why I can't use page 1 cell A723 on page 2.

Thanks in advance!

--
bob