From: Eddie on
On Dec 9, 4:46 pm, mlhow...(a)avalon.net (Mary) wrote:
> Yes, I've seen the popup window lots of times, and it will direct you to a file with a log extension, usually in this directory:
>
> C:\Documents and Settings\user\Local Settings\Temporary Internet Files\Content.MSO
>
> where "user" is your windows logon.
>
> It will look like this:
>
> XML Spreadsheet Warning in Worksheet Setting
> REASON: String too long
> ACTION: Truncating string
> FILE:   P:\filename\filename.xml
> GROUP:  PageSetup
> TAG:    Header
> ATTRIB: Data
> VALUE:  very very long long header too long for Excel to handle
>
> So that's what you need to find.
>
> -Mary
>
> --- aditya.penme...(a)GMAIL.COM wrote:
>
> From: Eddie <aditya.penme...(a)GMAIL.COM>
> To: SA...(a)LISTSERV.UGA.EDU
> Subject:      Re: Excel Workbook Setting Error Message
> Date:         Wed, 9 Dec 2009 09:41:51 -0800
>
> On Dec 8, 5:26 pm, mlhow...(a)avalon.net (Mary) wrote:
>
>
>
>
>
> > Please find the file that Excel saves and post the error message (to the list, not me personally).  You should see things like "String too long" or "Bad Value in Table".
>
> > -Mary
>
> > --- aditya.penme...(a)gmail.com wrote:
>
> > From: aditya penmetsa <aditya.penme...(a)gmail.com>
> > To: mlhow...(a)avalon.net
> > Subject: Re: Excel Workbook Setting Error Message
> > Date: Tue, 8 Dec 2009 16:02:31 -0500
>
> > Mary,
> > It did give me the name as I mentioned in my appsrv_header filename option.
> > I have only one sheet and  it is 8 characters long.  I used   longer sheet
> > names in my other programs which work fine. The only difference is this
> > program is pulling more data than the others and printing into excel.
>
> > Is there anything else than could be missing?
>
> > Thanks for you time.
>
> > Regards,
> > Addy
>
> > On Tue, Dec 8, 2009 at 3:45 PM, Mary <mlhow...(a)avalon.net> wrote:
> > > Did it give you the name of a file where you can look for further
> > > explanation
> > > of the error message?  If so look there; the most common problem is that
> > > sheet names specified are too long for Excel, so you may want to look
> > > at the sheet names in your code specifically and shorten them if they
> > > are too long.
>
> > > -Mary
>
> > > --- aditya.penme...(a)GMAIL.COM wrote:
>
> > > From: Eddie <aditya.penme...(a)GMAIL.COM>
> > > To: SA...(a)LISTSERV.UGA.EDU
> > > Subject:      Excel Workbook Setting Error Message
> > > Date:         Tue, 8 Dec 2009 08:27:51 -0800
>
> > > Hi,
> > > I'm using excel tagsets to create an excel report using SAS/Intranet ..
> > > When I run the program on my local machine it worked fine but when I
> > > copy into onto the Server and do "_webout" the program ran
> > > successfully and I also got that popup window where I can save the
> > > excel file. Here once I hit save it took long time for downloading the
> > > file from the server and finally when the download completed I see the
> > > an error Message " Problem came up in the following areas during load:
> > > Work Book Setting "
>
> > > The file size was 6825 KB when I ran on my local machine.
>
> > > Can someone help me resolve this error.
>
> > > Regards,
> > > Addy
>
> > --
> > Regards,
> > Aditya Penmetsa
>
> Mary,
> I downloaded the file to my desktop and when I open the file I see a
> popup window saying "Problems came up in the following areas during
> load: Workbook Setting"
>
> I wish I can send you a screenshot of the message. This window looks
> the same as when excel has problem loading SAS Styles.
>
> Regards,
> Addy

Mary,
Finally I found the log file. Here is what it says.

XML PARSE ERROR: Missing end-tag
Error occurs at or below this element stack:
<HR>


Regards,
Addy

From: Mary on
Looks to me like the entire XML file was not downloaded correctly or somehow got corrupted upon the download; perhaps all you can try is to download it again or rerun the program again. You said that you were using SAS/Intranet; I'm not sure how that works in downloading files generated.

-Mary

--- aditya.penmetsa(a)GMAIL.COM wrote:

From: Eddie <aditya.penmetsa(a)GMAIL.COM>
To: SAS-L(a)LISTSERV.UGA.EDU
Subject: Re: Excel Workbook Setting Error Message
Date: Thu, 10 Dec 2009 12:03:55 -0800

On Dec 9, 4:46 pm, mlhow...(a)avalon.net (Mary) wrote:
> Yes, I've seen the popup window lots of times, and it will direct you to a file with a log extension, usually in this directory:
>
> C:\Documents and Settings\user\Local Settings\Temporary Internet Files\Content.MSO
>
> where "user" is your windows logon.
>
> It will look like this:
>
> XML Spreadsheet Warning in Worksheet Setting
> REASON: String too long
> ACTION: Truncating string
> FILE: P:\filename\filename.xml
> GROUP: PageSetup
> TAG: Header
> ATTRIB: Data
> VALUE: very very long long header too long for Excel to handle
>
> So that's what you need to find.
>
> -Mary
>
> --- aditya.penme...(a)GMAIL.COM wrote:
>
> From: Eddie <aditya.penme...(a)GMAIL.COM>
> To: SA...(a)LISTSERV.UGA.EDU
> Subject: Re: Excel Workbook Setting Error Message
> Date: Wed, 9 Dec 2009 09:41:51 -0800
>
> On Dec 8, 5:26 pm, mlhow...(a)avalon.net (Mary) wrote:
>
>
>
>
>
> > Please find the file that Excel saves and post the error message (to the list, not me personally). You should see things like "String too long" or "Bad Value in Table".
>
> > -Mary
>
> > --- aditya.penme...(a)gmail.com wrote:
>
> > From: aditya penmetsa <aditya.penme...(a)gmail.com>
> > To: mlhow...(a)avalon.net
> > Subject: Re: Excel Workbook Setting Error Message
> > Date: Tue, 8 Dec 2009 16:02:31 -0500
>
> > Mary,
> > It did give me the name as I mentioned in my appsrv_header filename option.
> > I have only one sheet and it is 8 characters long. I used longer sheet
> > names in my other programs which work fine. The only difference is this
> > program is pulling more data than the others and printing into excel.
>
> > Is there anything else than could be missing?
>
> > Thanks for you time.
>
> > Regards,
> > Addy
>
> > On Tue, Dec 8, 2009 at 3:45 PM, Mary <mlhow...(a)avalon.net> wrote:
> > > Did it give you the name of a file where you can look for further
> > > explanation
> > > of the error message? If so look there; the most common problem is that
> > > sheet names specified are too long for Excel, so you may want to look
> > > at the sheet names in your code specifically and shorten them if they
> > > are too long.
>
> > > -Mary
>
> > > --- aditya.penme...(a)GMAIL.COM wrote:
>
> > > From: Eddie <aditya.penme...(a)GMAIL.COM>
> > > To: SA...(a)LISTSERV.UGA.EDU
> > > Subject: Excel Workbook Setting Error Message
> > > Date: Tue, 8 Dec 2009 08:27:51 -0800
>
> > > Hi,
> > > I'm using excel tagsets to create an excel report using SAS/Intranet .
> > > When I run the program on my local machine it worked fine but when I
> > > copy into onto the Server and do "_webout" the program ran
> > > successfully and I also got that popup window where I can save the
> > > excel file. Here once I hit save it took long time for downloading the
> > > file from the server and finally when the download completed I see the
> > > an error Message " Problem came up in the following areas during load:
> > > Work Book Setting "
>
> > > The file size was 6825 KB when I ran on my local machine.
>
> > > Can someone help me resolve this error.
>
> > > Regards,
> > > Addy
>
> > --
> > Regards,
> > Aditya Penmetsa
>
> Mary,
> I downloaded the file to my desktop and when I open the file I see a
> popup window saying "Problems came up in the following areas during
> load: Workbook Setting"
>
> I wish I can send you a screenshot of the message. This window looks
> the same as when excel has problem loading SAS Styles.
>
> Regards,
> Addy

Mary,
Finally I found the log file. Here is what it says.

XML PARSE ERROR: Missing end-tag
Error occurs at or below this element stack:
<HR>


Regards,
Addy
From: Eddie on
On Dec 11, 9:06 am, mlhow...(a)avalon.net (Mary) wrote:
> Looks to me like the entire XML file was not downloaded correctly or somehow got corrupted upon the download; perhaps all you can try is to download it again or rerun the program again.  You said that you were using SAS/Intranet; I'm not sure how that works in downloading files generated.
>
> -Mary
>
> --- aditya.penme...(a)GMAIL.COM wrote:
>
> From: Eddie <aditya.penme...(a)GMAIL.COM>
> To: SA...(a)LISTSERV.UGA.EDU
> Subject:      Re:ExcelWorkbookSettingErrorMessage
> Date:         Thu, 10 Dec 2009 12:03:55 -0800
>
> On Dec 9, 4:46 pm, mlhow...(a)avalon.net (Mary) wrote:
>
>
>
>
>
> > Yes, I've seen the popup window lots of times, and it will direct you to a file with a log extension, usually in this directory:
>
> > C:\Documents and Settings\user\Local Settings\Temporary Internet Files\Content.MSO
>
> > where "user" is your windows logon.
>
> > It will look like this:
>
> > XML Spreadsheet Warning in WorksheetSetting
> > REASON: String too long
> > ACTION: Truncating string
> > FILE:   P:\filename\filename.xml
> > GROUP:  PageSetup
> > TAG:    Header
> > ATTRIB: Data
> > VALUE:  very very long long header too long forExcelto handle
>
> > So that's what you need to find.
>
> > -Mary
>
> > --- aditya.penme...(a)GMAIL.COM wrote:
>
> > From: Eddie <aditya.penme...(a)GMAIL.COM>
> > To: SA...(a)LISTSERV.UGA.EDU
> > Subject:      Re:ExcelWorkbookSettingErrorMessage
> > Date:         Wed, 9 Dec 2009 09:41:51 -0800
>
> > On Dec 8, 5:26 pm, mlhow...(a)avalon.net (Mary) wrote:
>
> > > Please find the file thatExcelsaves and post theerrormessage(to the list, not me personally).  You should see things like "String too long" or "Bad Value in Table".
>
> > > -Mary
>
> > > --- aditya.penme...(a)gmail.com wrote:
>
> > > From: aditya penmetsa <aditya.penme...(a)gmail.com>
> > > To: mlhow...(a)avalon.net
> > > Subject: Re:ExcelWorkbookSettingErrorMessage
> > > Date: Tue, 8 Dec 2009 16:02:31 -0500
>
> > > Mary,
> > > It did give me the name as I mentioned in my appsrv_header filename option.
> > > I have only one sheet and  it is 8 characters long.  I used   longer sheet
> > > names in my other programs which work fine. The only difference is this
> > > program is pulling more data than the others and printing intoexcel.
>
> > > Is there anything else than could be missing?
>
> > > Thanks for you time.
>
> > > Regards,
> > > Addy
>
> > > On Tue, Dec 8, 2009 at 3:45 PM, Mary <mlhow...(a)avalon.net> wrote:
> > > > Did it give you the name of a file where you can look for further
> > > > explanation
> > > > of theerrormessage?  If so look there; the most common problem is that
> > > > sheet names specified are too long forExcel, so you may want to look
> > > > at the sheet names in your code specifically and shorten them if they
> > > > are too long.
>
> > > > -Mary
>
> > > > --- aditya.penme...(a)GMAIL.COM wrote:
>
> > > > From: Eddie <aditya.penme...(a)GMAIL.COM>
> > > > To: SA...(a)LISTSERV.UGA.EDU
> > > > Subject:      ExcelWorkbookSettingErrorMessage
> > > > Date:         Tue, 8 Dec 2009 08:27:51 -0800
>
> > > > Hi,
> > > > I'm usingexceltagsets to create anexcelreport using SAS/Intranet .
> > > > When I run the program on my local machine it worked fine but when I
> > > > copy into onto the Server and do "_webout" the program ran
> > > > successfully and I also got that popup window where I can save the
> > > >excelfile. Here once I hit save it took long time for downloading the
> > > > file from the server and finally when the download completed I see the
> > > > anerrorMessage" Problem came up in the following areas during load:
> > > > Work BookSetting"
>
> > > > The file size was 6825 KB when I ran on my local machine.
>
> > > > Can someone help me resolve thiserror.
>
> > > > Regards,
> > > > Addy
>
> > > --
> > > Regards,
> > > Aditya Penmetsa
>
> > Mary,
> > I downloaded the file to my desktop and when I open the file I see a
> > popup window saying "Problems came up in the following areas during
> > load:WorkbookSetting"
>
> > I wish I can send you a screenshot of themessage. This window looks
> > the same as whenexcelhas problem loading SAS Styles.
>
> > Regards,
> > Addy
>
> Mary,
> Finally I found the log file. Here is what it says.
>
> XML PARSEERROR:  Missing end-tag
>  Erroroccurs at or below this element stack:
>     <HR>
>
> Regards,
> Addy

Mary,
I don't see any errors while download. Here is the ODS part of my
code. I'm just posting to give you an Idea what I'm doing and may be
if this could help you find the bug.

libname TP "C:\Addy";run;
%include 'C:\Addy\exceltag195.sas';

proc template;
define style TP.XLSasweb;
parent = styles.sasweb;
end;
run; quit;

%let RV=%sysfunc(appsrv_header(Content-type,application/vnd.ms-
excel));
%let RV=%sysfunc(appsrv_header(Content-disposition,attachment;
filename=
"CT_Report.xls"));

options center;
ods listing close;
ods tagsets.excelxp file=_webout style=TP.XLSasweb;
ods tagsets.ExcelXP options(embedded_titles='yes'
embedded_footnotes='yes' sheet_interval='none' sheet_name='All Data');
TITLE "Connective Tissue Study: Data Report";
*footnote "TP Study";
proc print data=CT_Transpose noobs label ; run;
quit;
ods tagsets.excelxp close;
ods listing;

Thanks,

Regards,
Addy
From: Mary on
I don't know SAS/Intranet; so can't comment on how you are doing it; if it is possible to run the job entirely on the server or on the PC and just use regular file names then you should do so.

-Mary

--- aditya.penmetsa(a)GMAIL.COM wrote:

From: Eddie <aditya.penmetsa(a)GMAIL.COM>
To: SAS-L(a)LISTSERV.UGA.EDU
Subject: Re: Excel Workbook Setting Error Message
Date: Fri, 11 Dec 2009 07:23:53 -0800

On Dec 11, 9:06 am, mlhow...(a)avalon.net (Mary) wrote:
> Looks to me like the entire XML file was not downloaded correctly or somehow got corrupted upon the download; perhaps all you can try is to download it again or rerun the program again. You said that you were using SAS/Intranet; I'm not sure how that works in downloading files generated.
>
> -Mary
>
> --- aditya.penme...(a)GMAIL.COM wrote:
>
> From: Eddie <aditya.penme...(a)GMAIL.COM>
> To: SA...(a)LISTSERV.UGA.EDU
> Subject: Re:ExcelWorkbookSettingErrorMessage
> Date: Thu, 10 Dec 2009 12:03:55 -0800
>
> On Dec 9, 4:46 pm, mlhow...(a)avalon.net (Mary) wrote:
>
>
>
>
>
> > Yes, I've seen the popup window lots of times, and it will direct you to a file with a log extension, usually in this directory:
>
> > C:\Documents and Settings\user\Local Settings\Temporary Internet Files\Content.MSO
>
> > where "user" is your windows logon.
>
> > It will look like this:
>
> > XML Spreadsheet Warning in WorksheetSetting
> > REASON: String too long
> > ACTION: Truncating string
> > FILE: P:\filename\filename.xml
> > GROUP: PageSetup
> > TAG: Header
> > ATTRIB: Data
> > VALUE: very very long long header too long forExcelto handle
>
> > So that's what you need to find.
>
> > -Mary
>
> > --- aditya.penme...(a)GMAIL.COM wrote:
>
> > From: Eddie <aditya.penme...(a)GMAIL.COM>
> > To: SA...(a)LISTSERV.UGA.EDU
> > Subject: Re:ExcelWorkbookSettingErrorMessage
> > Date: Wed, 9 Dec 2009 09:41:51 -0800
>
> > On Dec 8, 5:26 pm, mlhow...(a)avalon.net (Mary) wrote:
>
> > > Please find the file thatExcelsaves and post theerrormessage(to the list, not me personally). You should see things like "String too long" or "Bad Value in Table".
>
> > > -Mary
>
> > > --- aditya.penme...(a)gmail.com wrote:
>
> > > From: aditya penmetsa <aditya.penme...(a)gmail.com>
> > > To: mlhow...(a)avalon.net
> > > Subject: Re:ExcelWorkbookSettingErrorMessage
> > > Date: Tue, 8 Dec 2009 16:02:31 -0500
>
> > > Mary,
> > > It did give me the name as I mentioned in my appsrv_header filename option.
> > > I have only one sheet and it is 8 characters long. I used longer sheet
> > > names in my other programs which work fine. The only difference is this
> > > program is pulling more data than the others and printing intoexcel.
>
> > > Is there anything else than could be missing?
>
> > > Thanks for you time.
>
> > > Regards,
> > > Addy
>
> > > On Tue, Dec 8, 2009 at 3:45 PM, Mary <mlhow...(a)avalon.net> wrote:
> > > > Did it give you the name of a file where you can look for further
> > > > explanation
> > > > of theerrormessage? If so look there; the most common problem is that
> > > > sheet names specified are too long forExcel, so you may want to look
> > > > at the sheet names in your code specifically and shorten them if they
> > > > are too long.
>
> > > > -Mary
>
> > > > --- aditya.penme...(a)GMAIL.COM wrote:
>
> > > > From: Eddie <aditya.penme...(a)GMAIL.COM>
> > > > To: SA...(a)LISTSERV.UGA.EDU
> > > > Subject: ExcelWorkbookSettingErrorMessage
> > > > Date: Tue, 8 Dec 2009 08:27:51 -0800
>
> > > > Hi,
> > > > I'm usingexceltagsets to create anexcelreport using SAS/Intranet .
> > > > When I run the program on my local machine it worked fine but when I
> > > > copy into onto the Server and do "_webout" the program ran
> > > > successfully and I also got that popup window where I can save the
> > > >excelfile. Here once I hit save it took long time for downloading the
> > > > file from the server and finally when the download completed I see the
> > > > anerrorMessage" Problem came up in the following areas during load:
> > > > Work BookSetting"
>
> > > > The file size was 6825 KB when I ran on my local machine.
>
> > > > Can someone help me resolve thiserror.
>
> > > > Regards,
> > > > Addy
>
> > > --
> > > Regards,
> > > Aditya Penmetsa
>
> > Mary,
> > I downloaded the file to my desktop and when I open the file I see a
> > popup window saying "Problems came up in the following areas during
> > load:WorkbookSetting"
>
> > I wish I can send you a screenshot of themessage. This window looks
> > the same as whenexcelhas problem loading SAS Styles.
>
> > Regards,
> > Addy
>
> Mary,
> Finally I found the log file. Here is what it says.
>
> XML PARSEERROR: Missing end-tag
> Erroroccurs at or below this element stack:
> <HR>
>
> Regards,
> Addy

Mary,
I don't see any errors while download. Here is the ODS part of my
code. I'm just posting to give you an Idea what I'm doing and may be
if this could help you find the bug.

libname TP "C:\Addy";run;
%include 'C:\Addy\exceltag195.sas';

proc template;
define style TP.XLSasweb;
parent = styles.sasweb;
end;
run; quit;

%let RV=%sysfunc(appsrv_header(Content-type,application/vnd.ms-
excel));
%let RV=%sysfunc(appsrv_header(Content-disposition,attachment;
filename=
"CT_Report.xls"));

options center;
ods listing close;
ods tagsets.excelxp file=_webout style=TP.XLSasweb;
ods tagsets.ExcelXP options(embedded_titles='yes'
embedded_footnotes='yes' sheet_interval='none' sheet_name='All Data');
TITLE "Connective Tissue Study: Data Report";
*footnote "TP Study";
proc print data=CT_Transpose noobs label ; run;
quit;
ods tagsets.excelxp close;
ods listing;

Thanks,

Regards,
Addy
From: Savian on
On Dec 11, 8:23 am, Eddie <aditya.penme...(a)gmail.com> wrote:
> On Dec 11, 9:06 am, mlhow...(a)avalon.net (Mary) wrote:
>
>
>
>
>
> > Looks to me like the entire XML file was not downloaded correctly or somehow got corrupted upon the download; perhaps all you can try is to download it again or rerun the program again.  You said that you were using SAS/Intranet; I'm not sure how that works in downloading files generated.
>
> > -Mary
>
> > --- aditya.penme...(a)GMAIL.COM wrote:
>
> > From: Eddie <aditya.penme...(a)GMAIL.COM>
> > To: SA...(a)LISTSERV.UGA.EDU
> > Subject:      Re:ExcelWorkbookSettingErrorMessage
> > Date:         Thu, 10 Dec 2009 12:03:55 -0800
>
> > On Dec 9, 4:46 pm, mlhow...(a)avalon.net (Mary) wrote:
>
> > > Yes, I've seen the popup window lots of times, and it will direct you to a file with a log extension, usually in this directory:
>
> > > C:\Documents and Settings\user\Local Settings\Temporary Internet Files\Content.MSO
>
> > > where "user" is your windows logon.
>
> > > It will look like this:
>
> > > XML Spreadsheet Warning in WorksheetSetting
> > > REASON: String too long
> > > ACTION: Truncating string
> > > FILE:   P:\filename\filename.xml
> > > GROUP:  PageSetup
> > > TAG:    Header
> > > ATTRIB: Data
> > > VALUE:  very very long long header too long forExcelto handle
>
> > > So that's what you need to find.
>
> > > -Mary
>
> > > --- aditya.penme...(a)GMAIL.COM wrote:
>
> > > From: Eddie <aditya.penme...(a)GMAIL.COM>
> > > To: SA...(a)LISTSERV.UGA.EDU
> > > Subject:      Re:ExcelWorkbookSettingErrorMessage
> > > Date:         Wed, 9 Dec 2009 09:41:51 -0800
>
> > > On Dec 8, 5:26 pm, mlhow...(a)avalon.net (Mary) wrote:
>
> > > > Please find the file thatExcelsaves and post theerrormessage(to the list, not me personally).  You should see things like "String too long" or "Bad Value in Table".
>
> > > > -Mary
>
> > > > --- aditya.penme...(a)gmail.com wrote:
>
> > > > From: aditya penmetsa <aditya.penme...(a)gmail.com>
> > > > To: mlhow...(a)avalon.net
> > > > Subject: Re:ExcelWorkbookSettingErrorMessage
> > > > Date: Tue, 8 Dec 2009 16:02:31 -0500
>
> > > > Mary,
> > > > It did give me the name as I mentioned in my appsrv_header filename option.
> > > > I have only one sheet and  it is 8 characters long.  I used   longer sheet
> > > > names in my other programs which work fine. The only difference is this
> > > > program is pulling more data than the others and printing intoexcel..
>
> > > > Is there anything else than could be missing?
>
> > > > Thanks for you time.
>
> > > > Regards,
> > > > Addy
>
> > > > On Tue, Dec 8, 2009 at 3:45 PM, Mary <mlhow...(a)avalon.net> wrote:
> > > > > Did it give you the name of a file where you can look for further
> > > > > explanation
> > > > > of theerrormessage?  If so look there; the most common problem is that
> > > > > sheet names specified are too long forExcel, so you may want to look
> > > > > at the sheet names in your code specifically and shorten them if they
> > > > > are too long.
>
> > > > > -Mary
>
> > > > > --- aditya.penme...(a)GMAIL.COM wrote:
>
> > > > > From: Eddie <aditya.penme...(a)GMAIL.COM>
> > > > > To: SA...(a)LISTSERV.UGA.EDU
> > > > > Subject:      ExcelWorkbookSettingErrorMessage
> > > > > Date:         Tue, 8 Dec 2009 08:27:51 -0800
>
> > > > > Hi,
> > > > > I'm usingexceltagsets to create anexcelreport using SAS/Intranet ..
> > > > > When I run the program on my local machine it worked fine but when I
> > > > > copy into onto the Server and do "_webout" the program ran
> > > > > successfully and I also got that popup window where I can save the
> > > > >excelfile. Here once I hit save it took long time for downloading the
> > > > > file from the server and finally when the download completed I see the
> > > > > anerrorMessage" Problem came up in the following areas during load:
> > > > > Work BookSetting"
>
> > > > > The file size was 6825 KB when I ran on my local machine.
>
> > > > > Can someone help me resolve thiserror.
>
> > > > > Regards,
> > > > > Addy
>
> > > > --
> > > > Regards,
> > > > Aditya Penmetsa
>
> > > Mary,
> > > I downloaded the file to my desktop and when I open the file I see a
> > > popup window saying "Problems came up in the following areas during
> > > load:WorkbookSetting"
>
> > > I wish I can send you a screenshot of themessage. This window looks
> > > the same as whenexcelhas problem loading SAS Styles.
>
> > > Regards,
> > > Addy
>
> > Mary,
> > Finally I found the log file. Here is what it says.
>
> > XML PARSEERROR:  Missing end-tag
> >  Erroroccurs at or below this element stack:
> >     <HR>
>
> > Regards,
> > Addy
>
> Mary,
> I don't see any errors while download. Here is the ODS part of my
> code. I'm just posting to give you an Idea what I'm doing and may be
> if this could help you find the bug.
>
> libname TP "C:\Addy";run;
> %include 'C:\Addy\exceltag195.sas';
>
> proc template;
> define style TP.XLSasweb;
> parent = styles.sasweb;
> end;
> run; quit;
>
> %let RV=%sysfunc(appsrv_header(Content-type,application/vnd.ms-
> excel));
> %let RV=%sysfunc(appsrv_header(Content-disposition,attachment;
> filename=
> "CT_Report.xls"));
>
> options center;
> ods listing close;
> ods tagsets.excelxp file=_webout style=TP.XLSasweb;
> ods tagsets.ExcelXP options(embedded_titles='yes'
> embedded_footnotes='yes' sheet_interval='none' sheet_name='All Data');
> TITLE "Connective Tissue Study: Data Report";
> *footnote "TP Study";
> proc print data=CT_Transpose noobs label ; run;
> quit;
> ods tagsets.excelxp close;
> ods listing;
>
> Thanks,
>
> Regards,
> Addy- Hide quoted text -
>
> - Show quoted text -

My guess is that you timing out on the download and only getting a
portion of the file. Try to up your webserver timeout.

Alan