Excel pasting very slowly
Excel pasting very slowly
(OP)
I typically do amortization sheets.
App 12 columns and 365 rows.
When I copy and paste the second line to reiterate to the remaining lines Excel take a very long time to paste if indeed it doesn' crash.
Any suggestion?
I use Excel 2007, Is it the same in Excel 2010?
I use to use Qpro pasted almost instantly. Iliked it becuse it was easy to program and make sub menus but it isn't very well supported.
App 12 columns and 365 rows.
When I copy and paste the second line to reiterate to the remaining lines Excel take a very long time to paste if indeed it doesn' crash.
Any suggestion?
I use Excel 2007, Is it the same in Excel 2010?
I use to use Qpro pasted almost instantly. Iliked it becuse it was easy to program and make sub menus but it isn't very well supported.





RE: Excel pasting very slowly
RE: Excel pasting very slowly
That depends on the reason it is happening. It isn't normal behaviour.
It is possible that 2010 would work better, but without knowing what the problem is in 2010 it can't be guaranteed.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Excel pasting very slowly
Opening the referenced spreadsheet before doing the cut/paste works much faster.
Hope that helps,
John D
RE: Excel pasting very slowly
I suspect the MS factor.
RE: Excel pasting very slowly
RE: Excel pasting very slowly
This is a copy and past.
it siomply takes the interest rate times the previous principle balance and subtracts it from the latest payment and gets the principal amount and deducts it from the previous balance.
I copy the row which has 6 columns and paste it down the 360 row (30 years x12)
I have several of these workbooks and they all behave the same
I have cleared all the rows below my calcs and to the right of all the calcs and it behaves the same.
If I paste about 40 rows at a time it paste them almost instantaneously
I use to use qpro and it always pasted instantaneously
RE: Excel pasting very slowly
I believe that XL 2007 used to have issues with Google toolbar and/or Google local search (and some other programs), but these are fixed in the latest service pack.
I suggest:
-Make sure you have the latest service pack and updates.
-If you have any Google apps running locally try uninstalling them.
-If you still have problems try on another machine.
If you would like to post a copy I'd be happy to try it on XL 2010.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Excel pasting very slowly
Is this the only thing you've noticed that is slow? If not, it could be a virus, full or badly fragged hard drive, too many background apps running, etc.
"...students of traffic are beginning to realize the false economy of mechanically controlled traffic, and hand work by trained officers will again prevail." - Wm. Phelps Eno, ca. 1928