Date:         Tue, 8 Dec 2009 14:26:40 -0800
Reply-To:     mlhoward@avalon.net
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mary <mlhoward@AVALON.NET>
Subject:      Re: Excel Workbook Setting Error Message
Comments: To: aditya penmetsa <aditya.penmetsa@gmail.com>
Content-Type: text/plain; charset="UTF-8"

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@gmail.com wrote:

From: aditya penmetsa <aditya.penmetsa@gmail.com>
To: mlhoward@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@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@GMAIL.COM wrote:
>
> From: Eddie <aditya.penmetsa@GMAIL.COM>
> To: SAS-L@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