Excel Annoyances

Index

Symbols

##### (number signs), data appears as in PivotTables, PIVOTTABLE DATA DISPLAYS AS NUMBER SIGNS

#VALUE! error, The Fix:

3D charts, The Annoyance:

changing colors in, 3D CHART ANNOYANCES

floor turns black, The Fix:

pie explosions in, The Fix:

“Recently used file list” setting, The Fix:

“Reference is not valid” error message, “REFERENCE NOT VALID” ERROR

“what-if” analysis, The Fix:

creating scenarios, The Fix:

finding values that generate specific results, FIND A VALUE THAT GENERATES A SPECIFIC RESULT

Solver, using to solve multivariate problems, USE SOLVER TO SOLVE MULTIVARIATE PROBLEMS

A

A1 notation versus R1C1 notation, CREATE A REFERENCE TO A PIVOTTABLE CELL

Abacus, The Fix:

absolute references

toggling between relative and, The Fix:

versus relative references, The Fix:

Accent Excel Password Recovery, FORGET PASSWORDS! USE ENCRYPTION

Access

linking data to Excel worksheet, The Fix:

moving data between Excel and, IMPORT AND EXPORT ANNOYANCES

tables

copying data from Excel and pasting into, IMPORT AND EXPORT ANNOYANCES

identifying, The Fix:

truncated data in, The Fix:

Advanced Filter command, FIND DUPLICATE ENTRIES IN A DATA LIST

aggregate functions, TRANSLATE ERROR MESSAGES INTO ENGLISH

alternative data sets, The Fix:

Analyse-it, The Fix:

apostrophes, The Fix:

Arkanoid, The Fix:

array formulas, MASK ERROR MESSAGES IN A WORKSHEET

ASAP Utilities, The Fix:

AutoCorrect feature, The Fix:

using to advantage, KEEP WEB AND FILE ADDRESSES AS PLAIN TEXT

autocounter (database tables), GET MORE THAN 65,536 RECORDS ...