Solved

How to full copy entire table from one Excel file to another?

Posted on 2016-10-17
6
28 Views
Last Modified: 2016-10-18
Hi I have two Excel files opened. I try to copy one table from first one Excel to second one. but when I do it, it always show some error message. Please see the picture in attachment. Any one can give some suggestion? Thank you
3.PNG
0
Comment
Question by:eemoon
  • 3
  • 2
6 Comments
 
LVL 27

Expert Comment

by:Glenn Ray
ID: 41847336
What version of Excel are you running (2010, 2013, 2016)?

What is the size (rows, columns) of the data you're copying?

How much RAM does your computer have (4GB, 8GB, more)?

Are you copying and pasting between two separate instances of Excel (applicable to 2010)?

Are you getting this error when attempting to copy and paste ANY range of data between ANY two workbooks - or just this specific range and workbook?

EDIT:
See my comment in your other question about too many different cell formats.  The solution there will resolve this also.
0
 

Author Comment

by:eemoon
ID: 41847590
Thank you so much for your fast reply. I am answering the questions as the below:

What version of Excel are you running (2010, 2013, 2016)? 2010

What is the size (rows, columns) of the data you're copying? my excel might be damaged. My question of the ticket might be another question. i will reinstall it. so do not think about the error message. but  i want to copy entire table in one instance of Excel to anther instance of Excel in the same PC. is it possible to do that?

How much RAM does your computer have (4GB, 8GB, more)? 4GB

Are you copying and pasting between two separate instances of Excel (applicable to 2010)? yes, i copy and paste between two separate instance of Excel in the same PC

Are you getting this error when attempting to copy and paste ANY range of data between ANY two workbooks - or just this specific range and workbook? i will uninstall and reinstall excel. after that, i think the error would not appear. but here i want to copy entire table in one instance of Excel to anther instance of Excel. is it possible to do that? Thank you
0
 
LVL 27

Accepted Solution

by:
Glenn Ray earned 500 total points
ID: 41847636
First, the issue is not with Excel 2010, but the actual workbook itself (source and/or destination files).  They have been corrupted by having too many other sheets moved/copied into them and have amassed several thousand styles to the point where they no longer function.  To see my point, click "Cell Styles" from the Home ribbon: you'll see hundreds there that you very likely do not use.

Uninstalling and reinstalling will have no effect. You need to clean these workbooks of the styles.  My recommendation in your other question is to use the XLStyles Tool  to fix them.

Second, even though it may be convenient to use separate instances of Excel, I do not recommend doing so with Excel 2010.  There are known issues, like loss of data.  Excel 2013 and 2016 resolve this by emulating separate instances.

Regards,
Glenn
0
 

Author Comment

by:eemoon
ID: 41847654
we solved it after reinstalling without cleaning cell style. and go to Format>Move or Copy Sheet also can copy entire table.
Thank you!
0
 
LVL 27

Expert Comment

by:Glenn Ray
ID: 41848424
That may work temporarily, but if you continue to move sheets in/out of that workbook, you'll see the error again.  I've experienced this numerous times and eventually you'll need to clean those workbooks.  You'll also have the benefit of a good size reduction and improved performance.

I'm glad you've gotten around your immediate problem.
0

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

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
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 in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

910 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