VBA Excel - the picture is too large and will be truncated


I have some code in Access that copies a range of rows (normally about 1000) into another sheet. All these rows contain is text & numbers. Having run the code a few times it worked fine but not it pops up with the following error message "the picture is too large and will be truncated".

Can anyone tell me what this is about? The only thing I can think of is my clipboard is full but otherwise have no idea.

Any help would be great once again,

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Hi Mark

I think it would be beneficial if we could see this code that is doing the copying.

mcs26Author Commented:
Hi Richard

Please see the code below, I have to copy different sheets and ranges four times but they all have the same format as below. I have just inserted .CutCopyMode = False after copying and it seems to be running ok again now. However I would still like to know the actual cause.

.Sheets("AHYFND").Range("A5:I" & NRow).Copy            
.Sheets("Single_ISIN").Range("A" & LRow + 1).PasteSpecial xlPasteValues, xlPasteSpecialOperationNone, False, False

Well, there's nothing wrong with your code.  You say you are running this out of Access?  Maybe this is an Access-specific problem with using the Excel object library?  I'm afraid i doubt I can be of any further help so i will take a backseat and see what others post.

mcs26Author Commented:
Ok, thanks anyway Richard

I had a hunt around and found this post from someone (on another board) - I haven't tried it out, but it sounds plausible:

<<<<The reason for the error message, "The picture is too large and will be
truncated", is due to Microsoft's Clip Organizer. It tries to convert
anything that you copy into the clipboard into a picture format whether
you need it or not. I don't know how to avoid this, but if you're not
a fan of the Clip Organizer, you can remove it and then you won't get
the error messages anymore.

To remove the Clip Organizer, go to Control Panel - Add/Remove Programs
- Microsoft Office - Change - Add or Remove Features - Choose advanced
customization of applications - Next - Office Shared Features - Set
Clip Organizer to Not Available - Update.>>>>


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.