My Excel is in Finnish, but don't let that bother you...
First Report Filter "Kupi" has only number values in my source table, for example 643203, 3533, 253244, etc. How ever in Pivot's "Report Filter" all those values are converted to date values MONTH yyyy. How do I reformat the filter values to respect the original cell formatting?!
The same problem is with actual date values in my source table when using "Report Filter" in Pivot table. In my source data my dates are in format: dd.mm.yyyy and for some reason in Pivot's "Report Filter" all dates are shown in MONTH yyyy-format?! Why is that and what do I need to do to fix this?
ADDED MORE INFORMATION:
Structure for this Excel workbook is: one source table and about hundred pivot tables from that one source.
I use this Workbook daily and all these Pivot tables have worked before correctly. About a week ago when I opened the workbook all numeric data -cells had changed into date-format from no apparent reason?! I tried to restore to older versions of the document, but no bonus. Then I just manually corrected cell formatting of the source table and it looked just like before, but for some reason after that incident none of the pivot tables have worked correctly and even if I create new Pivot tables from my source table - they still have corrupted cell formatting, which do not respect the source table...
Below you can see a clip from my source table.
Below you can see that even though cell format in source table for column "Kupi" has been set to "Number", in Pivot table it is shown as date and there seems to be no way edit cell formatting in Pivot's Filters.
Below you can see how Column "Tilattu" is shown in Pivot's filters, even though in source data cell format is set to be "dd.m.yyyy". As you can see it is impossible to filter for a specific date!
EVEN MORE INFORMATION ADDED:
I've been testing workbook for a couple of hours now and it seems that no matter what I add to Pivot table, all cell formats defaults to "date"!? This is so frustrating.
- I created new Pivot table into new sheet.
- I filtered there date from november 2011
- I have two currency columns and sum of all rows in the last row of the Pivot table
- I selected an empty cell and wrote "=" clicked both currency sums and pressed enter to get the total into to empty cell outside of the Pivot table
- Even that cell in new sheet formatted into date!!!