I work with big excel files (almost 7MB), with most of the worksheets linking
back and forth. I have discovered that sometimes when I change a cell on a
worksheet, it does not automatically update the cells on the linked
worksheets. The only way to do it is to go to each dependent cell
individually to update, this is very time consuming. I have double checked
that the automatical update is checked in the options. Has anyone
experienced this and does anyone have a solution? Thanks.