Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

We have a 3rd party tool that creates an Excel file (xls, 97/2003 format) and formats some cells in different colours. When I copy a range of cells into a newly created file (xlsx, 2007/2010 format) the colours of those formatted cells change completely - light yellow becomes depp purple etc. The same happens when I move/copy a whole worksheet into a new workbook.

The company that created the 3rd party tool can not be reached any longer (probably out of business), so I am stuck with fixing this behavious in Excel.

Why is this happening, and what can I do to prevent or work around it?

share|improve this question
add comment

2 Answers

up vote 4 down vote accepted

Right click - Paste Special - All using source theme

This should keep the source theme intact. If that does not work, can you post an example of the source document?

share|improve this answer
    
That did the trick, thanks! –  Treb Feb 3 '12 at 8:44
    
any idea how to achieve this in VBA? –  Richard100 Jan 14 '13 at 18:05
add comment

I use Excel 2010 and I had the same issue when copy-paste a sheet of two different files.

I have found following solution:

  1. open the new file where you have pasted the copied cells
  2. right click on the Microsoft icon in the upper left corner
  3. click on the first line "customise rapid access..." (or maybe in the English version it is called "options")
  4. go to the "save" option title and click on it
  5. at the end of the window click on the bar "colors" (under the section sheet visual option)
  6. A new windows with the color palette
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.