Report Offensive Message
Would like to see similar Top Ten gotchas list for the advanced
Great list. Getting past the basics, there are plenty more gotchas in Excel that end up wasting time and causing issues. Would love to see a best practices list for preventing excel file corruption, such as avoiding corruptions (shared spreadsheets on the network, leftover data connection corruptions when importing data), There are also time consuming traps even the experienced fall into such as dealing with merged cells, and vlookups that don't return values if the text string is too long or contains certain characters that the function does not match on. I would love to be pointed to an article that has more best practices on the subject. Good job.