0

"Jet add-in could not be broken"

Jet Reports Historic Posts

October 04, 2013 03:24

None

Follow

I'm receiving an error on a report. The following messagebox pops up:

"The link to the Jet add-in could not be broken. Jet formulas may not be converted to values. The following error was reported:

Exception from HRESULT: 0x800A03EC"

Has anyone ever seen this error before.

After clicking OK, you can't even get back to design mode. Clicking the Design Button gives the following error:

"An unexpected error has occurred:
Delete method of Range class failed
System.Runtime.InteropServices.COMException
at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
at Microsoft.Office.Interop.Excel.Range.Delete(Object Shift)
at gg.m()
at q.c(String A_0, Int32, A_1, Int32 A_2)
at q.w()
at h9.k()
at a9.f(Boolean saveUserData)
at Jet.JetDispatcher.e(Boolean saveUserData)
at Jet.JetDispatcher.at()
at Jet.JetDispatcher.b(Object[] A_0)
at Jet.JetDispatcher.Dispath(Object[]& args)"

• Facebook
• Twitter
• LinkedIn

9 comments

• 0
  
  Jet Reports Historic Posts October 04, 2013 14:20

  Most likely this is a very large report and Excel is running out of memory. However, I would recommend creating a ticket with Jet Reports Support for this type of error.
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts October 04, 2013 17:40

  Thanks Hughes!
  
  I'm about to open the ticket. It will run successfully in Jet Essentials 2012, but not in 2013. I tried two different versions of 2013. But I will followup with Support. Thanks for the feedback.
  
  

  Most likely this is a very large report and Excel is running out of memory. However, I would recommend creating a ticket with Jet Reports Support for this type of error.
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts January 06, 2015 15:31

  Hi.
  
  Did you evet got this issue solved.
  
  I have the same issue now:
  "The link to the Jet add-in could not be broken. Jet formulas may not be converted to values. The following error was reported:
  Exception from HRESULT: 0x800A03EC"
  
  Best regards.
  
  Allan Jørgensen

• 0
  
  Jet Reports Historic Posts January 06, 2015 22:34

  As a designer, try running the report with just Auto+Hide in cell A1 and see if you still get the same result.
  
  How big is your report? Can you make it smaller by using a smaller sample size of data?

• 0
  
  Peggy Aitken April 12, 2018 04:22

  Did you ever get a resolution to this error?  I'm getting the same error.  Hope you can shed some light.

   

  Thanks!

  Peggy

   

• 0
  
  Harry Lewis April 12, 2018 15:13

  Hi Peggy -

  When +VALUES is specified in cell A1, during the last phase of running a report, the Jet add-in instructs Excel to create a copy of each page of the report to save the Jet functions which are subsequently removed from the displayed pages.

  The error would indicate that the report has gotten too large for Excel to do this (it's running out of memory).

  Try removing the +VALUES from cell A1 of each sheet of your report (so that cell A1 simply contains AUTO+HIDE) and then re-test.

  If that doesn't resolve the issue, I would suggest submitting a support request.

• 0
  
  Pierre-Elian JACQUET March 20, 2019 15:23

  Hello,

   

  I have the same problem on a report with a sort by sum of amount. There is just one sheet on my file.

  I just want to load one list with 50 items from 0€ to 1000€ of revenue by a month.

   

  I execute my report without the +VALUES as u said, but there is always a problem.

  This is the message in the pop-up when i try to execute my file.

  "An unexpected error has occurred:
  La référence d'objet n'est pas définie à une instance d'un objet.
  System.NullReferenceException
  à f.a(JetRange A_0, f A_1, dq A_2, Int32 A_3, a& A_4)
  à f.a(dt A_0, JetRange A_1, f A_2, Int32& A_3)
  à f.a(JetRange A_0, String A_1, dt A_2, JetRange A_3, f& A_4)
  à e.a(JetRange A_0, String A_1, dt A_2, JetRange A_3, List`1 A_4)
  à e.a(JetRange A_0, List`1 A_1)
  à e.i()
  à g.a(dj A_0, String A_1, Boolean A_2)
  à g.a(Boolean breakLinks)
  à g.a(Boolean A_0, Boolean A_1, Boolean A_2, Boolean A_3, Boolean A_4, Boolean& A_5)
  à g.a(Boolean A_0, Boolean A_1, Boolean A_2, Boolean& A_3)
  à g.a(Boolean A_0, Boolean A_1, Boolean A_2, Boolean A_3, Boolean A_4)
  à Jet.ExcelDnaFunctions.<>c__DisplayClass15_0.<JetMenu>b__0()
  à Jet.ExcelDnaFunctions.Execute(Action action)"

   

  And next, before coming back to the conception mode, i can see the column A and the row 1, it's really strange. In the cell A1, there is : Auto+Cacher+Formulas=Feuil5,Feuil6

   

  Please can someone help me ? 

   

  Thx

  PEJ

  Edited by Pierre-Elian JACQUET March 20, 2019 15:25
• 0
  
  Harry Lewis March 20, 2019 16:01

  Hello Pierre-Elian.

  When +VALUES is used, Excel makes secure backup copies of the worksheets when the report is run.  These backups are then restored the report is returned to Design mode.

  What you mention indicates that something has interfered with that process.  Since the solution involves some manipulation of your original file, I would suggest submitting this to Jet Global Tech Support so that they can assist you.

• 0
  
  Pierre-Elian JACQUET March 20, 2019 16:16

  Hello Harry,

   

  Thanks for your quickly answer. I have ever submitted this to Jet Global Tech Support with the email support@... 

   

  I hope to you (Jet Global) will solved my problem ...