I have a workbook that I created using Excel 2007. In Excel 2007 I can copy one of the worksheets to a different workbook with no problems. However, using Excel 2010 I'm getting odd behavior. I open the workbook, create a new blank workbook, then right-click the source tab in the original workbook and click copy to Book1 ("Book1" being the name of the newly created workbook). The sheet gets copied to Book1, but I'm losing two columns on the right side of the page. In other words, when I do a print preview, two columns get cut off that were within the printing limits of the original sheet. I've checked font size, font style, column widths, page size, margins, and page scaling. Everthing seems to be the same as the original sheet, but when I view the two sheets side by side (horizontally) it is obvious (by visual inspection using the ruler) that the columns of the new sheet are taking up more width than in the original, even though the columns are the same pixel width and the scale factor on both is 100%.
It's worth noting that when I have this problem, the numbers and letters that identify the rows and columns of the sheet (e.g. 1, 2, 3 and A, B, C) appear larger than in the original sheet. Not sure if this is related to my problem or just coincidence.
Note that in Excel 2007 I can copy the sheet to a new workbook and all is fine. Additionally, in Excel 2010 I can copy the worksheet using the "Copy to new workbook" option (i.e. creating the workbook and performing the copy in one step) and it works without this odd behavior. I only have the problem when using Excel 2010, and first creating a new workbook, then (in a separate step) performing the copy to new workbook.
Does anyone know what could be going on here?