I have created a template in excel in which I have used circular reference
feature of excel. However when this template is opened first time it gives
circular reference warning error. Once I go in option and set iteration
checkbox and save the template , next time when I open this template it won't
give the error. Suggest me some solution in order not to get this warning
first time when I open the template. I tried putting the following macro code
still it is showing the error.
public wbk_open()
Application.iteration = true
end sub

Calculation occurs before macros I believe. the calculation settings are
established at application level by the first workbook opened (such as
personal.xls). So I don't see an easy solution for this.

--
Regards,
Tom Ogilvy


"Nitin Mahadar" <Nitin wrote in message
...
I have created a template in excel in which I have used circular reference
feature of excel. However when this template is opened first time it gives
circular reference warning error. Once I go in option and set iteration
checkbox and save the template , next time when I open this template it
won't
give the error. Suggest me some solution in order not to get this warning
first time when I open the template. I tried putting the following macro
code
still it is showing the error.
public wbk_open()
Application.iteration = true
end sub