Why aren't links between tabs in same workbook automatically updat
 

I have links between cells in a single Excel workbook, but then I change the
data in the source cell it is not consistantly updating it in the linked
cell. Is this common and how do I fix it?

If you mean links like this
=Sheet2!B1

See ToolsOptions..Calculation
Set it to automatic

--
Regards Ron de Bruin
http://www.rondebruin.nl



"UMP-07" wrote in message
...
I have links between cells in a single Excel workbook, but then I change
the
data in the source cell it is not consistantly updating it in the linked
cell. Is this common and how do I fix it?