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

It would depend on if how that 2007 file was saved--was it saved as a normal
xl2007 file or a xl97-xl2003 file?

Do you have the compatibility pack installed so you can open xl2007 files in
xl2003?
http://www.microsoft.com/downloads/d...displaylang=en

(remember that xl2003 only has 64k rows and 256 columns!)

But in either case, I think you're going to have to open the xl2007 file and
save the new xl2003 file.

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

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

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

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

My boss has asked if this 'plan' is going to work, I think I can safely say
no, and that we need to look at a more simpler route by doing it from the
2007 end and saveas 2003.

Thanks for your help.

"Dave Peterson" wrote:

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

I'm not sure what the plan is--you didn't answer my questions.

But if you and your boss are satisfied, good luck.

Cresta wrote:

My boss has asked if this 'plan' is going to work, I think I can safely say
no, and that we need to look at a more simpler route by doing it from the
2007 end and saveas 2003.

Thanks for your help.

"Dave Peterson" wrote:

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


--

Dave Peterson