Cannot Copy Sheets

Question

In the past, I have been able to open several .xlsx files from explorer at once.  Each file has one sheet.  Excel opened all of them in one copy of Excel, and I was able to right click on the sheet name, and move each one into the same file.

Today, I tried to do the same, but Excel opened five copies of itself, one sheet in each one.  If I try to click on copy, the only options are to move to the same file, or to the end of this one.  This happens even on files where it worked in the past.

When I open each file, I get an error that they may be corrupt:  they aren't, but more importantly, I got this error in the past and it didn't stop it from working then.  

If I try to move 'to book', 'new book', it says 'there needs to be at least one visible sheet in the workbook'.  I didn't try doing this in the past because simply moving worked.  

Any suggestions?  I have ~700 files I need to combine into one, and I need to preserve the sheet name.  Having to make new sheets, renaming the sheet, then copy/pasting from another file would take a very long time, rather than the hour or so it would have previously taken.

Answer 1

Thank you for posting back. Let's check if the issue persists using a clean boot. This option will help us identify what conflict is causing this issue.

We'll keep an eye out for your response.