From: hurley@epcot.spdc.ti.com (Brian Hurley)
Subject: Re: Forest & Trees linking to Excel --- PROBLEM 
Organization: TI Semiconductor Process and Design Center
Date: Tue, 6 Oct 1992 11:47:20 GMT

> 
> In article <1992Oct4.110812.6133@spdc.ti.com>, you write:
> >
> >I'm creating a series of spreadsheets by linking data from a SQL database
> >through Forest & Trees v2.0d.   I have the Views done and am working on the
> >Excel 3.0  spreadsheet.  Whenever I put two or more DDE links from a
> >spreadsheet to F&T save/load/save then try to re-load the second time I get a
> >UAE in EXCEL.  But, while I have it in memory and have not saved it yet
> >it works fine.  All the links work, and everything seems fine.  Until I save
> >it, then try to re-load.  
> >
> >I've tried this on different computers with the Excel 3 and Excel 4, Windows
> >3.0 and 3.1.   I don't know what else to try.  
> >
> >Where should I look for the problem.  Forest & Trees or Excel.
> >
> >
> >This is very frustrating having to re-create the sheet each time.  I hope that
> >someone will have a answer...
> 
> 	Sounds like one of the linked files has some problem (probably).
> 
> 	I'd check the following:
> 
> 	If there is enough memory to hold the things, use as less link
> 	as possible.
> 

I'm using F&T to update from SQL database.  I don't think there is a way to
get updated info into excel with out using another program to poll the
database.   If I'm wrong let me know...


> 	If that isn't a convenient route then you may use Norton's
> 	utility (or something like that) to test the files for any
> 	reading error. (If you use dt, use it with /M switch).

Files are fine,  I checked them with norton....

> 
> 	If the problem persists, try to unlink one file at a time and
> 	repeat the process.

Maybe I need to clarify...

I getting info from a database with Forest & Trees.  

Create a spreadsheet in excel that contains mulitple templates of another
sheet.  In this sheet I paste the link from f&t. ( from a different VIEW in
different areas of excel.)  This all works UNTIL I save the darn thing... 

When I go to reopen the thing ( IF I HAVE MORE THAN ONE LINK IN THE
SPREADSHEET)  it gives a general protection fault and dies....   The GPF
happens at about the place that the second sheet would be.  IE: If I have two
sheets inside the one worksheet it gives the GPF at about 49% loaded, If I
have 10 sheets in the one I get the error at about 10-20% loaded.

The worst part about the whole thing is that the work that has been done is 
gone.


> 
> 	These are only some possibitities.

PLEASE, PLEASE give me some more.  The Boss wants the done by Oct 31, and at
this rate I'll never make it...

-- 
----------------------------------------------------------------------------
| Brian Hurley                | Internet: hurley@spdc.ti.com               |
|                             |     RIME: Brian Hurley  ->BREADBRD         |
----------------------------------------------------------------------------

-- 
----------------------------------------------------------------------------
| Brian Hurley                    |   Internet: hurley@spdc.ti.com         |
|                                 |       RIME: Brian Hurley ->BREADBRD    |
----------------------------------------------------------------------------