Circular References, what a nightmare.
 

Hi

I have an excel spreadsheet which through no fault of my own, and
dictated by business logic alone, forces me to employ circular
references.

I've gone to the lengths of writing data to a file to try and escape
the situation but now sometimes, my xls starts fine, sometimes it
doesnt'.

Sometimes Excel crashes on startup and I have to disable macros.

The funny thing is the spreadsheet works fine aok when I cobble the
sheet back to together with all the circular references. The problem
is it breaks everytime i open it and I'd like to distribute the file
but it's highly annoying to have end users to have to reset fields
with references AFTER they open the file.

Any suggestions any one??? :(
Timothy

Circular References, what a nightmare.
 

I take it one of your overheads is actually a function of the Sell Price?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



"Timothy" wrote in message
om...
Hi

I have an excel spreadsheet which through no fault of my own, and
dictated by business logic alone, forces me to employ circular
references.

I've gone to the lengths of writing data to a file to try and escape
the situation but now sometimes, my xls starts fine, sometimes it
doesnt'.

Sometimes Excel crashes on startup and I have to disable macros.

The funny thing is the spreadsheet works fine aok when I cobble the
sheet back to together with all the circular references. The problem
is it breaks everytime i open it and I'd like to distribute the file
but it's highly annoying to have end users to have to reset fields
with references AFTER they open the file.

Any suggestions any one??? :(
Timothy



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.532 / Virus Database: 326 - Release Date: 27/10/2003

Circular References, what a nightmare.
 

Thanks for the Reply, however where do I put the code, I'm having
trouble finding the Activate Event Location for my workbook.

Thanks

Timothy Marks


"luda" wrote in message ...
try to use the Activate event of
ThisWorkbook event collection and
put in the following code:

Private Sub Workbook_Activate()
With Application
.Iteration = True
.MaxChange = 0.001
End With
ActiveWorkbook.PrecisionAsDisplayed = False
End Sub

It will turn the iteration on automatically once the file
is opened in Excel.
The only "inconvenience" may now be for the end-user to
set their security levels to mid or high to allow the code
to be run. No automatic security change is available from
ms, sorry. They have to do it by hand.
Good luck,
Luda




-----Original Message-----
Hi

I have an excel spreadsheet which through no fault of my
own, and
dictated by business logic alone, forces me to employ
circular
references.

I've gone to the lengths of writing data to a file to try
and escape
the situation but now sometimes, my xls starts fine,
sometimes it
doesnt'.

Sometimes Excel crashes on startup and I have to disable
macros.

The funny thing is the spreadsheet works fine aok when I
cobble the
sheet back to together with all the circular references.
The problem
is it breaks everytime i open it and I'd like to
distribute the file
but it's highly annoying to have end users to have to
reset fields
with references AFTER they open the file.

Any suggestions any one??? :(
Timothy

.

Circular References, what a nightmare.
 

Right-click on the title bar of the workbook and choose View Code.
paste the macro into the ThisWorkbook code module which opens.

In article ,
(Timothy) wrote:

Thanks for the Reply, however where do I put the code, I'm having
trouble finding the Activate Event Location for my workbook.