"AllowDocumentFunction constraint violated" Error when opening XML file using Custom defined XSL In Excel 2010

Question

I've a XML file with the associated XSLT sheet. When I try to open the XML file in Excel 2003 or Excel 2007, I was provided with an option to use my XSL and it opens perfectly. When I open the same file in Excel 2010 with same option, it shows XML error has occurred with following error message.

Anyway to fix this issue?

Answer 1

Hi,

Thank you for posting in Microsoft Community.

I shall help you related to your issue.

You may follow the steps mentioned in the article below and check if it helps:

http://support.microsoft.com/kb/908556

Note: although the link is for Excel 2007 it also holds good for Office 2010

Note: Replace Office 12 to Office 14 for Office 2010.

I hope this helps. If you need any further information, you can always reply and I’ll be happy to help you.

Thank you.

Answer 2

This is a security restriction in msWord also. related to a constraint to use document( ) XSLT function. I can't enable it, don't find how.

Answer 3

Hi Pradeep,

Thank you for posting in Microsoft Community.

Sorry to hear that you are unable to open XML file in Excel 2010.

Are you facing this issue with a specific Excel file?

Open Excel 2010 and then try to browse to the location of the file and open the same and check if it opens fine.

If the above steps fail and if you do not have any confidential data in the file then you may upload the sample data to the SkyDrive folder and provide us the link so that we can assist you better.

Refer the link below to upload the sample data to the sky drive:

http://social.technet.microsoft.com/Forums/en-US/w7itproui/thread/4fc10639-02db-4665-993a-08d865088d65

Note: Do not share the document which has confidential information.

Thank you.