tagset.ExcelXP - "Problems During Load" after upgrade

[DavidMalerich]

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

[deleted_user]

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

[DavidMalerich]

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.

[Manikanta]

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

[Vince_SAS]

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