F
faureman via OfficeKB.com
I have Excel files running as scoreboard displays in a plant environment.
There are 4 different PCs running their own Excel-based presentation files.
My goal is to ensure that each one - when rebooted - will start up (without
any dialog boxes) autoupdate and begin running without any human intervention.
Concerning Excel Settings: All 4 Excel settings appear to be set up
consistently. The worksheets have external links to PLCs (all based on the
same source worksheet on each PC) and every individual link is set to update
automatically (under Edit, Links...) as well as autoupdating w/o message on
startup. Next, all four scoreboards have "Ask to Update Automatic Links"
DESELCTED in the edit tab on the "Tools, Options..." menu - meaning that they
should just start on reboot. Finally, all four are supposed to "update remote
connections" in the calculation tab on the "Tools, Options..." menu.
The problem is that 3 of the four scoreboards are booting up successfully
(automatically launched without dialogue boxes on reboot). As a test, I
copied one of the files from one of the working PCs and loaded it onto the
suspect PC - and the same dialog box (Remote data not available) continues to
appear. After acknowledging the error, everything updates and runs properly -
but I can account for why the box is appearing on only one of the 4 machines.
This leads me to consider that it is probably a setting within Excel on THAT
machine that is causing the issue - but I cannot find a setting that appears
inconsistent with the other 3 PCs. One other point to consider: The IT
person at the plant informed me that the suspect PC is running Service Pack 2
- while the others are not.
Please advise if you can explain why this is occuring or if you have a
suggestion for another Excel setting I could check on the suspect PC.
Thank you - and sorry for the lengthy explanation.
There are 4 different PCs running their own Excel-based presentation files.
My goal is to ensure that each one - when rebooted - will start up (without
any dialog boxes) autoupdate and begin running without any human intervention.
Concerning Excel Settings: All 4 Excel settings appear to be set up
consistently. The worksheets have external links to PLCs (all based on the
same source worksheet on each PC) and every individual link is set to update
automatically (under Edit, Links...) as well as autoupdating w/o message on
startup. Next, all four scoreboards have "Ask to Update Automatic Links"
DESELCTED in the edit tab on the "Tools, Options..." menu - meaning that they
should just start on reboot. Finally, all four are supposed to "update remote
connections" in the calculation tab on the "Tools, Options..." menu.
The problem is that 3 of the four scoreboards are booting up successfully
(automatically launched without dialogue boxes on reboot). As a test, I
copied one of the files from one of the working PCs and loaded it onto the
suspect PC - and the same dialog box (Remote data not available) continues to
appear. After acknowledging the error, everything updates and runs properly -
but I can account for why the box is appearing on only one of the 4 machines.
This leads me to consider that it is probably a setting within Excel on THAT
machine that is causing the issue - but I cannot find a setting that appears
inconsistent with the other 3 PCs. One other point to consider: The IT
person at the plant informed me that the suspect PC is running Service Pack 2
- while the others are not.
Please advise if you can explain why this is occuring or if you have a
suggestion for another Excel setting I could check on the suspect PC.
Thank you - and sorry for the lengthy explanation.