Can I have thousands of worksheets open at the same time?

E

ellios47

I have recently finished an excel program that downloads historical
stock data from the internet into separate worksheets for each
corresponding stock ticker. To these worksheets the program then
applies a formula to the data contained in every worksheet. My goal
here was to be able to apply this formula to over 8000 different stocks
simultaneously. This requires that there be over 8000 worksheets (each
containing historical stock data for ten years) be open at the same
time. It works great for around 1000 worksheets, however, this seems
to be the limit. Before tackling the construction of this program I had
no experience with excel, I have since learned a great deal but am still
a novice and I can go no further until I figure out how to do this.
Is this an excel limitation or the computer's? I have a feeling that
it is a limitation of the computer. My computer has a pentium4 3.06
processor and 1.5 GB RAM. Does anyone have any ideas as to how I can
approach this problem? Maybe faster processor? Perhaps re-structuring
the format to decrease the number of worksheets? I need help. Any
advice would be greatly appreciated.

Thanks in advance
Eli
 
B

Bernard Liengme

Computer speed is not the problem; memory is what is needed. But this
project does not seem to fit the Excel model, try Access
 
A

Alan

ellios47 said:
I have recently finished an excel program that downloads historical
stock data from the internet into separate worksheets for each
corresponding stock ticker. To these worksheets the program then
applies a formula to the data contained in every worksheet. My goal
here was to be able to apply this formula to over 8000 different
stocks simultaneously. This requires that there be over 8000
worksheets (each containing historical stock data for ten years) be
open at the same time. It works great for around 1000 worksheets,
however, this seems to be the limit. Before tackling the
construction of this program I had no experience with excel, I have
since learned a great deal but am still a novice and I can go no
further until I figure out how to do this.
Is this an excel limitation or the computer's? I have a feeling
that it is a limitation of the computer. My computer has a pentium4
3.06 processor and 1.5 GB RAM.
Does anyone have any ideas as to how I
can approach this problem? Maybe faster processor? Perhaps
re-structuring the format to decrease the number of worksheets? I
need help. Any advice would be greatly appreciated.

Thanks in advance
Eli
Click to expand...

Have you tried it on a much lower spec machine to see if you can
achieve fewer sheets without running into problems?

If so, then it is a machine issue which is what a quick search seems
to tell us:

http://www.google.co.nz/search?hl=en&q=excel+maximum+sheets+site:.microsoft.com&meta=


Alan.
 
Top