×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Excel pasting very slowly

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.

RE: Excel pasting very slowly

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)?

RE: Excel pasting very slowly

Quote:

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/
 

RE: Excel pasting very slowly

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

RE: Excel pasting very slowly

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.

RE: Excel pasting very slowly

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.

 

RE: Excel pasting very slowly

(OP)

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

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/
 

RE: Excel pasting very slowly

"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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources