469,631 Members | 1,298 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,631 developers. It's quick & easy.

ASP, Excel -Size and memory

Hi All,

I have an asp page that displays the results in Excel in the browser.
It has about 40 columns and sometimes records can grow upto 1100.

For small number of records I do not get any error messages or displays
the result in Excel format properly. But for the higher number of
records even if the program runs for all day it hangs up and shows
nothing.

In the asp program I have many if and then statement as well as big
loop.

My question is how can I solve this problem? Do I have to look into the
web server memory and other configuration settings? Or is there a
maximum size limit in Excel.

I do highly appreciate your help.

Thanks a ton in advance.
Best regards,
Mamun

Dec 12 '06 #1
1 1399

"mamun" <ma******@hotmail.comwrote in message
news:11*********************@j72g2000cwa.googlegro ups.com...
Hi All,

I have an asp page that displays the results in Excel in the browser.
It has about 40 columns and sometimes records can grow upto 1100.

For small number of records I do not get any error messages or displays
the result in Excel format properly. But for the higher number of
records even if the program
What program?
>runs for all day it hangs up
Isn't that an oxymoron does it run or does it hang?
If it 'runs' how do you know it is 'running'?
Do you know whether the server is doing something?
If so is it gobbling up a lot of CPU?
and shows
nothing.
do you mean it never shows anything because it's hung or is still running
and hasn't returned anything?

>
In the asp program I have many if and then statement as well as big
loop.

My question is how can I solve this problem?
Do I have to look into the
web server memory and other configuration settings? Or is there a
maximum size limit in Excel.
What server are you using. There is a default buffer limit on IIIS6 of 4MB.
>
I do highly appreciate your help.

Thanks a ton in advance.
Best regards,
Mamun

Dec 13 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Mike | last post: by
reply views Thread by acharyaks | last post: by
6 posts views Thread by Matthew Wieder | last post: by
18 posts views Thread by lgbjr | last post: by
7 posts views Thread by Alain \Mbuna\ | last post: by
9 posts views Thread by Doug Glancy | last post: by
7 posts views Thread by =?Utf-8?B?VGVycnkgSG9sbGFuZA==?= | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.