S
_Scott_
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
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