Excel error I've never seen before

I have been emailled an Excel spreadsheet. I am trying to cut and paste a column, only 1755 lines deep, in Excel Version 9.0.0.3822 (which I assume is part of Office 2000).

I get the error message headed Microsoft Excel. There is a yellow triangle with a black exclamation mark. The warning is " The picture is too large and will be truncated".

I assume it is a normal Excel spreadsheet as it has the suffix of *.xls.

I can "OK" my way through the error and eventually cut and paste, but would like to know the cause of the error.

PC is a networked XP with SP2.

I thought it may be because I was working on the spreadsheet that was emailled to me, but when I save the emailled soreadsheet to my "C" drive, the same cut and paste error occurs.

Can anyone help?

Bazza

 

I think I've answered my own problem. Doing a google search, quoting the error message, has pointed me towards my deluxe clipboard program as the culprit. I've unloaded the clipboard program and the cut and paste now works normally in Excel. Not a M$ feature, after all.

Hope this may help someone else using a fancy clipboard program and having errors.

Bazza

 

Bazza,

Thanks for the info!

 

your truncate error is referring specifically to the less than zero number format of the column you were pasting them to.
there is a formula in the original spread sheet that produced those numbers the column setting on the spread sheet you pasted to was set at the default number setting and to truncate means the column was going to round any and all less than zero numbers.

just click format on your tool bar then cells and the number tab and format the column to the appropriate setting to recognize a less than zero number format.

You clip board was working as it should. Check the pasted numbers to the numbers you copied.

 

Thanks, jewlzs. I'll check it out more thoroughly. I was cutting and pasting to 1-3 blank columns to re-arrange the date, from left to right. The target columns would have all been blanks, as they were unused in the original spreadsheet. I don't think the original columns had any formulae in them, but will look a bit more carefully and get back to you when I can

Bazza

 

Just created the simplest spreadsheet with the numbers 1-9 in A1-A9, with my fancy clipboard program loaded and tried to cut and paste column A.

Error immediately came up.

Unloaded my clipboard program, went back to the same column (A), and cut and pasted without any error message.

Point proven for me.

Bazza