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.
