M
mbobro
Hi,
I do produce PP presentations out of Excel files. The Excel files are
standarized:has about 20 worksheets with around 50 charts on it and
data.
The data production is divided into 3 parts that must be done one by
one. That means that individual part 3 results may not be calculated
before part 2 is not totally completed for every report.
I have around 50 files reports like that.
What I do now is that I divide the production into separate parts. I do
open the file No 1 and calculate results part 1. Then I save updated
file No 1 and open file No 2 and so on.
Once completed part 1 I do the similar with parts 2 and 3.
The problem here is during the whole process I have to open and save
different Excel files several hundreds times that slows down the whole
calculation.
Is there any way I can do this faster? Maybe I may keep somehow the
data in the memory? I'm afraid to make one gigafile as it should have
something like 1000 of worksheets and several thousands of charts that
will not work efficiently.
Thanks in advance,
Michal
I do produce PP presentations out of Excel files. The Excel files are
standarized:has about 20 worksheets with around 50 charts on it and
data.
The data production is divided into 3 parts that must be done one by
one. That means that individual part 3 results may not be calculated
before part 2 is not totally completed for every report.
I have around 50 files reports like that.
What I do now is that I divide the production into separate parts. I do
open the file No 1 and calculate results part 1. Then I save updated
file No 1 and open file No 2 and so on.
Once completed part 1 I do the similar with parts 2 and 3.
The problem here is during the whole process I have to open and save
different Excel files several hundreds times that slows down the whole
calculation.
Is there any way I can do this faster? Maybe I may keep somehow the
data in the memory? I'm afraid to make one gigafile as it should have
something like 1000 of worksheets and several thousands of charts that
will not work efficiently.
Thanks in advance,
Michal