Limitation in the number of SeriesCollections

J

Jeff Moore

Is there a limitation in the number of Series collections? I could not find
anything in the Blackbook on this. Seems to be limited around 400.

Thanks
Jeff
 
A

Alvin Bruney - ASP.NET MVP

The limit from OWC should be based only on memory consumption. However,
Excel itself does impose a hard limit which is different for, say, VSTO
which is around 400 (off the top of my head). I'm pretty sure this limit is
different with the raw COM approach as well. Your safest bet is to test this
on a variety of environments with varying resource utilization. I wouldn't
fall for the 400 figure.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top