Excel as Middleware #Name? Error

S
Badge +1

Hi 

i am running a package that downloads an excel document at the end. In the excel doc i am using the this formula =INDEX(SORT(FILTER(Table1,(Table1[Product name]=Sheet1!B2)*(Table1[QTY]<=Sheet1!C2),0),2,-1),1,3)

 

When i open the File the formula is returning #Name? in the file. When i click enable edit the correct value shows.

 

Does anybody know why i am getting this value? I have tried disabling Protected View but the same issues still occurs.

 

Thanks 

Stephen

 

2 replies

C
Badge +2
You could try making sure that your template excel file type is .xlsx and not .xlsm, as macros aren't supported in Excel as Middleware.
S
Badge +1

Hi 


 


Found the problem, nintex does not support functions in Office 365. I had to rewrite formula with Functions from office 2016.

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings