Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/Paste problem in Excel 2007
I've run into an Excel 2007 Copy & Paste problem that I thought I would
share with the group. If you open an Excel 2003 (or earlier) workbook in Excel 2007 and that workbook has data and formatting on one of its worksheets including having some of its column widths set, and you then select all of the cells on the worksheet and do a Copy and then switch to a brand new workbook and do a Paste, the data and most of the formatting comes across OK. However, the column widths may or may not be pasted depending on what kind of workbook you are pasting into. If you have told Excel that new workbooks are of type "Excel Workbook (*.xlsx)" then the Paste will NOT bring along column widths. If the new workbook is of type "Excel 97 - 2003 Workbook (*.xls)" then it WILL. The behavior seems to be that if both the source and target workbooks are "compatible mode" or if they are both native mode then Copy and Paste bring along column widths. However when performing a mixed mode Copy and Paste the column widths aren't copied. This sure seems like a bug to me. I just finished spending a couple of hours trying to convince MS support that this was a problem but I don't think I got anywhere. What do the experts in this group think? TIA, josh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Paste in Excel 2007 | Excel Worksheet Functions | |||
copy and paste problem Excel 2007 | Excel Discussion (Misc queries) | |||
Copy paste - excel 2007 conflic problem identified | Excel Discussion (Misc queries) | |||
Excel 2007/2003 compatibility problem - copy and paste | Excel Discussion (Misc queries) | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) |