Chapter 1: Entering Data

Utilities

• ASAP Utilities
• FormIDEA
• Handicap Manager
• Import Wizard
• Navigator Utilities

Macros

• Copying a Word Table Into Excel 97 Introduces Blank Rows
• Keep the Same Active Cell When You Move to a New Worksheet

Chapter 2: Format Annoyances

Utilities

• Office-Navigator
  http://www.office-addins.com/-excel-addins/index.html#07
  or
  http://www.sharewareorder.com/Office-Navigator-download-download-19980.htm
• Pac-Man

Macros

• Display the RGB Values of Colors in a Workbook?s Color Palette
• Search for Cells with Specific Formatting

Chapter 3: Formula Annoyances

Utilities

• Abacus
• Analyse-it
• StatTools
• Tetris
• WinSTAT
• XLStat

VBA Code

• Round Hours to the Next Quarter of an Hour
• Parse Data of Inconsistent Lengths

Chapter 4: Manipulating Data

Utilities

• CryptoQuote
• Pivot Table AutoFormat XL
• Pivot Table Helper
• Rubik?s Cube
• XLSTAT-Pro

Chapter 5: Chart Annoyances

Utilities

• Blackjack
• CHARTrunner
• DeltaGraph
• Gradient Contour Chart Add-In
• Miner3D Excel Professional
• Office 97 Service Release 1 (SR-1)
• Office 2000 SR-1/SR-1a Update
• Power Utility Pak (PUP)
• Project KickStart
• Treeplan
• StatTools
• Xatellitesheet
• XLSTAT-3D Plot
• XLSTAT-Pro

Chapter 6: Exchanging Data

Utilities

• BusinessData2.mdb (967KB ZIP file)
• Dellinks.exe
• DigDB
• SQL*XL 3 and SQL*XL ADO
• Triple Yahtzee

VBA Code

• File Export Macro Ignores Regional Settings

Chapter 7: Printing

Utilities

• Crystal Reports
• Space Invaders
• Xcelsius 3.0

Chapter 8: Customization, Macro, and VBA Annoyances

Utilities

• Accent Excel Password Recovery
• Advanced Excel 2000 Password Recovery
• CertMgr.exe
• Cryptainer LE
• Cryptomathic File2File
• Excel Locksmith
• Excel Password Recovery
• Excel Password Remover
• Excel & Excel/VBA examples
• FaceID.xls
• GuaExcel
• Lost Password: Excel Key
• Unbreakable

VBA Code

• Force a Macro to Affect the Active Workbook
• Use an If?Then Criterion Statement
• Run Time Runaround
• Range.Calculate Error
• Create a Workbook with a Worksheet for Each Month
• Pick Random Entries from a List
• Generate Non-Repeating Random Values

Chapter 9: Excel 2003 Annoyances

Utilities

• Connect 4
• DSS game
• Syntext Serna
• Stylus Studio XML
• XML Diff
• XMLSpy Home Edition

Return to the Excel Annoyances catalog page.