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