Ok as a report but shows errors when using scheduler

I have scheduler set up to send out a range of reports overnight, this has been working fine until last night where all fields that are using excel functions show a #REF! error.

Here is one of the functions that is showing the error.

=IF(H11="","<- "&NL("First","Salesperson/Purchaser","Name","Code",C11)&" you need to add industry","") 

However, when I run the report individually from excel, everything is fine. I have updated the latest version of Jet Reports, (20.2.19154.1)

The issue seems to be related to getting the cell value.  Any advise would be great.

1 comment

Please sign in to leave a comment.