Hi
Each time I copy and paste some formulas in Excel 2007, it takes few 5-10 seconds. It was OK in 2003. Why does it take so long time now, it is the same workbook as I used in excel 2003.
I need help cause it can save me a lot of time.
Are you copying the same number of rows & columns?
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel consulting, free examples and tutorials visit Excel Consulting-Excel VBA
Check out the free Excel Toolbar
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Code Tags: Make your code easier for us to read
Yes, if I only copy 1 cell and paste it to anoter cell, it takes few seconds.
This is a big workbook with some macros but as I said it was OK in 2003
I can't see why it should take longer in 2007 unless there are other factors. Maybe the workbook was corrupted when converting to 2007 format.
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel consulting, free examples and tutorials visit Excel Consulting-Excel VBA
Check out the free Excel Toolbar
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Code Tags: Make your code easier for us to read
OK, thanx
That is most likely the problem
Post back & confirm if you can
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel consulting, free examples and tutorials visit Excel Consulting-Excel VBA
Check out the free Excel Toolbar
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Code Tags: Make your code easier for us to read
I have the same problem - extremely slow copy operation, file is not corrupted, was created in 2007. At the same time, the same operation in newly created 2003 - no problem.
Excel 2003 copies 250,000 cells with formulas in 2-3 seconds, in 2007 - 2-3 minutes.
Files were identical, created specially for the comparison.
Both excels were with SP2 installed.
Last edited by v0vets; 07-03-2009 at 04:24 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks