The SAS Output Delivery System and reporting techniques

Finding the problem in ExcelXP

Reply
Frequent Contributor
Posts: 102

Finding the problem in ExcelXP

I am creating a workbook with the ExcelXP tagset, version (SAS 9.1.3, v1.70, 06/05/07).

When I try to open it, I get the messages:

=====
Problem During Load

Problems came up in the following areas during load:

Strict Parse Error

This file cannot be opened because of errors. Errors are listed in C:\Documents and Settings\c449630\Local Settings\Temporary Internet Files\Content.MSO\8F5FDA51.log.
=====

That file contains the following text:

=====
XML PARSE ERROR: Malformed or illegal processing instruction
Error occurs at or below this element stack:
(Stack is empty--error occurs at or below top-level element.)
=====

I don't find that helpful. How do I determine what the problem is and where it occurs?
SAS Super FREQ
Posts: 8,868

Re: Finding the problem in ExcelXP

Posted in reply to JackHamilton
Hi, Jack:
I hate that error message in Excel. When I get it it's usually because I've tried to do something funky with the XML (like passing an XML string into Excel using PRETEXT or POSTTEXT -- really not happy with that one) or doing something with styles or formulas that Excel didn't like. I used to get it all the time when I had a title statement in the code -- before the tagset allowed embedded titles.

I don't have a good way to tell what exactly caused the error in a particular instance, but I do know that when I work with ExcelXP, I keep making numbered copies of my programs. When I get the error, I fall back to the last known program that Excel opened successfully and then ask myself what changed between the working program and the program that Excel gave the error with.

I tried looking down in that error file that Excel logs, but generally don't find it useful.

cynthia

ps...sometimes, the updated tagset for ExcelXP fixes things.
Ask a Question
Discussion stats
  • 1 reply
  • 439 views
  • 0 likes
  • 2 in conversation