0

Hyperlinks in Excel attachment disappear in scheduler

Jet Reports Historic Posts

March 07, 2012 10:28

None

Follow

I use JetScheduler for generating an Excel report containing hyperlinks to SharePoint sites, but these are useless.
When running the report in Excel, the hyperlinks work flawlessly, but when the report is run in Scheduler and sent by email, the hyperlinks are all a bunch of rubbish. Suddenly they contain referral to the Jet.xlam file so the hyperlink points into deep space.
I read that Scheduler has this effect in email bodies, but that it also happens in attachments is very annoying.
Is there really no way to get working hyperlinks in Excel-files that are sent as attachment?

• Facebook
• Twitter
• LinkedIn

5 comments

• 
  Jet Reports Historic Posts March 09, 2012 07:57 Official comment

  You could also try putting the NL function outside the HYPERLINK function.
  
  MyCell = NL(…)
  OtherCell = HYPERLINK(…MyCell…)

• 0
  
  Jet Reports Historic Posts March 07, 2012 16:58

  How exactly are your hyperlinks being constructed? It sounds like maybe you're using Jet functions to create the hyperlinks, is that right?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts March 08, 2012 13:52

  Hughes,
  
  That is correct indeed. Our NAV-database contains a field with the URL I need, so the logical way is to use a Jetfunction to retrieve it.
  The function used is this:
  =HYPERLINK("http://idefix"&NL("first","Job","Site URL","No.","@@"&D14)&"/Lists/Issues/NewForm.aspx",D14)
  Cell D14 contains the Job No of the SharePointSite I want the hyperlink to point to.
  
  With kind regards,
  
  Willem

• 0
  
  Jet Reports Historic Posts March 08, 2012 16:05

  Hi Willem,
  
  Are you using +Values in cell A1 of the report? If you put +Values in cell A1 then the Jet functions should be converted to values when the report is run so there will be no link between the report and the Jet add-in in Report mode. Does that help?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts March 09, 2012 10:04

  Sebastiaan,
  
  Thanks for your input; this seems to be the solution.
  Now my report contains active hyperlinks to the issue-list on the SharePoint project-site which will make my colleagues happy :twisted:
  I am so glad it works finally!!!! :lol:
  
  @Hughes: thanks for your suggestions, I really appreciate your efforts. This time however someone else provided the solution.
  
  Best Regards,
  Willem