View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ken Wright Ken Wright is offline
external usenet poster
 
Posts: 634
Default 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