#N/A errors with iteration,dynamic feeds

[RPD]

I have the iteration box checked to enable the use of my formula which involves a circular reference. One field the formula references is a dynamic stock feed. The formula works great, however when I close my workbook and open it back up there is an #N/A error in the fields with my formula. If I double click on the cells and hit enter I guess it re-ups the formula and it works again. The error stems from the fact I'm using a dynamic data feed and a circular reference allowed through iteration. Is there any way to avoid clicking on every formula cell each time I open the sheets? Thanks very much for the help.

 

[patrickmuldoon99]

in the workbook open event, you can try putting

application.calculate

HTH