Skip to main content

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,(Table1eProduct name]=Sheet1!B2)*(Table1eQTY]<=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

 

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.

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