What's Missing in Excel 2007?

 

By J. Carlton Collins
 

While it may appear that there is a lot of stuff missing in Excel 2007 compared to the 2003 edition, almost everything is still there – you just may need to look for it a while to find it. A few of the hard-to-find things I had trouble located were as follows:

  1. The “Create PivotTable from Multiple sources” feature is gone from the insert PivotTable menu, but you can still find it by customizing your Quick-Launch toolbar and adding the “PivotTable and Chart Wizard” icon. Yu will see that this functionality is still there.The ability to send a worksheet as body of e-mail is also gone from the Start, Send, E-mail option. but you can still find it by customizing your Quick-Launch toolbar and adding the “Send to mail Recipient” icon. You will see that this functionality is also still there.

  2. The data Form tool is still there – you have to add “Form” to the Quick Access Tool Bar.

  3. The “Speak Cells” command is missing from the ribbons, but this command is still available by customizing the Quick Launch toolbar and adding the “Speak Cells” command.

  4. In fact there are a total of 219 commands in Excel that do not appear on the Excel Ribbon – you can view a complete list of these commands by customizing the Quick Launch Toolbar and choosing the option to view “Commands Not in the Ribbon”.

However, there are some things that have disappeared as follows:

  1. 1.   No more publishing interactive web pages. 

  2. 2.   Embedded video clips and sound clips no longer play within Excel, they switch the user over to Media player instead.

  3. 3.   The AutoFormat as we knew it is gone. It has been replaced with the “Format as Table” option in the Styles group of the Home tab, but it does more than format your table. It converts your table to what Excel used to call an Excel List, complete with list arrows and filter options and all kinds of junk you really don't need and probably don't want if your goal is just to dress up your data. Unfortunately this new functionality does not apply a unique format to subtotal rows like Excel 2003 did. Bummer. Therefore you must collapse your rows in Outline, select visible cells, and apply a different color, then expand your rows again to pull off this type of format.