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?
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.
I try to place the formula outside the NAV table data region, but still no response.
But thanks for your suggestion.
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.
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.
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.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Rishabh Kanaskar 3,750
Sumit Singh 2,689
YUN ZHU 1,987 Super User 2025 Season 2
