Finance | Project Operations, Human Resources, ...

Import excel file with formulas

(0) Share

Report

Posted on by Sayid

Hello,

I am having a problem with importing the excel file. When there are some formulas, I mean like e.g.' =123*456 ' in the excel file, only the first part, 123 is imported. Did someone have the same problem, and found a solution? I know that in AX12 it worked fine, but in D365 the process was recreated.

Thanks, Sayid.

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Brittany Burke on at

Like (0)

Report

RE: Import excel file with formulas

I would suggest saving the file into a new file (assuming you re-use the formulas/template) and copy and paste all the cells as values to remove the formulas. Depending on the field, D365 may not recognize the formulas. I find it better to just paste as values and re-save, minimizing the issues with the import.

Hope this helps!

Was this reply helpful? Yes No
Sayid 75 on at

Like (0)

Report

RE: Import excel file with formulas

Hello, yea, I know, this would be easiest solution, but the user does not want to work like this... :D

Was this reply helpful? Yes No