Unable to update external links from intranet hosted excel spreadsheet.
Old Systemwhen opening an excel 2003 spreadsheet that dynamically updated from other sources on our old on our old metaframe XP 3.0, windows 2000, ie6 system the excel spreadsheet would launch and update the sources fine (when launched from the intranet zone)
Opening the Web Toolbar in excel after launch would show the file launched (as readonly) from http://WEBLINK/FILE.XLS
New System
when opening the same file on the new XenApp 5.0 system, Windows 2008 and Internet explorer 8 – the file would launch – but would fail to update the links appropriately.
Opening the Web Toolbar in excel 2003 after launch would show the file cached and loaded from
c:users%username%appdatalocalmicrosoftwindowstemporary internet files…etc.
Resolution:
Group Policy:
Manual:
user Settings >administrative tempaltes>windows components>internet explorer>internet control panel>security page>intranet zone>Turn on Protected mode (disable) Ensure the site is running under the security of Intranet Zone – and disable IE protected mode for intranet zones either manually for the user or via group policy
