Exporting Budget w/ Formulas Error

Business Central/NAV User Forum
1

I’m trying to export a budget structure to Excel. When I check the box to “Include Totaling Formulas” I get an error message that “Some Navision Attain Filters cannot be converted into Excel formulas. You will have to check #N/A errors in the Excel worksheet.” Then, when I proceed to create the export, another error message appears “This message is for C/AL programmers: An exception occurred from an external component. The component did not provide an exception description.” If I don’t try to include totally formulas, the export is OK. So, what’s up with this?

2

Hey Guys, I have the same problem. When I faced the same with Analyses by Dimensions this was solved by not having any special charater in the Analyses view code name. But this time. Cannot really find out why. Is it because the formula in navision can have ‘|’ but excel cannot recognise this.

3

Hi everybody, I think that in creating budget use simple formula,and exposting to excel the program will only send the structure of the budget or the value of the beget.I used this function and I don’t meet the another error. The error may have the another reason. Best regards,

4

Hmmmm, so is this starting to sound like a (dare I say it) “bug”? Anyone else have another idea?

5

Same problem — somebody help-- it stops at a line in Table 370 -Excel Buffer

quote:

IF Formula = ‘’ THEN XlWorkSheet.Range(xlColID + xlRowID).Value := “Cell Value as Text” ELSE XlWorkSheet.Range(xlColID + xlRowID).Formula := Formula;
6

if your jn 3-60 it may be proble in CU Export Analysis View 424, Dim1Filter,Dim2Filter… lenght is 30, but in form 554 Dim1Filter is 250…

7

Hi ,

“This message is for C/AL programmers: An exception occurred from an external component. The component did not provide an exception description.” => maybe that’s because you not install navision propertly.

“Some Navision Attain Filters cannot be converted into Excel formulas. You will have to check #N/A errors in the Excel worksheet.” => maybe that’s because totaling formula exceeded the maximum length that can be handled by the system.

8

Has this been resolved, also are the language versions between nav and the excell the same.