T
thekovinc
I have a spreadsheet that is getting fairly large. It is a history of
sales for the last few months. It is about 100 columns wide, and I add
about 200 rows daily. I'm mainly doing vlookups and sorts with this
file, and I have never had any problems with sort times. Monday, I put
in about 500 of them to get caught up from the weekend, ad it now takes
about 3-4 times as long to sort even one column (much less three!).
I have no formulas in the file (I always copy/paste values when I'm
done with it to get rid of the vlookup formulas I pasted for the day),
and at any time, there is only one column with formulas in it (the
vlookup). The problem occurred when I was about at 6500 rows. I know
it should get slower as the file gets larger, but sort times went from
about 10-15 seconds to over a minute.
Are there any hardware or software limitations that might be causing
the problem? I'm running 3.0Ghz and 512 Ram. I am just a little
confused at how it became so slow after just adding a few hundred rows
(it's not like I doubled the size of the file).
Any thoughts would be greatly appreciated.
sales for the last few months. It is about 100 columns wide, and I add
about 200 rows daily. I'm mainly doing vlookups and sorts with this
file, and I have never had any problems with sort times. Monday, I put
in about 500 of them to get caught up from the weekend, ad it now takes
about 3-4 times as long to sort even one column (much less three!).
I have no formulas in the file (I always copy/paste values when I'm
done with it to get rid of the vlookup formulas I pasted for the day),
and at any time, there is only one column with formulas in it (the
vlookup). The problem occurred when I was about at 6500 rows. I know
it should get slower as the file gets larger, but sort times went from
about 10-15 seconds to over a minute.
Are there any hardware or software limitations that might be causing
the problem? I'm running 3.0Ghz and 512 Ram. I am just a little
confused at how it became so slow after just adding a few hundred rows
(it's not like I doubled the size of the file).
Any thoughts would be greatly appreciated.