Import Personal.XLS from 2003 to 2007?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shjco - 31 May 2007 17:02 GMT

I just upgraded to MS Office 2007 but it uses Personal.XLSB files for the
personal work book instead of the Personal.XLS. It loads my old Personal.XLS
file (which is over 1mb in size) but with complaints. How can I make it work
in 2007 without having to export and import some 200 macros?

Reply to this Message

Ron de Bruin - 31 May 2007 20:11 GMT

Unhide your personal.xls and use SaveAs to save it as xlsb

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

>I just upgraded to MS Office 2007 but it uses Personal.XLSB files for the
> personal work book instead of the Personal.XLS. It loads my old Personal.XLS
> file (which is over 1mb in size) but with complaints. How can I make it work
> in 2007 without having to export and import some 200 macros?

Reply to this Message

shjco - 01 Jun 2007 00:51 GMT

Thanks! After I did that, I had to delete my original Personal.XLS file,
then redefine the macro buttons, which wasn't hard. Thanks again.

shjco

> Unhide your personal.xls and use SaveAs to save it as xlsb
>
> >I just upgraded to MS Office 2007 but it uses Personal.XLSB files for the
> > personal work book instead of the Personal.XLS. It loads my old Personal.XLS
> > file (which is over 1mb in size) but with complaints. How can I make it work
> > in 2007 without having to export and import some 200 macros?

Reply to this Message