Question on how to troubleshoot large CPU usage

[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.

 

[Niek Otten]

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.
|