topic Re: Error Opening XML Document in Excel 2007 in ODS and Base Reporting

Error Opening XML Document in Excel 2007

A_L_COOK — Wed, 22 Jan 2014 09:13:36 GMT

Hi forum,

Any ideas?

I'm trying to open an xml document created by my SAS program with excel and it has different sheets.

However, when attempting to open it, I get an error:

Problems during load

Problems came up in the following areas during load:

Table

This file cannot be opened because of errors. Errors are located in: C:\Documents and settings\username\Local Settings\Temporary Internet Files\Content.MSO\xxxxxxxx.log.

I know there is data present as the work SAS data sets show this, but I cannot open the destination xml.

I'm on Excel 2007 and SAS 9.1.3.

THANKS

Andrea.

Re: Error Opening XML Document in Excel 2007

A_L_COOK — Wed, 22 Jan 2014 10:14:44 GMT

Cause: string was being handled as an integer in XML.

Manually converted and works.

Re: Error Opening XML Document in Excel 2007

Peter_C — Wed, 22 Jan 2014 14:39:31 GMT

glad you have your solution.

When I got those messages often it was because my style definitions were wrong.

Annoyingly, navigating to the CONTENT.MSO folder was difficult because of "hidden" folders. Pasting the path to the log file shown in the error message revealed just how many of these errors I make

peterC

Re: Error Opening XML Document in Excel 2007

ew — Thu, 16 Jul 2015 01:09:46 GMT

Hi! can you explain it a little more? thanks for your help!