technicalsys
asked on
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
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
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
Dave
Problem can be solved after creating a new excel file and copy the old data will definately solve the problem
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Its working now. will have to check after some days.
https://www.experts-exchange.com/questions/25851951/Excel-2007-VERY-slow-to-Format-Copy-Paste-data-entry.html
https://www.experts-exchange.com/questions/21747928/Excel-file-opening-very-slow-since-I-made-a-copy.html
https://www.experts-exchange.com/questions/22546192/Excel-copy-paste-in-macro-very-slow.html