linked cells will not update


T

Tonso

I have an XL2003 workbook that has a sheet with links to cells on
other sheets in the same workbook. When the value changes on, say,
sheet 12, cell H49, the cell in the other sheet, with the formula
='12'!H49 does not change. It used to work, but has stopped. i
have other similar workbooks that still work ok. Calculation is set to
Automatic. What has happened?

Thanks,

Tonso
 
Ad

Advertisements

T

Tonso

I have an XL2003 workbook that has a sheet with links to cells on
other sheets in the same workbook. When the value changes on, say,
sheet 12, cell H49, the cell in the other sheet, with the formula
='12'!H49     does not change. It used to work, but has stopped. i
have other similar workbooks that still work ok. Calculation is set to
Automatic. What has happened?

Thanks,

Tonso

PS - if I double click the cell, then undo the action, that link
starts working. The other links do not start working however.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top