10-14-2009 03:23 PM
Hi Everyone,
I cannot open an XML results file in Excel 2007 - even though I have added the style sheet directory to the trusted locations and removed all protections.
Here's what happens:
1. Open the XML results file at which point I am propmpted to select the TestStand stylesheet report.xsl
2. This then gives the error: Scripts in this XML document and/or references to other documents are disabled.
3. Clicking OK gives more specific information - namely Security settings do not allow the execution of script code within this stylesheet:
But I have done the following:
- The path to the style sheethas been added to 'Trusted Locations'
- ActiveX settings are completely enabled for all controls without restrictions
- Macro settings are enabled for all macros
- Trust access is granted to the VBA project object model
- All Data Connections are allowed
How can I enable the execution of the script code within the stylesheet so the XML file can load?
Thanks,
Ronnie
Solved! Go to Solution.
10-15-2009 03:12 PM - edited 10-15-2009 03:13 PM
Ronnie -
Straight from this Microsoft KnowledgeBase Article, please note that making the following modifications "may make your computer or network more vulnerable to attack by malicious software such as viruses." It's always a good idea to make a backup of your registry before modifying it. This can be done by going to File»Export.
In any case, as the article explains, open the registry and browse to HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Security. The Security folder should contain a Registry Key called XSLSecurityLevel. Mine did not have this registry key so I had to create it (see screenshot below). Double-click the XSLSecurityLevel registry key, enter 1 in the Value Data, then click OK.
You should now be able to view the XML Report from within Excel 2007. To reset this setting, simply double-click the XSLSecurityLevel registry key, enter 0 in the Value Data, then click OK.
Hope this helps!
10-15-2009 03:27 PM
Hi Manooch,
Thanks for the help - yes - that was it! I had looked into the XSLSecurityLevel key yesterday, and mine also did not have it in the registry but unlike you I wasn't sure what kind of key to create.
Excel responds with a warning message box, but it loads the file if Yes is selected.
Thanks again,
Ronnie