troubleshooting Question

Can't Copy Between Two Different Excel Instances

Avatar of Scotteh
Scotteh asked on
Microsoft Excel
4 Comments3 Solutions658 ViewsLast Modified:
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

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 3 Answers and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros