Search : in
By :

Copying cell content from one spreadsheet to

Last answer on Oct 17, 2009 8:28:15 am BST mschirmer, on Oct 13, 2009 2:45:04 pm BST 
 Report this message to moderators

Hello,
Sometimes when I select a range of cells to copy to another spreadsheet, the result on the new spreadsheet is blank. And then if I save that new spreadsheet, it won't open later because the datat is 'corrupt'.

My current workaround is to save the original spreadsheet to a CSV file, close then re-open and select the cells again and then copy to new spreadsheet. Apparently saving to a CSV strips not only all the formatting but also the 'corrupt' crap. Losing all the formatting is a pain, but is still quicker than re-typing all the info. this happens even when copying from an xlsx to another xlsx.

HELP! Thanks.

Configuration: Windows XP Pro Internet Explorer 8.0

1

 Excelguru, on Oct 17, 2009 8:28:15 am BST

Seems the installation is corrupted
Instal service packs if available
Otherwise try reinstalling / repairing office A wise man once said, 'I complained that I had no shoes unti­l I met a man who had no feet.'
I am interested in financial Modelling and custom excel deve­lopment with excel macros.

Reply to Excelguru