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.