Are you opening the xl2007 file or are you using a formula with a link to the
xl2007 file?

I've never used the compatibility pack, but it wouldn't surprise me if the
compatibility pack works when you open the file--not when you link to a file
saved in an xl2007 fileformat.



Cresta wrote:

Adding the compatability pack made no difference.

I am getting a #REF! when looking at the 2007.xlsb, but it works OK looking
at then 2003.xls

Both files are identical to the user.

"Cresta" wrote:

It is saved as a 2007.xlsb to keep the filesize down and the speed up.



"Cresta" wrote:

Hello

I am using Excel 2003 and would like to copy a sheet from a closed 2007 file
to a new (closed) 2003 file.
I can do it if its all 2003, but not both versions. Does anyone know if it
is possible.

Thanks

--

Dave Peterson