| Quickly shuffling toolbar buttons - Excel | | Print | |
Here's a quick tip you can pass on to your users who like to modify their Excel toolbars.
Instead of right-clicking a toolbar and selecting Customize to launch the Customize dialog box, they can simply press the [Alt] key and click and drag a button to any toolbar they want. Of course, both the source and target toolbars must be visible for this procedure to be effective.
One quick word of warning: This technique moves buttons, so they will no longer be on the default toolbar. If users want to copy a button to a new toolbar while retaining its position on the original one, they can hold down [Ctrl][Alt] while clicking and dragging the button.
Opening a workbook at startup
If some of your users spend much of their day working in a specific workbook, you can teach them how to designate that workbook to open each time Excel launches. All they need to do is place the workbook (or a shortcut to the workbook) in the XLStart folder. This technique also works with network shortcuts.
You'll find the XLStart folder in the same place as the Excel program files—typically C:\Program Files\Microsoft Office\Office. After placing the file or shortcut in the XLStart folder, the user can just restart Excel to see the file pop open automatically.
Repairing broken file type associations
How many times has one of your users mysteriously lost his or her file associations, requiring you to go to the File Types tab and re-associate Excel (or Word and PowerPoint) to the .xls and .xlt file types?
There's a faster way to fix Office file type associations, and it takes just one quick step. Using the /regserver command line switch will make Excel reregister itself and rewrite all its registry entries, including its file type associations. You can reset all your users' file extensions for Excel, Word, PowerPoint, and Access using this same method.
From the command line, type C:\Program Files\Microsoft Office\Office\Excel.exe /regserver. You can also modify a shortcut to Excel by adding /regserver after the end quotes in the Target field of the Shortcut tab on the shortcut's Properties sheet.
Web Publishing Wizard Error with Office 2000
When trying to run the Setup utility after your initial Office 2000 setup, you may receive the following error:
Insert Disk
The file 'Crswpp.dll' on Web Publishing Wizard disk cannot be found.
Insert Web Publishing Wizard disk in the selected drive, and click OK.
Further efforts to run Setup will produce similar errors.
Microsoft has identified the problem as being connected to the installation of some modem hardware. Fortunately, clicking Cancel when you receive this error message will usually prompt Setup to run successfully with no harmful effects.
| Users' Comments (0) |
|
No comment posted
