Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 207
Default 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?



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 256
Default 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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening Excel 2003 file in Excel 2007: Links do not work Roshan Q Excel Discussion (Misc queries) 5 January 10th 08 10:24 PM
Opening Excel 2003 file in 2007 produces gibberish nosey313 Excel Discussion (Misc queries) 1 December 4th 07 10:15 PM
xls file works fine in Excel 2000 and 2007 but crashes on opening in 2003 gromit12 Excel Discussion (Misc queries) 2 November 6th 07 09:30 PM
Opening a XLSX File from 2007 excel to 2003 excel lvasquez3 Excel Discussion (Misc queries) 0 July 2nd 07 03:50 PM
Opening Excel 2007 file with Excel Viewer 2003 Jan Excel Discussion (Misc queries) 1 June 3rd 07 02:32 AM


All times are GMT +1. The time now is 10:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"