Excel error

(0) Share

Report

Posted on by Community Member

I have a report which populates data and exports it to excel.

Report contains the following line:

Sheet.Range(excelString[i]+FORMAT(excLine+COUNT+3)).Formula:='=COUNTIF('+excelString[k]+FORMAT(excLine)+':AR'+FORMAT(excLine)+';"'+CA.Code+'")*8'

excelString[i],excelString[k] has a value of a colum for example D, and the rest are numbers.

This is worrking on some excels. For example i have a two machines with office 2013 Proffesional Plus.

On the first excel is populated, on the second it gives the error attached.

The only difference is regiona settings: Language.

6116.err.png

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (3)

Verified answer

Alexander Ermakov 28,096 on at

Like (0)

Report

Can it be the case that the delimiter is also different in the regional settings?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

NAV TABLE EXPORT or PRINT TO EXCEL

Go to Department>Administration>IT Administration>General>Manage style Sheet

Choose Style sheets Common to all > Action>Import>Style Sheet

In search option put .xsl and enter then find then select

Navision From To Excel

In send To Program option

Create EXCEL.EXE as executable and Name as Microsoft EXCEL

Was this reply helpful? Yes No
Verified answer

4BzSoftware 6,073 on at

Like (0)

Report

Hi Nermina,

Hope comment below code line of table 370 Excel Buffer help you:

XlHelper.AutoFitColumnsInAllWorksheets(XlWrkBk);

Was this reply helpful? Yes No
Verified answer

Binesh 7,885 on at

Like (0)

Report

Hello,

Has the Office installation on the problem workstation been activated yet?

I think some automation issues on your PC.

Need to re-activate Office. After re-activating, the issues resolved.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yes, this was the solution. Thank you!

Was this reply helpful? Yes No
Suggested answer

Binesh 7,885 on at

Like (0)

Report

Hey Nermina,

If your problem is fixed then Verify the answer so it can be helpful for others member also.

Was this reply helpful? Yes No
Shristi 25 on at

Like (0)

Report

HI, Nermina Pzz verify which solution has worked for you.

Was this reply helpful? Yes No