Forum Discussion

winst86's avatar
winst86
Copper Contributor
May 18, 2021

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

    • winst86's avatar
      winst86
      Copper 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?

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor

        winst86 

        That could be if this setting is checked

        Perhaps you may give concrete example of what is wrong?

Resources