Read data from other worksheets
Posted by Mindy on June 22, 2001 6:23 AM
The is Excel 97 SR-2 file. I have a workbook contains multiple worksheets.
For example, in the worksheet1, I have a colume 'A1' with the formula of sum(A12:Z12).
Now in the worksheet2, I would like to have the link data of 'A1' from worksheet1.
In the worksheet2 on the colume I am going to link the data, I type =Sheet1!A1 .
I get the data back on the sheet2 of 0 instead of summary data from the sheet1.
Anyone has any idea of what i did wrong here?
Thank you very much for helping