Opening an Excel 2007 file in Excel 2003

  • Thread starter Thread starter mreinders
  • Start date Start date
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?
 
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.
 
Back
Top