Can't Copy Between Two Different Excel Instances
Posted on 2009-12-18
I hope you can help with this as it's an odd one. Everything was fine up until the beginning of the week but now there is an issue with Excel.
The user has two different instances of Excel 2007 open, each one containing a different spreadsheet. Now usually all they did was highlight the cell they wanted to copy, ctrl+c it and then click on the cell on the other spreadsheet and ctrl+v it. Now however when you click on the cell you want to paste it to it won't paste but if you then double click on the cell and try and paste in edit mode it comes up with the error "too many different cell formats".
It's puzzling me because the issue doesn't arise if you open both spreadsheets in only one instance of excel, only if it's between two instances. However if you copy from the cell in edit mode it will do it fine between the instances. It's only when you highlight the cell and copy it that the problem occurs.
I hope that's clear enough, if not please ask for more information and I will try and provide it.
As I said nothing has changed since Monday, but now it just won't work, it will if you go into edit mode before copying and if you open both spreadsheets in one instance. It won't work if you just highlight the cell and copy it.
Thanks in advance