What happened to my PowerPivot Excel Data? 1904? What the?
A few months back I had a rather unique Excel discovery. We were loading Excel data files into PowerPivot using the import Excel file option instead of the copy/paste and linked table method (for obvious reasons) and all of a sudden we noticed some issues with dates. The source data looked like the following: