Maximum no of cahrt sheets?
 

Hi guys
i have to create about 50 chart sheets in a single qorksheet but excel 2003
is not letting me do that due to memory issues. I have read somewhere that
excel cannot accomodate more than 1 GB of data in a single worksheet.Is that
true?
If yes, is there a workaround for that??

One more thing.. Can I use Business intelligence of SQL 2005 as an
alternative to excel for charts??


Thanks
Mita

Maximum no of cahrt sheets?
 

Hi,

Have a read of Jon's page on possible fixes.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"mita" wrote in message
...
Hi guys
i have to create about 50 chart sheets in a single qorksheet but excel
2003
is not letting me do that due to memory issues. I have read somewhere that
excel cannot accomodate more than 1 GB of data in a single worksheet.Is
that
true?
If yes, is there a workaround for that??

One more thing.. Can I use Business intelligence of SQL 2005 as an
alternative to excel for charts??


Thanks
Mita

Maximum no of cahrt sheets?
 

Sorry fat fingers!

Here is the link
http://peltiertech.com/Excel/Charts/FixFonts.html

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Andy Pope" wrote in message
...
Hi,

Have a read of Jon's page on possible fixes.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"mita" wrote in message
...
Hi guys
i have to create about 50 chart sheets in a single qorksheet but excel
2003
is not letting me do that due to memory issues. I have read somewhere
that
excel cannot accomodate more than 1 GB of data in a single worksheet.Is
that
true?
If yes, is there a workaround for that??

One more thing.. Can I use Business intelligence of SQL 2005 as an
alternative to excel for charts??


Thanks
Mita