Forum Discussion
winst86
May 18, 2021Copper Contributor
Unable to Use Imported Data on Excel 2019
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
- SergeiBaklanDiamond Contributor
- winst86Copper Contributor
SergeiBaklan 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?
- SergeiBaklanDiamond Contributor
That could be if this setting is checked
Perhaps you may give concrete example of what is wrong?