Can't Copy Between Two Different Excel Instances

Posted on 2009-12-18
Last Modified: 2012-05-08
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

Question by:Scotteh
    LVL 5

    Accepted Solution

    This seems very unusual to me....I hope the format of the cells that you are copying are same. I mean to say that the cells are not merged of anything...?

    LVL 6

    Assisted Solution

    This might help. An article by microsoft about this error.
    LVL 6

    Expert Comment

    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.
    LVL 5

    Assisted Solution

    Make sure the compatibility pack hasn't been installed.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now