I've got an issue with Pivot Tables in a large file. At some point, I had a crash. The file was autosaved. Sometimes following autosave, my cell formats shift from General to Date. I've read about this shift elsewhere in the form, and found that this can be corrected by resetting the Normal format on the Styles ribbon and reapplying that style to the effected cells.

However, the Pivot Tables that I run off the data still carry over the Date formatting in the Select Field window. I've tried applying the Normal format Style to the tables, and changing the format of the effected Pivot Tables directly. Nothing works.

Any thoughts?