My excel sheet is not updating other files when they are all opened.
The word calculate continues to appear in the ready toolbar at the bottom of
the screen. The calculation option in the tools option is set at automatic,
iteration is ticked and at maximum iterations. When a number changes the
sheet calculates this sheet but not the other opened files. This file is not
linked to any other file (i.e
it is not dependant on any data in any other file)
Can anybody explain what is causing this problem