Opening an Excel 2007 file in Excel 2003

M

mreinders

Does anyone know how Excel 2003 would react if you open a spreadsheet created
in 2007 that exceeds the row total allowed by 2003? Does it truncate the
lines? Does it overflow to another tab? Crash?
 
I

ilia

It will only have the first 65,535 rows and first 255 columns (or
whatever those exact numbers are). You will also experience issues
with newly built-in ATP functions. New conditional formatting
features won't carry over. Table autoformats don't carry over. The
24-bit colors will be downgraded. You'll have problems with function
nesting if you have more than 7 nested. Etc. Find a list of
"improved limits" for Excel 2007 and that will pretty much tell you
what will work and what won't.
 

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

Similar Threads

Compatibility Problem between Excel 2003 and 2007 2
Compatibility Mode to Excel 2007 4
Unprotect 2003 excel files when opening in Excel 2007 1
Pivot Tables: Excel 2003 vs Excel 2007 2
Opening an .mdb file in Excel 2
NETWORKDAY + Excel 2007 + Excel 2003 1
Excel 2007 Pivot Tables compatible with 2003 3
Excel Lost data when opening Excel 2003 spreadsheet in Excel 2007 0

Top