Home » KBArticles » Unable to update external links from intranet hosted excel spreadsheet.

Unable to update external links from intranet hosted excel spreadsheet.


Old System
when 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

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.