Excel Workbook Setting Error Message
in [SAS]
|
From: Eddie on 8 Dec 2009 11:27 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
From: Mary on 8 Dec 2009 15:45 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.penmetsa(a)GMAIL.COM wrote: From: Eddie <aditya.penmetsa(a)GMAIL.COM> To: SAS-L(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
From: Mary on 8 Dec 2009 17:26 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.penmetsa(a)gmail.com wrote: From: aditya penmetsa <aditya.penmetsa(a)gmail.com> To: mlhoward(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 <mlhoward(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.penmetsa(a)GMAIL.COM wrote: > > From: Eddie <aditya.penmetsa(a)GMAIL.COM> > To: SAS-L(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
From: Eddie on 9 Dec 2009 12:41 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
From: Mary on 9 Dec 2009 16:46 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.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: 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
|
Next
|
Last
Pages: 1 2 Prev: about full join problem Next: Character variables to order horizontal axis in GPLOT |