slow down

**rgrstvr** · 11-15-2009, 10:30 AM

I am building an inventory list for an online store with Excel 2002. Everything was fine until I reached 10,000 rows and 50 columns.

I use formulas to convert wholesale price to retail price on about ten columns.

Overnight the process of adding more rows has slowed down considerably.

I had my computer checked out and they say it is working just fine.

Should I -

Purchase some books?

Sign up for a tutorial?

Purchase a program to speed things up?

Something else?

**martindwilson** · 11-15-2009, 10:36 AM

what formulas are you using?

**rgrstvr** · 11-15-2009, 11:48 AM

=product(ac5000,1,2)

**martindwilson** · 11-15-2009, 11:53 AM

cant see that being a problem. how big is the file?
have you cleared all excessive formats and reset excels last cell?
http://support.microsoft.com/kb/244435

**rgrstvr** · 11-15-2009, 12:26 PM

8,300 kb.

how do I clear all excessive formats and reset excels last cell?

**martindwilson** · 11-15-2009, 12:40 PM

see link above ,use the add-in its easier

**rgrstvr** · 11-15-2009, 03:08 PM

i did it several times.

but it still is as slow as before.

what else can i try?

**martindwilson** · 11-15-2009, 04:19 PM

so now yor used range is only that used by your formulas etc?
if you drag the scroll bar down does it stop at end or carry down many more rows? same with the horizontall scroll

**rgrstvr** · 11-16-2009, 10:56 AM

i think i figured it out.

i have been working two programs at a time on the same screen - excel and my browser so i can extract stuff from the internet and put it into our spreadsheet.

so i turned off the browser and just used excel.

no problem - it sped up just fine.

i guess i will have to use the browser on a separate computer.

thanks for your help, i really appreciate it.

**Paul** · 11-16-2009, 07:30 PM

Hi Rgrstvr,

Please take a moment to read the forum rules, and in the future create threads with titles that are descriptive of your problem. In this case, something along the lines of "Excel slows down after 10,000 rows of data" would be more appropriate for both someone browsing the site and someone searching the web for a similar issue.

Thank you.