Services & Resources / Wolfram Forums
-----
 /
MathGroup Archive
2001
*January
*February
*March
*April
*May
*June
*July
*August
*September
*October
*November
*December
*Archive Index
*Ask about this page
*Print this page
*Give us feedback
*Sign up for the Wolfram Insider

MathGroup Archive 2001

[Date Index] [Thread Index] [Author Index]

Search the Archive

Re: Cause of $ErrorLink message in EXCEL/Mathematica

  • To: mathgroup at smc.vnet.net
  • Subject: [mg26684] Re: Cause of $ErrorLink message in EXCEL/Mathematica
  • From: Ulrich Hofstoetter <ulrich.hofstoetter at visualanalysis.com>
  • Date: Wed, 17 Jan 2001 00:47:33 -0500 (EST)
  • Organization: Visual Analysis
  • References: <93r7k4$4qg@smc.vnet.net>
  • Sender: owner-wri-mathgroup at wolfram.com

Todd in Oslo wrote:
> 
> Dear Colleagues,
> 
> I am testing my first model of an EXCEL spreadsheet linked to a
> Mathematica kernel using MathLink for EXCEL. The model works fine for a
> limited number of calculations, say about 4000 cells. But now I am
> experiencing the following problem:
> 
> The calculations of 6000 cells never gets more than 65% finished
> because the link between EXCEL and the Mathematica kernel seems to be
> broken, resulting in an error message for the rest of the 35% of the
> cells. The message in these cells is $LinkError.
> 
> What am I doing wrong, or what can I do to fix this?
> 

Do you use VBA?

Does an array exceed the array size limit set in the link options? This
should give an $ArrrayTooLarge, but who knows?

Do you try to get a list element by element in a loop of some kind? I
had this once and my problems went away by fetching the complete list.



-- 
Dipl.-Inf. Ulrich Hofstoetter
Visual Analysis GmbH
Neumarkter Str. 87
D - 81673 Munchen

Tel: (+49)89-431981-38
Fax: (+49)89-431981-1
e-mail: ulrich.hofstoetter at visualanalysis.com
www:	http://www.visualanalysis.com


  • Prev by Date: subprogramas as separate notebooks
  • Next by Date: Re: How can I transform the number of 123.456 into "123.456"?
  • Previous by thread: Cause of $ErrorLink message in EXCEL/Mathematica
  • Next by thread: erratum in OnLineHelp & TheBook