Having a strange problem with an Excel file extracted from PWA /Project 2007 using Excel 2003 with XP.
I extract the view that I want, then go to the Excel file. Two columns are Start and Finish. If I autofilter the date columns, the criteria “is less than” and “is greater than” don’t work normally. In either case, all the rows are hidden.
If I filter on a particular date (e.g., 5/27/2011) I get expected results. If I copy and paste the two date columns to other columns, or another sheet, or another book, same problem. If I create a list of dates in the same worksheet or book, the less than and greater than work fine.
Is a puzzlement! I’ve read and Googled the problem with no luck. Any suggestions will be appreciated.