Scotteh
asked on
Can't Copy Between Two Different Excel Instances
Hi All,
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
Scott
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
Scott
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Not sure if this is true, but the error occurring only between instances might have to do with Excel having to pass the copied information to Windows, then back to Excel when copying between instances (like copying between different applications entirely). Whereas when they are in the same instance, it is using some internal clipboard that is able to store more formats.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.