Normally, if one file is opened, we note that the calculations and links automatically get updated. If not, we choose the tools option/calculation/select automatic and we note that it happens that way for all files opened later. But, today, I observed that every file needs to be done with this change otherwise the cells with formula do not change with regard to any change in source value! What could have gone wrong! Can I get help? Thanks. Sharad.