View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
turbosteve turbosteve is offline
external usenet poster
 
Posts: 1
Default How do you initialize the values in a circular reference?

With complex calculations that require a circular reference, you can have an
error when you open the spreadsheet. It can be fixed by replacing a key value
in the reference to get the calculation going, then put the real calcuation
back in. This is cumbersome--how can you provide a way for the circular
reference calculations to start?