Formatting keeps changing in pivot table filters.

%3CLINGO-SUB%20id%3D%22lingo-sub-1619809%22%20slang%3D%22en-US%22%3EFormatting%20keeps%20changing%20in%20pivot%20table%20filters.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1619809%22%20slang%3D%22en-US%22%3E%3CP%3EEvery%20month%20I%20dump%20new%20date%20in%20an%20excel%20sheet%20and%20refresh%20the%20data.%20The%20problem%20is%20on%20of%20the%20filters%20on%20my%20pivot%20tables%20is%20a%20date%20and%20when%20I%20refresh%20with%20the%20new%20data%20the%20formatting%20getting%20changed%20to%20General%20so%20my%20dates%20become%20numbers.%20I%20keep%20right%20clicking%20on%20the%20cell%20to%20change%20the%20format%20back%20to%20how%20I%20need%20it%20but%20it%20never%20fails%20to%20switch%20back%20to%20general%20when%20I%20refresh%20the%20new%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1619809%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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.

0 Replies