Small and medium business | Business Central, N...

After export to Excel can't use formula

(0) Share

Report

Posted on by Jackng_hk

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?

All responses (5)

Answers (0)

rrizzi7210 5 on at

Like (0)

Report

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 47 on at

Like (0)

Report

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 on at

Like (0)

Report

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 5 on at

Like (0)

Report

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 on at

Like (0)

Report

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.