Unable to Copy a Sheet from One Workbook to Another

[Beachvoliball]

Excel 2010, Windows XP

I am having trouble copying a tab from one workbook to another. Both workbooks are .xlsx and I can copy the tab in question to other workbooks but not the workbook I want to copy it into. I have also tried changing the files to both be .xlsm with the same failure.

I get to all the way through the process of Move or Copy, select the Book I wish to copy it into and click on OK and nothing happens.

Any ideas what would be causing the issue?

Thanks,
Kathleen

 

[mole999]

maybe a hidden sheet with same name ?

 

[Beachvoliball]

There are no hidden sheets in either workbook.

 

[VoG]

Are both workbooks open in the same instance of Excel?

 

[Beachvoliball]

VoG, absolutely! I have done further investigation and found that when I attempt this on a different server, I actually get an error message pop up. The message indicates "Some custom formats will not fit on the destination sheet". I found that error in a Microsoft forum and am working on removing defined names as suggested in that post using Name Manager 2007.xlam.

 

[Beachvoliball]

After running Name Manager 2007.xlam, and RemoveStyles.xlam, the problem is resolved!

Microsoft Thread providing resolution - Cannot copy or move sheet to a specific workbook to a specific - Microsoft Community
Name Manager 2007.xlam - Name Manager
RemoveStyles.xlam - Remove Styles - Downloads