Unable to Use Imported Data on Excel 2019

%3CLINGO-SUB%20id%3D%22lingo-sub-2363064%22%20slang%3D%22en-US%22%3EUnable%20to%20Use%20Imported%20Data%20on%20Excel%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2363064%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Morning%20All%26nbsp%3B%3C%2FP%3E%3CP%3EI%20run%20iQ%20Business%20for%20my%20retail%20store.%20It%20allows%20me%20to%20import%20data%20on%20Excel.%20In%20my%20one%20store%20the%20data%20imports%20and%20is%20easily%20manageble%20to%20us%20for%20Charts%20and%20different%20Formulas.%20However%2C%20my%20newer%20excel%20is%20giving%20me%20issues%20with%20the%20data%20from%20excel%2C%20it%20wont%20auto%20count%20correctly%20the%20formulas%20dont%20work.%20I%20end%20having%20to%20redo%20the%20numbers%20manually.%20Any%20help%20in%20this%20regards%20would%20be%20useful.%3C%2FP%3E%3CP%3Ekind%20regards%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2363064%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2363522%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20Use%20Imported%20Data%20on%20Excel%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2363522%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1056491%22%20target%3D%22_blank%22%3E%40winst86%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAre%20you%20in%20Automatic%20mode%3F%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20304px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F281464i72500D3519618F15%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Good Morning All 

I run iQ Business for my retail store. It allows me to import data on Excel. In my one store the data imports and is easily manageble to us for Charts and different Formulas. However, my newer excel is giving me issues with the data from excel, it wont auto count correctly the formulas dont work. I end having to redo the numbers manually. Any help in this regards would be useful.

kind regards 

3 Replies

@winst86 

Are you in Automatic mode?

image.png

@Sergei Baklan I am in Automatic Mode, a friend of mine told me that excel could not identify the gaps in my numbers so it can count numbers in the 100's but not 1 000's. So could it be my seperator?

@winst86 

That could be if this setting is checked

image.png

Perhaps you may give concrete example of what is wrong?