eemoon
asked on
How to full copy entire table from one Excel file to another?
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
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
we solved it after reinstalling without cleaning cell style. and go to Format>Move or Copy Sheet also can copy entire table.
Thank you!
Thank you!
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.
I'm glad you've gotten around your immediate problem.
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.