6:30-7:00 pm 

General Questions and Problems from the Audience
Working with Sheet Groups.    Multi-select sheets, Enter values, formulas, formats on many sheets with a sheet group. PastMtgs/0402/MultiSheet.zip

What are the things that drive you crazy with Excel?   Are there better ways?

Notes: ------------------------------

Aggrevations:

CopyDown: Assumes to fill a series. You should be able to change the default action. Smart Tags show up at the bottom window range of the affected range, not at the top where the action was accomplished. Therefore, it is out of immediate view. It can even be off the screen in the sheet is moved so that the tabs hang off the screen.

Scrolling is sometimes too fast. This is particularly a problem with Word. Excel is OK.

Default Find is row-wise, not column-wise.
Dates cannot be used prior to 1900.

Pivot Table Harder to format the total rows than it was in 98 Need to have more than one source range. At least allow a 3D Range.
Lack of a pivot through sheets. Such as Sheets to rows.

Help:

Help is worse than it was in 97
VBA is not in the default install
All "Load on 1st use" installs: abolish!

In lotus: 1+1 is understood as a formula, but without the '=' 

Find the next change in a cells --->

solution is Goto Special Column Difference.

Undo does not work on a grouped Sheet operation!!!!

Multiple Selection will work if they share the same rows or same columns

Corrupted workbooks: you get nothing. It should at least try.

 

Toolbar defaults to Standard and Formatting toolbar on one row.

The Reviewing toolbar shows up too many times.

Saving toolbars is not as easy as it should be.