Solved

Excel taking time during copy paste from one cell to another

Posted on 2011-02-21
5
193 Views
Last Modified: 2012-05-11
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
Comment
Question by:technicalsys
5 Comments
 
LVL 8

Expert Comment

by:jimsweb
ID: 34948997
0
 
LVL 41

Expert Comment

by:dlmille
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...

Dave
0
 

Expert Comment

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

Accepted Solution

by:
technicalsys earned 0 total points
ID: 34985911
HI,

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

Thnaks
0
 

Author Closing Comment

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

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

760 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

19 Experts available now in Live!

Get 1:1 Help Now