Hello. I'm not an Excel expert; I'm a systems administrator. I have to move a set of Excel directories which include several sheets with links. The files are unmodified, simply copied to the new server. On the old server the sheets with lots of links are set to prompt so the user can choose to update links or not. On the new server the files are opened using the same drive letter, but the prompt giving a choice to update links or not doesn't appear. The new server has been added into Trust Center so macros will run, but otherwise the macro settings on Excel are unchanged on the desktop.

Does anyone have any idea why the prompts would work when the file is run from the old server, but not when the same file is run from the new server using a copy of the same file set and the same drive letter?

Thanks for your assistance!