Several versions ago, Excel had some issues when I tried to put 35-40 graphs
in a workbook. If I turned off the autosize text on all graph text objects I
could get a few more than if I left autotext on. I used to run into
out-of-memory errors, even on fast machines with more RAM and HD space than
Excel could possibly have needed.
I'm not sure where to look to see whether this has been "fixed" or at least
improved, and how much improvement might be available in each version of
Excel. I'm about to start a new project that may end up with 100's of
graphs, and it would be a lot easier to develop with excel's limitations in
mind, vs. trying to do it all in one workbook then having to go back and do
rework until I hit the right limit.
Can anyone tell me, or provide a link to, the graph limitations for each
version of Excel?
Thanks!
Keith
Bookmarks