Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Excel error
Microsoft Dynamics NAV (Archived)

Excel error

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

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

  • Shristi Profile Picture
    Shristi 25 on at
    RE: Excel error

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

  • Suggested answer
    Binesh Profile Picture
    Binesh 7,885 on at
    RE: Excel error

    Hey Nermina,

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Excel error

    Yes, this was the solution. Thank you!

  • Verified answer
    Binesh Profile Picture
    Binesh 7,885 on at
    RE: Excel error

    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.

  • Verified answer
    4BzSoftware Profile Picture
    4BzSoftware 6,071 on at
    RE: Excel error

    Hi Nermina,

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

    XlHelper.AutoFitColumnsInAllWorksheets(XlWrkBk);

    10_2D00_6_2D00_2017-3_2D00_54_2D00_52-PM.png

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Excel error

    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

  • Verified answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Excel error

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans