Every month I dump new date in an excel sheet and refresh the data. The problem is on of the filters on my pivot tables is a date and when I refresh with the new data the formatting getting changed to General so my dates become numbers. I keep right clicking on the cell to change the format back to how I need it but it never fails to switch back to general when I refresh the new data.
