Using the 'get external data from Access' (Ribbon), we were initially able to pull, see and otherwise manipulate the data associated with 02/29/2012. Then all of a sudden 'Excel 2007' started acting silly and responding slow. We decided to trash the entire workbook; start over. This is when we were slapped by 'Excel 2007' whereby she refuses to pull, or otherwise display, any data associated with the date 02/29/2012 --from our Access 2007 database--.
-
The most annoying thing is, it was working. If it never worked, then no big deal. However when something works, then suddenly stops working, then that is not nice. We are getting the feeling that this happened somewhere between 02/29/2012 23:59:00 and 03/01/2012 00:00:00 while we were actively working in the VBE.
The only data missing, within 'Excel 2007', is anything directly associated with the date 02/29/2012.
Is there a resolve for this?
Bookmarks