Excel 2003 to 2007

J

Joe

I'm gonna upgrade to Office 2007 from Office 2003. I wanted to make sure that
all xls files which I have now in my disk will work once I upgrade to 2007
too.

Searched the General questions section for the same but I did not get any
hits, I'm sure this will be answered before, apologies.
 
R

Roger Govier

Hi Joe

Yes your files will all work in XL2007.
They will be opened in compatibility mode, which will mean they still
have the4 limitations of XL2003 in terms of number of rows and columns.

When you save the files, you have the option of saving them still in
compatibility mode as an Excel 97-2003 Workbook, so they can still be
used in XL2003, or you can save them as an XL2007 format (.xlsx), which
after closing and re-opening, they will be able to use the full 1
million plus rows etc.

BE AWARE - if your exiting files contain macros, then they must be saved
as an Excel Macro_enabled Workbook, with a .xlsm extension.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top