Excel 2007 Nightmare

Macros from earlier versions (#macros)

• Emailed pesonal.xls from Windows 2000 system, with Excel down saved as personal.xlsb as was created in Excel 2007, but was not accepted so saved instead as C:\Users\userid\AppData\Roaming\Microsoft\Excel\XLSTART\personal.xls   and appears to be accepted (the macros are found) as all files in XLSTART are opened by Excel. (2007-08-28)
• Next problem is to install custom toolbar buttons in Excel 2007.  Can see they can be loaded from an adaption of Menu Editor, but nothing to show what the results look like. (and FINALLY GOT AROUND TO IT 2007-09-17, see below).

Ergonomic Hell (#nightmare)

Everything in Excel 2007 is an ergonomic nightmare  and takes at least one more click for anything that was in a menu, and because things have to be spread out on the ribbon they don't line up very well and is so disorganized for drill down type of viewing that you had in menus and hyperlinks.  The logical arrangement is lost because you can't read what you need in a small viewing area, which is one of the key elements in ergonomics.  Will try to get around these obstacles as best I can but have already wasted two months so far (2007-10-13) and have just skimmed the surface and can hardly use Excel at all at this point.

Loss of Data Hell, see Change of Ctrl+A.

Loss of Menus Hell, see this page concerning Ribbon and Customizing the Quick Access Toolbar (qat).

Loss of Help, a steady decline that started with Excel 2000. 

Excel 2007 Ribbon (#ribbon)

1. Make Developer Ribbon Tab visible:  Office Button, Excel Options, Click Popular, Show Developer tab in the Ribbon check box.
2. Ron's Excel Tips http://www.rondebruin.nl/tips.htm
3. Menu for favorite macros in Excel 2007 (for all workbooks) http://www.rondebruin.nl/qat.htm
4. J.Latham reported 2007-09-16 that a file with menu in Excel 2003 would be found in Excel 2007 in the Add-ins (last section on the ribbon).
   C:\Users\StandardUser\AppData\Roaming\Microsoft\Excel\XLSTART\personal.xls
5. To add missing items back to the Status Bar: right-click on status bar

Customize Quick Access Toolbar   (#qat)

If you don't have such a list suitable for input into Ron's "Menu for favorite macros..." it is the same arrangement as needed for John Walkenbach's (Tip 53). 

You can create the worksheet from your old Excel (pre Excel 2007) using Barhopper -- fixup for Restored Toolbars (also List of Menu Items) macro, Barhopper -- fixup for Restored Toolbars, and -- Listing of Menu Items — The macro even works with Excel 2007 though you should have the workbook you used to create the qat as a hidden workbook in your XLSTART directory.  The code for both barhopper_ws macro and the macro if invokes, BarHop_ws, are found on the related code page, and creates the a new worksheet with the data in the format required.

Since the workbook MyMacroFile.xlsb is now in place within C:\Users\<USER>\AppData\Roaming\Microsoft\Excel\XLSTART
The QAT can be refreshed by repeating the last part of Ron's instructions:

• View, Window, Unhide -- choose MyMacroFile.xlsb   (as marked with RED on the larger image above).
• Make changes as necessary to the "MenuSheet" worksheet, then
• You can click on the  Refresh Menu  button on the "MenuSheet" worksheet of MyMacroFile.xlsb workbook example to see if your changes are correct.
• When It is OK click on the  Hide Save  button also on the worksheet..

Next step do something with the buttons (#buttons)

Will have to find out how to add buttons of my own creation to Excel 2007.  This relates to material in my Toolbars page, that will have to be\ made to work in Excel 2007 rather than just a cobbled together QAT that include a submenu of what were my toolbar buttons.

System Taskbar (#tasks)

Excel users that want to see multiple instances of Excel workbooks on the system taskbar should also refer to taskbar on my Excel freeze.htm page, and refer also to my Windows Vista page.

Things improved in Excel 2007   (#improved)

Is anything actually improved in Excel 2007 other than the obvious increase from 65,536 rows by 256 columns to 1,048,576 rows by 16,884 columns, and the multirow formula bar (expanded on right).

Four Big Lies (#fourbiglies)

What were the design goals of the Office Fluent user interface and how were they determined to be top priorities? We wanted to deliver new capabilities that empower people to get the results they want, faster. We had four major design goals:
  1. Make it easier for people to find and use product features.
  2. Reduce design clutter and interruptions.
  3. Make it easier for people to discover the capabilities they need.
  4. Support the creation of great-looking documents.

Help with Excel 2007 (#help)

More getting used to Excel 2007

Help and How-to Home Page (office.microsoft.com), see Browse Help and How-to by Product Some Old keys, you had better learn for Excel 2007
– Excel keyboard shortcuts 2000 - 2007, or
– Keyboard shortcuts - Excel - Microsoft Office Online Excel 2003 (use the "Show All")

• Ctrl+1, Format Cells, at least once there the dialog is same as before
• Shift+F3, Function Wizard (actually you can still click on [fx] next to address bar)
• Use the row/column/cell context menus to insert/delete rows/columns/cells.
• Ctrl+F1 to minimize most of ribbon (or double-click on a ribbon tab to toggle)

Not convoluted enough for you see the Microsoft help Excel Ribbon mapping workbook old menus to new ribbon (not a conversion), or the same information in Guide (Abobe Flash), or as a web page Help and How-To Home page (office.microsoft.com).  *** Interactive Flash showing 2003 menus.*** 

Those two guides are not of much help when it comes to what you need to use for Tools,Options so here is something typical of what was Tools, Options, View (tab), select the options horizontal scroll bar and vertical scroll bar is now the following:

Use the Office Button in upper left corner, at the bottom of that dialog is Options, then on the left choose the Advanced button (red), then scroll down on the right side to "Display options for this workbook" (blue stripe) which is about 1/3 of way down, then checkmark "Show horizontal scroll bar" and "Show vertical scroll bar"

Related   (#related)

• Excel - My Excel Pages
• Excel keyboard shortcuts 2000 - 2007
• Daily Dose of Excel » Blog Archive » Excel 2007 FAQ (Draft), John Walkenbach
• (placeholder)