Question on how to troubleshoot large CPU usage

  • Thread starter Thread starter simonboland
  • Start date Start date
S

simonboland

Hi,

I have a problem where my spreadsheet is taking most of my CPU. I'm
interested in any tips or pointers on how to go about troubleshooting
this.

This is what I have:

1) 8 worksheets in total.

2) A couple of macros to import data from a MySQL database using an
ODBC connector.

3) 4 of my worksheets store my imported data. The number of rows is
variable but it's typically between 20 - 100 rows and about 5
columns. In some of these worksheets I have an extra 5 or so columns
to do various calculations mostly for comparing dates and converting
between Unix time and Excel date/time format. To help me with my
analysis I've used commands such as IF(ISBLANK(A2),"",
(A2-25569)*86400) to either calculate a time/date or display a blank
cell since the number of rows are variable.

4) In the other 4 worksheets I do my analysis of the imported data. I
also have some plots in one worksheet.

5) The total memory usage is about 50 MBytes according to Windows task
manager..

The main problem I have is that when I click on any of the 4
worksheets which contain my imported data, the CPU usage goes to
100%. I've tried to reduce the size of the data in these worksheets
but it still takes this amount.

Any suggestions would be appreciated.

Thanks.
 
For lots of information about Excel performance, visit Charles William's site:

www.decisionmodels.com

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
|
| I have a problem where my spreadsheet is taking most of my CPU. I'm
| interested in any tips or pointers on how to go about troubleshooting
| this.
|
| This is what I have:
|
| 1) 8 worksheets in total.
|
| 2) A couple of macros to import data from a MySQL database using an
| ODBC connector.
|
| 3) 4 of my worksheets store my imported data. The number of rows is
| variable but it's typically between 20 - 100 rows and about 5
| columns. In some of these worksheets I have an extra 5 or so columns
| to do various calculations mostly for comparing dates and converting
| between Unix time and Excel date/time format. To help me with my
| analysis I've used commands such as IF(ISBLANK(A2),"",
| (A2-25569)*86400) to either calculate a time/date or display a blank
| cell since the number of rows are variable.
|
| 4) In the other 4 worksheets I do my analysis of the imported data. I
| also have some plots in one worksheet.
|
| 5) The total memory usage is about 50 MBytes according to Windows task
| manager..
|
| The main problem I have is that when I click on any of the 4
| worksheets which contain my imported data, the CPU usage goes to
| 100%. I've tried to reduce the size of the data in these worksheets
| but it still takes this amount.
|
| Any suggestions would be appreciated.
|
| Thanks.
|
 
Back
Top