Unable to Use Imported Data on Excel 2019

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


Are you in Automatic mode?


@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?


That could be if this setting is checked


Perhaps you may give concrete example of what is wrong?