Sgarvey
Scholar

Excel as Middleware #Name? Error

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

 

0 Kudos
Reply
2 Replies
CJackson
Nintex Professional Services Expert

Re: Excel as Middleware #Name? Error

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.
0 Kudos
Reply
Sgarvey
Scholar

Re: Excel as Middleware #Name? Error

Hi 

 

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

0 Kudos
Reply