Circular References, what a nightmare.

  • Thread starter Thread starter Timothy
  • Start date Start date
T

Timothy

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
(e-mail address removed)
 
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
(e-mail address removed)
 
Right-click on the title bar of the workbook and choose View Code.
paste the macro into the ThisWorkbook code module which opens.
 
Back
Top