I have experimented with a number of different combinations of file formats and it seems to be hit and miss. As a general rule, I never use the 2007 file format because of backwards incompatibility with those I share my files with. So I find it difficult to believe that it is "obviously" the source of the problem. Their has to be something else. rt "Jan Karel Pieterse" wrote: > Hi Graham, > > > The Move or Copy ... command use to work with previous versions but doesn't > > seem to work with Excel 2007. > > > > What should I do to copy a sheet with date and objects? > > Obviously, your source file is in 2007 format, but your target file is not. > > Save your source as legacy 97-2003 file, close the file and open the 97-2003 > file. Then copy the worksheet to the other workbook. > > Regards, > > Jan Karel Pieterse > Excel MVP > http://www.jkp-ads.com > Member of: > Professional Office Developer Association > www.proofficedev.com > >
