I have a signal (traffic light) cell on a main menu page which records any maintenance issues entered against any of of our 300 trailers. I work using a remote network connection and in my PC all data changes which change the cell inicators happen in real time. When I go into the office and use a terminal there every function and macro works fine but the changes are not reflected in real time. You have to close and then open the file, then they change. I thought it might be the version of excel on the terminal I was using so I tried same on the server itself(in theory the version of excel I am operating remotely) but it does not update there either in real time. All machines run excel 2000. Just for info I logged a different laptop into the LAN as a remote connection and it again works fine through the remote connection. Can anyone help.