We have recently upgraded to 2007. We have a CSV file that we have to copy into a saved excel document. We used to right click on the CSV file's tab and say "copy" to "x" excel document and it would work fine. Now that we converted to 2007, we try this step and get an error message "Excel cannot insert the sheets into the destination workbook, because it contains fewer rows and columns than the source workbook. To move or copy the data to the destination workbook, you can select the data, and then use the Copy and Paste commands to insert it into the sheets of another workbook".

Why would office 2007 be any different in this process? It is just opens room for error for us to have to copy and paste into the document.

Help?