The spreadsheet I have created for work currently consists of 9 worksheets and about 200 charts, with each chart having its
I use it to capture and calculate trend data that is then transferred automatically to the charts which,
in turn, are linked to a small handful of PowerPoint Presentations and Word files that I use to publish the results. This
happens monthly and quarterly, so automating the process has saved me far more headaches than the year it's taken me to
create and "perfect" the current system would suggest.
The structure and function of the spreadsheet is
- Eight of the worksheets are used to capture monthly data. Each month, my direct reports and others
send me the numbers and I simply plug them into the row for that month. These sheets also have a series of calculation tables
that the charts use.
- The ninth worksheet has a very small handful of cells that the spreadsheet uses as
variables for calculations. Chief among them is the "as of" month, which I use to generate the charts and trends
"as of" the desired month. Since the historic data in the other eight worksheets goes back from two to three years,
and the charts only trend back a year or two, this cell allows me to generate historic data at the flick of a switch. This
switch (selecting the month) drives the calculation tables mentioned above, which means the charts all update as soon as I
enter the new monthly data and enter the "as of" month. It's a beautiful thing, really.
The problem is,
the file is now 40MB in size, and takes upwards of 5 MINUTES to load!
So what is it? The charts? The
At one point I saved a version that had all the charts removed. No improvement.
the delay is far from crippling, it is a tad annoying. Was there a better way to have done what I did to avoid this, or is it
simply time for me to ask my boss for a new computer?
Speaking of computers, I am on a Dell Latitude D620 laptop
running an Intel Core 2 at 998 Mhz with 2 GB of RAM. Windows XP Pro Version 2000, SP2, and Excel 2003 SP3. My options for
playing with software are limited since this is a work PC. Unless I can get a hardware update, my options are limited to the