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
 
Top