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

Sorry Dave.

We have a core set of xl2003 files which feed off a couple of hundred xl2007
files. Until we have migrated these core files across to xl2007 (big job), we
need a workaround to keep the workflow as foolproof as possible.

This is our workflow plan:
From an open xl2003 file, create a new xl2003 file. Copy a named sheet from
a closed xl2007 and pastespecial its values to a sheet of the same name in
the new xl2003. We would loop through the hundreds of xl2007 files quickly if
it could be done.
However we have dropped this plan, and the responsibility is going to be
with the xl2007 file owner to to the copy from their file saving as xl2003
version. Keeps it simple but open to problems like "I forgot". (I'll probably
end up coding a procedure to do it for them)

Fortunately this is only while we migrate the core files to xl2007 which
should only be a few months away.

Thanks again.



"Dave Peterson" wrote:

> 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
>

Good luck.

Training issues are always difficult to implement.

Cresta wrote:
>
> Sorry Dave.
>
> We have a core set of xl2003 files which feed off a couple of hundred xl2007
> files. Until we have migrated these core files across to xl2007 (big job), we
> need a workaround to keep the workflow as foolproof as possible.
>
> This is our workflow plan:
> From an open xl2003 file, create a new xl2003 file. Copy a named sheet from
> a closed xl2007 and pastespecial its values to a sheet of the same name in
> the new xl2003. We would loop through the hundreds of xl2007 files quickly if
> it could be done.
> However we have dropped this plan, and the responsibility is going to be
> with the xl2007 file owner to to the copy from their file saving as xl2003
> version. Keeps it simple but open to problems like "I forgot". (I'll probably
> end up coding a procedure to do it for them)
>
> Fortunately this is only while we migrate the core files to xl2007 which
> should only be a few months away.
>
> Thanks again.
>
> "Dave Peterson" wrote:
>
> > 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
> >

--

Dave Peterson