Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 232
  • Last Modified:

Excel taking time during copy paste from one cell to another

Hi,

I am using office XP(2000 Version) on my system. I have an Excel file which is approx 7MB in size. The issue was when i manual copy and paste matters from different cell it is stuck for some time (apprx. 2 /3 Mins) and the working. I am using normal text in this file and there was no formula, macros etc are there.

Please suggest any solution.

Thanks
0
technicalsys
Asked:
technicalsys
1 Solution
 
dlmilleCommented:
The only think I can think of is perhaps turning Calculation to Manual during copy/paste operation, unless the calculation is required for successive copies...

Dave
0
 
Darshan15Commented:
Problem can be solved after creating a new excel file and copy the old data will definately solve the problem
0
 
technicalsysAuthor Commented:
HI,

I created a add-inns for Lookup Wizard and after that its working fine.

Thnaks
0
 
technicalsysAuthor Commented:
Its working now. will have to check after some days.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now