Like many people, I have a love-hate relationship with software. It's great when it works, but it's so frustrating when you get a cryptic error message. And these messages seem to appear when you're short on time and patience. This happened to me last week when I needed to produce some stats and … [Read more...] about Quick Solution: PivotTable Field Name is not Valid
troubleshooting
Preventing Excel #DIV/0! Error
I now understand the difference between an Excel tip and an Excel annoyance. It’s an annoyance if the person you send your spreadsheet to doesn’t know the tip and you spend more time explaining the error than it takes to fix it. Next time, I’ll take the five minutes to fix my Excel formula and … [Read more...] about Preventing Excel #DIV/0! Error
How to Use Excel to Find Invalid Email Addresses
This week was one where multiple requests converged. I had two friends that needed to send emails to their customers. One had their information in an Excel spreadsheet and the other exported their internal databases into Excel. Both thought there were problems with many email addresses and wanted to … [Read more...] about How to Use Excel to Find Invalid Email Addresses