Skip to main content
Microsoft Dynamics NAV forum
Suggested answer

After export to Excel can't use formula

editSubscribe (0) ShareShare
ReportReport
Posted on by 5

I using Dynamics NAV 2018 Version, when I export report to excel file, try to add some formula { e.g =RIGHT(A57,8) }. After input formula excel will no response need close it.

Anyone Know what happen on this case?

  • rrizzi7210 Profile Picture
    rrizzi7210 5 on at
    RE: After export to Excel can't use formula

    I can confirm that this works. My use-case was to merge/lookup data from a .csv file and update an existing column in the Customer Table such that an existing column in my Customer Table is used to find a row in an Excel table I am importing from another system which can generate CSV files. It was relatively easy once I knew that the column in my Customer Table needed to be changed to "General". My VLOOKUP() function now works as it should.

  • troyh1968 Profile Picture
    troyh1968 45 on at
    RE: After export to Excel can't use formula

    Look at the format that the workbook is in. It might be in TEXT which does not support formulas in Excel. If it is Click the upper left corner of the spreadsheet and change to General and try you formula again. It should work.

  • Suggested answer
    Gearoid Profile Picture
    Gearoid on at
    RE: After export to Excel can't use formula

    Sorry to hear that the suggestion did not work. I would recommend opening a support ticket with Microsoft via your Solution Provider or Dynamics NAV Partner. 

  • Jackng_hk Profile Picture
    Jackng_hk 5 on at
    RE: After export to Excel can't use formula

    Hi,

    I try to place the formula outside the NAV table data region, but still no response.

    But thanks for your suggestion.

  • Suggested answer
    Gearoid Profile Picture
    Gearoid on at
    RE: After export to Excel can't use formula

    Hi,

    Try placing your formula in a cell which is outside the NAV table data region (i.e. the colour coded cells) in the spreadsheet. 

    Hope that helps. 

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,030 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,562 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans