I am using Excel 2010. When I select and copy a single cell (or a group of cells) in one workbook and try to paste into another Workbook loaded in the same instance of Excel I get an Error 'That command cannot be used on multiple selections' - I cannot even paste into a bran new opened workbook.
However if I open another instance of Excel then the data pastes quite happily. Any ideas as to why this behaviour is happening?
However if I open another instance of Excel then the data pastes quite happily. Any ideas as to why this behaviour is happening?