Link to home
Start Free TrialLog in
Avatar of KarlTheHopeless
KarlTheHopelessFlag for United Kingdom of Great Britain and Northern Ireland

asked on

EXCEL 2010 "The picture is too large and will be truncated"

Hello Everyone

I get the following message whenever I try to Copy a Row of data in Excel ...

"The picture is too large and will be truncated."

Well, there are no pictures, and the Row that I want to copy only contains 10 columns of numeric and string data.

Thank You

Karl
Avatar of radnbne
radnbne
Flag of Australia image

I have seen this before and the problem was actually interference by another bit of software.

Are you running any clipboard or memory enhancement tools?
SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of KarlTheHopeless

ASKER

Hmm. Yes.

I do use ClipDiary which I could not live without.

As for MS Clip Organiser, I don't use it; but I might!!

Surely, given that the problem only arises in Excel, and not in other applications, then the real problem resides with Excel.

i.e. yet another Microsoft bug.

Not necessarily a MS Bug, more something not working the way MS expects it too.

Try disabling your ClipDiary Tool first and see if the problem still exists.

Then you might be able to track down a solution
Nope, it looks like a bug! e.g. see here, ...

http://support.microsoft.com/kb/300523

... but I do not understand the fix.

It looks to me as if you are told to create a registry entry with one name and then, in the same breath, change the name of the very key that you were just told to create!


?
http://support.microsoft.com/kb/300523

What does:
    "Embedded Excel worksheets shrink when you edit them in PowerPoint"
...have to do with you error issue?
<The picture is too large and will be truncated>

Don't try a fix if it does not apply to your issue directly...

JeffCoachman
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Well, of course, I did take your advice and disable the ClipDiary program - but with no success.

And when I look at the processes running in the Task Manager I cannot see anything running that has anything to do with the clipboard.

But I seem to be able to run MS Excel 2003, Word 2003, Word 2010, FrontPage, Expression Web 2, VB6, VB Express 2010, CorelDraw, Corel Photopaint, the Snipping Tool. five different browsers and goodness knows what else without any clipboard problems.

So it seems to me that Excel 2010 has a problem.
Well, in the end it turned out that my Memory Optimiser had something to do with the problem.

When I disabled it, the Excel problem went away.

However, given that all my other programs seem unafffected by the optimiser, I still point the finger at MS.

Nevertheless, I thank you for leading me in the right direction.

Karl
@radnbne

I should have thought more carefully about your very first post above.

Believe it or not, when you mentioned 'memory enhancement tools', it never occurred to me that I had any.such tools running on my computer - and by the the time I had gotten round to removing my Memory Optimiser, I had forgotten that you had  mentioned such things.

Old age!
"Memory Optimizers" were most popular in the days before Windows.

I means they are useful, but with memory so cheap now and, Windows actually does a fairly good job of managing memory, ... they are not really needed as much anymore.

;-)

JeffCoachman