Imorting data from access to xl

%3CLINGO-SUB%20id%3D%22lingo-sub-2659777%22%20slang%3D%22en-US%22%3EImorting%20data%20from%20access%20to%20xl%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2659777%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20imported%20some%20data%20from%20access%20to%20xl.%20I%20want%20to%20group%20som%20data%20in%20months%2C%20qvartal%20and%20year.%20But%20wen%20I%20try%20to%20set%20up%20a%20pivottabell%2C%20and%20select%20dato%2C%20it%20will%20not%20makes%20this%20group.%20I%20have%20formatted%20the%20datofield%20so%20it%20should%20be%20correct%2C%20bet%20there%20is%20something%20thats%20goes%20wrong.%20Do%20you%20have%20any%20tips%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2659777%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2659820%22%20slang%3D%22en-US%22%3ERe%3A%20Imorting%20data%20from%20access%20to%20xl%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2659820%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1131184%22%20target%3D%22_blank%22%3E%40abra22%3C%2FA%3E%26nbsp%3BWell%2C%20I%20suspect%20that%20the%20dates%20column%20still%20contains%20texts.%20Formatting%20a%20column%20as%20Date%20is%20not%20enough.%20You%20will%20have%20to%20be%20sure%20that%20the%20dates%20are%20recognized%20by%20Excel%20%3CSTRONG%3Eupon%20import%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3EOr%20did%20you%20perhaps%20disable%20the%20automatic%20grouping%20feature%20under%20File%2C%20Options%2C%20Data%3F%20The%20box%20at%20the%20bottom%20should%20NOT%20be%20checked.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-08-18%20at%2011.53.44.png%22%20style%3D%22width%3A%20837px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F304010iD5FC5A9A9CF99ED7%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-08-18%20at%2011.53.44.png%22%20alt%3D%22Screenshot%202021-08-18%20at%2011.53.44.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have imported some data from access to xl. I want to group som data in months, qvartal and year. But wen I try to set up a pivottabell, and select dato, it will not makes this group. I have formatted the datofield so it should be correct, bet there is something thats goes wrong. Do you have any tips?

1 Reply

@abra22 Well, I suspect that the dates column still contains texts. Formatting a column as Date is not enough. You will have to be sure that the dates are recognized by Excel upon import.

Or did you perhaps disable the automatic grouping feature under File, Options, Data? The box at the bottom should NOT be checked.

 

Screenshot 2021-08-18 at 11.53.44.png