Speed problems win Excel

Hi Guys,

I have been building up a rather large spreadsheet with 3 years worth of
sales data of products, im looking at market trends and things, info below

Total of 8 work sheets
2 with data
3 with calculations from the data mainly median pricing, quartile
pricing, sumproduct funtcions etc
3 with charts

I am running an AMD 3400+, 1gb RAM, XP Pro, Excel 2003

My Problem is the spreadsheet have become stupidly slow, the PC is sitting
on 100% CPU load calculating cells for 10-15minutes. If I copy & paste cells
Excel utilises 100% of the CPU on the processes tab of the task manager and
around 100mb of memory used. Page file is sitting at about 35% stable.

What I am trying to work out is what its the best way for my to optimise the
spreadsheet?

Am I totally going about it the wrong way, would it be better to break it up
into multiple spreadsheets or multiple workbooks

Do you require more information to offer suggestions?

regards
Scott

Hi Scott,

For good advice about performance, see Charles William's site:

www.decisionmodels.com

--
Kind regards,

Niek Otten

"_Scott_" <http://efi5l@NOSPAM.westnet.net.au> wrote in message
news:43c73252$0$1048$61c65585@un-2park-reader-01.sydney.pipenetworks.com.au...
> Hi Guys,
>
> I have been building up a rather large spreadsheet with 3 years worth of
> sales data of products, im looking at market trends and things, info below
>
> Total of 8 work sheets
> 2 with data
> 3 with calculations from the data mainly median pricing, quartile
> pricing, sumproduct funtcions etc
> 3 with charts
>
> I am running an AMD 3400+, 1gb RAM, XP Pro, Excel 2003
>
> My Problem is the spreadsheet have become stupidly slow, the PC is sitting
> on 100% CPU load calculating cells for 10-15minutes. If I copy & paste
> cells Excel utilises 100% of the CPU on the processes tab of the task
> manager and around 100mb of memory used. Page file is sitting at about
> 35% stable.
>
> What I am trying to work out is what its the best way for my to optimise
> the spreadsheet?
>
> Am I totally going about it the wrong way, would it be better to break it
> up into multiple spreadsheets or multiple workbooks
>
> Do you require more information to offer suggestions?
>
> regards
> Scott
>
>