I can't tell you what is causing the issue, but I can tell you what I did to get the dates to filter (similar to what has been mentioned).
- I selected cell AE3129 and pressed the tab key (which caused the file to buffer for a while and the 'Save As' to pop up),
- I selected the filter in cell Z1 and pressed 'OK'.
The table then filtered as I would expect (showing only the rows through 2488).
Let us know if you have any questions.
Unfortunately, this works temporarily until I allow 2017 and then try to filter it out again. A stubborn row remains.
Originally Posted by sandy666
Mybe it will be stupid idea but try (after click OK on any filter, save and close) to zip this file, unzip, and check for this error again.
Zip, Rar, whatever....
Bookmarks