Excel taking time during copy paste from one cell to another

Posted on 2011-02-21
Last Modified: 2012-05-11

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.

Question by:technicalsys

Expert Comment

ID: 34948997
LVL 41

Expert Comment

ID: 34948999
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...


Expert Comment

ID: 34949089
Problem can be solved after creating a new excel file and copy the old data will definately solve the problem

Accepted Solution

technicalsys earned 0 total points
ID: 34985911

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


Author Closing Comment

ID: 35015627
Its working now. will have to check after some days.

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
What is format f12.8 for a CSV file 6 40
ADD New Entries 7 16
Excel Save As Status Box will not go away 6 19
How to move the last 4 digits of a number to a new column 8 42
Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now