Tag Archives: Unreadable content

Naughty Sorts

Continuing the theme of naughty code which can cause Excel XML corruption, let’s have a look at some code which sorts some data in a range but then causes XML errors when the file is saved and re-opened. Here’s my sheet: … Continue reading

Posted in Microsoft Excel | Tagged , , , | Leave a comment

Naughty Data Validation Lists

Data validation is a wonderful thing. I know it has its shortfalls (and I always hope for improvements in each Office release)  but, nevertheless, I do use it a lot in my spreadsheets – particularly data validation lists. The source for a data validation list comes in … Continue reading

Posted in Microsoft Excel | Tagged , , , | 2 Comments