0

Error saving file: "Link to Jet add-in cannot be broken"

Willem Broos

September 11, 2017 08:08

Answered

Follow

Hi All,

When generating a (rather large) report using JetScheduler, there is a problem getting it saved.
It used to work just fine until a few weeks ago, when suddenly this error message appeared.Our ICT-department is as puzzled as I am, so I hope somebody  in this Community can help me.
Is it a 'size'-problem that can be solved by reducing the amount of data, is it a security-problem? 
I'm hoping for clues so I don't have to run it manually again, as the report does take quite some time and computer-resource to run.

Thanks in advance!

Willem

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Harry Lewis September 11, 2017 14:06

  HI Willem -

  

• 0
  
  Willem Broos September 12, 2017 10:15

  Hi Harry,

  Thanks for your answer. It makes sense so I followed your lead and retested after removing the +VALUES from the sheets.
  It worked, so that was a relief but it would mean publishing a report with all Jet formulas which is not my favourite way to go. Besides, the report takes more than an hour to run so I decided it was time for a tweak.
  In the process of dissecting the report I copied a sheet to a blank workbook and ran it. Ready in 3 minutes. The next sheet took a little more time: 12 minutes ran separately. Next, I combined the 2 sheets I ran separately in one of the new workbooks and wow, now it only took about 25 minutes to complete the total report, and I didn't even have to remove the +VALUES from the sheets.

  Funny thing is that I had already experienced this before so I did something similar by opening a new workbook and just copying the sheets in it, but that didn't help. The difference now was that I copied the sheets separately, ran and saved them and combined them after that.
  Am I correct in assuming that Jet or Excel gathers all kinds of ballast in workbooks with Jet formulas which are being changed frequently, and that is a smart thing to do to  and just refresh a workbook by copying 'clean' sheets to a new workbook?

  Anyway, your answer helped me on the way and I'm happy with the result!

  Rgds,

  
  Willem

• 0
  
  Harry Lewis September 12, 2017 14:43

  Hello Willem -

  Depending upon your answer to my question, that was going to be my next suggestion.

  Under normal circumstances, the report should not "gather all kinds of ballast" (that's a great phrase, by the way).

  However, it is possible for some "hiccup" in the system to occur that then creates a cleanup issue for Excel. If that occurs, what you did is the perfect solution (it's usually possible to cleanup the existing file, but it's easier to create a new one).

  Nice work!