Welcome to the Excel Forum

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Excel Help Forum » Microsoft Office Application Help - Excel Help forum » Excel 2007 Help » Excel 2007 copy - paste - very slow

Please Register to Remove these Ads

Please Register to Remove these Ads



Reply
  #1  
Old 09-22-2008, 07:17 AM
Doolafs Doolafs is offline
Registered User
  
Join Date: 25 Aug 2008
Location: Iceland
Posts: 7
Doolafs is becoming part of the community
Excel 2007 copy - paste - very slow

Please Register to Remove these Ads

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.
Reply With Quote
  #2  
Old 09-22-2008, 07:18 AM
royUK's Avatar
royUK royUK is offline
Forums Administrator
  
Join Date: 18 Nov 2003
Location: Derbyshire,UK
MS Office Version:Xp; 2007
Posts: 13,761
royUK Has a higher level of understanding royUK Has a higher level of understanding royUK Has a higher level of understanding royUK Has a higher level of understanding royUK Has a higher level of understanding royUK Has a higher level of understanding royUK Has a higher level of understanding
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 Scales icon to rate it

For Excel consulting, free examples and tutorials visit my site
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
Reply With Quote
  #3  
Old 09-22-2008, 07:23 AM
Doolafs Doolafs is offline
Registered User
  
Join Date: 25 Aug 2008
Location: Iceland
Posts: 7
Doolafs is becoming part of the community
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
Reply With Quote
  #4  
Old 09-22-2008, 07:39 AM
royUK's Avatar
royUK royUK is offline
Forums Administrator
  
Join Date: 18 Nov 2003
Location: Derbyshire,UK
MS Office Version:Xp; 2007
Posts: 13,761
royUK Has a higher level of understanding royUK Has a higher level of understanding royUK Has a higher level of understanding royUK Has a higher level of understanding royUK Has a higher level of understanding royUK Has a higher level of understanding royUK Has a higher level of understanding
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 Scales icon to rate it

For Excel consulting, free examples and tutorials visit my site
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
Reply With Quote
  #5  
Old 09-22-2008, 07:48 AM
Doolafs Doolafs is offline
Registered User
  
Join Date: 25 Aug 2008
Location: Iceland
Posts: 7
Doolafs is becoming part of the community
OK, thanx
That is most likely the problem
Reply With Quote
  #6  
Old 09-22-2008, 09:02 AM
royUK's Avatar
royUK royUK is offline
Forums Administrator
  
Join Date: 18 Nov 2003
Location: Derbyshire,UK
MS Office Version:Xp; 2007
Posts: 13,761
royUK Has a higher level of understanding royUK Has a higher level of understanding royUK Has a higher level of understanding royUK Has a higher level of understanding royUK Has a higher level of understanding royUK Has a higher level of understanding royUK Has a higher level of understanding
Post back & confirm if you can
__________________
Hope that helps.

RoyUK
--------
If you are pleased with a member's answer then use the Scales icon to rate it

For Excel consulting, free examples and tutorials visit my site
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
Reply With Quote
  #7  
Old 07-03-2009, 03:19 AM
v0vets v0vets is offline
Registered User
  
Join Date: 03 Jul 2009
Location: Moscow
MS Office Version:Excel 2003/2007
Posts: 1
v0vets is becoming part of the community
Re: Excel 2007 copy - paste - very slow
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 03:24 AM.
Reply With Quote


Reply

Bookmarks

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
DialogSheet in Excel 2007 hashem_te Excel 2007 Help 2 06-02-2008 04:56 AM
Excel 2007: slow while working cduploc Excel 2007 Help 2 05-13-2008 06:12 AM
Import one Excel file into another using Excel 2007 mcluever Excel General 0 09-21-2007 04:40 PM
New Workbooks - Excel 2007 Lotus123 Excel General 4 08-23-2007 05:03 PM
Copy & Paste Microsoft word to Microsoft Excel dbacks3449 Excel General 1 05-02-2007 06:49 PM

Contact Us - ExcelTip.com - Archive - Top