Excel pasting very slowly

[bylar]

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.

 

[kacarrol]

Do you happen to have a copy of the sheet to look at? Do you happen to mean fill formula down (in place of copy/paste)?

 

[IDS]

I use Excel 2007, Is it the same in Excel 2010?

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/

 

[zappedagain]

IF the data getting pasted has links to another spreadsheet, AND that spreadsheet is not open, then I've seen it take a very long time because I believe Excel (2003) opens the file, updates a cell, and then closes the file. This process repeats for every cell!

Opening the referenced spreadsheet before doing the cut/paste works much faster.

Hope that helps,

John D

 

[sdz]

I have a simple excel spreadsheet, no macros, checked last cell on each page and that's OK, limited conditional formatting. It can take 2 minutes for a simple cut and paste.
I suspect the MS factor.

 

[zelgar]

I've have had excel get a corrupted cell in a spreadsheet that messed a lot of things up. The only way I was able to "fix" it was to copy all of the data from the worksheet onto a new worksheet and delete the source worksheet.

 

[bylar]

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

 

[IDS]

Pasting 6 columns x 360 rows should be instantaneous in Excel 2007. Have you tried this on a different machine?

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/

 

[ACtrafficengr]

"Have you tried this on a different machine?"

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