topic Re: tagset.ExcelXP - "Problems During Load" after upgrade in ODS and Base Reporting

tagset.ExcelXP - "Problems During Load" after upgrade

DavidMalerich — Wed, 30 Jan 2008 15:57:22 GMT

In November, I upgraded by version of the ExcelXP tagset from v1.37 to v1.71 (from the June '06 version to the June '07 version). After that upgrade, with no other changes to my ODS statements, I began getting a pop-up box from Excel that says "Problems During Load". The pop-up box indicates that problems came up when loading the XML file, and that warnings have been written to a log file that is unfortunately in a hidden directory and inaccessible to me.

Do I need to revert to tagset version v1.37, or do I need to make changes to my ODS statements?

I'm running SAS 9.1.3 for UNIX (SunOS) and Excel 2003 on Windows. I'm using an FTP service to transfer the XML file created by SAS from UNIX to Windows. Message was edited by: David Malerich

Re: tagset.ExcelXP - "Problems During Load" after upgrade

deleted_user — Wed, 30 Jan 2008 17:05:58 GMT

something like

%temp%\CONTENT.MSO\dfghjkl.log

or C:\temp\Internet\Content.MSO

It is worth typing the path declared, into the address bar of windows explorer.
Although CONTENT.MSO is hidden, it will still open when I provide its address.

You may find you need to provide style= on your ODS statement.

PeterC

Re: tagset.ExcelXP - "Problems During Load" after upgrade

DavidMalerich — Wed, 30 Jan 2008 17:41:42 GMT

Much obliged. I found the issue -- I had an extra "formula:" in a style statement that was prviously ignored with the old tagset, so I removed it. That resolved the warning message.

Re: tagset.ExcelXP - "Problems During Load" after upgrade

Manikanta — Tue, 23 Oct 2018 15:01:21 GMT

Hi David ,

I am also facing same issue while opening Excel file .

Can you please share the solution to resolve the issue ?

It will be helpful if you share the changes need to do on ODS tagets.excelxp.

Thanks in advance .

Kind Regards,

Manikanta. N

Re: tagset.ExcelXP - "Problems During Load" after upgrade

Vince_SAS — Sun, 11 Nov 2018 21:07:15 GMT

You should open a track with our Technical Support Department. They are best able to help you with this issue.

https://support.sas.com/ctx/supportform/createForm

Vince DelGobbo

SAS R&D