Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
LSL LSL is offline
external usenet poster
 
Posts: 1
Default can you summarize differences between Excel 2000, 2003 & 2007?


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,718
Default can you summarize differences between Excel 2000, 2003 & 2007?

Go to Microsoft's site for that kind of information.

--
Jim
"LSL" wrote in message
...
|


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 25
Default can you summarize differences between Excel 2000, 2003 & 2007?

Here's my 2 cents:

In my opinion, the best improvement is the Excel binary format: a new,
compressed file format which lets you save plenty of space. In fact,
zipping an excel binary format usually saves no more than 1% of its
size.

Other improvements:
- easier access to a SQL server in ODBC connections
- more powerful pivot tables
- new table format, which makes Excel - finally! more similar to a
database: field names can be assigned, formulas can be defined
directly for a whole field, etc

Cons:
- the new interface. Some love it, some hate it. I hate it. Even if
you love it, though, it will take a while to get used to it
- VBA: some stuff has changed, and some code that used to work in
Excel 2003 no longer does in Excel 2007. The problem is, many changes
are not even documented so you'll discover the hard way!
- speed: I find the new bells and whistles make 2007 much slower than
its predecessors
- new limit of 1 million rows. Many people find this an improvement; I
don't, because spreadsheets are not meant to handle this much data.
This 'enhancement' will simply mean that fewer people willl bother
learning a database, even if they should, and in many organizations
people will use Excel to handle this much data, which is not optimal
at all
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
Drawing compatibility excel 2000; 2003 vs 2007 Tim Excel Discussion (Misc queries) 1 January 28th 08 04:22 PM
Excel Macros - Any Major Differences Between 2003 and 2007 bk Excel Worksheet Functions 1 November 20th 07 03:56 PM
Differences between csv saved from Excel 2003 and Excel 2007 Update Excel Discussion (Misc queries) 0 September 28th 07 10:53 PM
opening word doc from excel 2000 and 2003 differences Colin C Excel Discussion (Misc queries) 0 December 11th 05 08:06 PM
Major differences between Microsoft 2003 and 2000? Zody Excel Discussion (Misc queries) 3 January 7th 05 02:02 AM


All times are GMT +1. The time now is 11:38 PM.

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"