D
Daiv
I have put together an excel template for my office that uses circular
references. When i first opened it, it came up with the error pointing out
circular references and I needed to go into the calculation options and allow
the iterations. Then it worked fine.
My problem now is that if I save a file on my computer, and a coworker
tries to open it, they then get the circular reference problem again, even
though I can open it on my computer no problem. Once he saves it, I then
have the circular reference problem as well. and we go in "circles" with
this problem.
How can I make it so that it always allows the circular references no matter
who opens/saves the file?
Thank you!
references. When i first opened it, it came up with the error pointing out
circular references and I needed to go into the calculation options and allow
the iterations. Then it worked fine.
My problem now is that if I save a file on my computer, and a coworker
tries to open it, they then get the circular reference problem again, even
though I can open it on my computer no problem. Once he saves it, I then
have the circular reference problem as well. and we go in "circles" with
this problem.
How can I make it so that it always allows the circular references no matter
who opens/saves the file?
Thank you!