I have multiple worksheets in a workbook that I am trying to copy into a new workbook. Prior to updating to Excel 2013, I could select the sheets, and use the "Move or Copy" option to move them into a new workbook. When I did that, all my formatting stayed the same. Then, last month, my Microsoft Office was updated to 2013. Now, when I copy the worksheets over into a new book, all my fill colors change! So, I either have to go back and change all the colors to what they are supposed to be, or I have to copy and paste "keep source formatting" for every worksheet. What used to take seconds now takes a lot longer! Any idea on a fix? I've tried to research online but haven't figured out anything!
Thank you,
Will
Thank you,
Will
