0

Scheduled Jet report to One Drive sync

Devora Locke

May 22, 2018 20:23

None

Follow

 

I have a couple Jet reports scheduled to run off my computer and write to a One Drive folder that is then synced up to a Sharepoint site using OneDrive for Business. The files run fine and sync fine, except that some of the data fields say 'VALUE!' on them. If I run the reports manually they're fine. Aside from the sync the only difference is that the scheduled report is outputting only data, no Jet Code. Has anyone ever had such an issue before? No idea what's going on.

 

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Harry Lewis May 22, 2018 21:00

  Does #VALUE! appear in cells which have Jet functions or cells that contain other formulae/functions? 

  What version of the Jet Excel add-in are you using?

  

• 0
  
  Devora Locke July 05, 2018 20:20

  latest version. #Value appears in the functions fields. 

• 0
  
  Harry Lewis July 05, 2018 22:18

  Thank you.  I assume that means you are using version 18.3.18165.4.

  If Excel is not able to access the Jet Excel add-in when the report is run, #VALUE! errors can result.

  Have you checked that ALL the permissions necessary for running reports have been applied to the user under whose account the scheduled task is running?

  Edited by Harry Lewis July 05, 2018 22:21