Opening an Excel 2007 file in Excel 2003
 

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?

Opening an Excel 2007 file in Excel 2003
 

It asks you to downlwoad the excel viewer.


"mreinders" wrote in message
...
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?

Opening an Excel 2007 file in Excel 2003
 

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.


On Feb 8, 2:17 pm, "Gaurav" wrote:
It asks you to downlwoad the excel viewer.

"mreinders" wrote in message

...

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?