I think I'm fairly good at troubleshooting errors, but I'm far beyond my capabilities here. Here's a problem im having in Excel 2010:
I have tables in 4 documents that I'd like to save in one document. Sounds simple enough right? There seems to be something wrong with these files, that it isn't working right for me. If I copy a table on one sheet only, and try to paste it in another workbook, I get the error "That command cannot be used on multiple selections" (I've looked - I have ONLY ONE tab highlighted, and all the cells are contiguous). Moreover, If I click the new tab button, I get the same error: "That command cannot be used on multiple selections. Which makes no sense to me.
Giving up on copy paste, I thought at least I can copy the whole sheets into a new workbook, so I right-click the tab, choose "Move or Copy", select a new workbook (or an existing workbook) and click the buttons for copy to end of book. Without fail, this crashes Excel and it sends out an error report.
I just need to copy some data! I'm getting frustrated with what should have been such an easy task. Any ideas for solutions!?
Giving up on copy paste, I thought at least I can copy the whole sheets into a new workbook, so I right-click the tab, choose "Move or Copy", select a new workbook (or an existing workbook) and click the buttons for copy to end of book. Without fail, this crashes Excel and it sends out an error report.
I just need to copy some data! I'm getting frustrated with what should have been such an easy task. Any ideas for solutions!?