Vlookups in scheduled reports

Hi,

I am having some issues with my scheduled reports not updating the values of the vlookups.

When I open the report everything works perfectly and the lookup values are updated, but when the report is scheduled via Jet Scheduler it does not update the values…. is there anyway around this?

Thanks in advance for your help.

Cheers
Sara