My friend Harald is putting together a utility that identifies common problems. The idea is that the utility would identify these easy-to-fix, hard-to-spot errors and eliminate the need for a support call. On the list so far are
- Calculation set to manual
- R1C1 style option selected
- Extraneous files in the XLSTART folder
- Circular references
- Array formulas entered as non-array
- SUM function on hidden cells instead of SUBTOTAL
What are some other common problems that you experience or are asked to fix?