S
strefry
Hello,
I have a workbook with a complex formula written in VBA that is part of
a circular reference. When the workbook is open, everything works
fine. But when I close the workbook and open it again, I get "#Value"
in the cells with the VBA formula and "#Name" in other cells part of
the circular reference.
I assume it is because there is nothing to start off the circular
reference (sort of a "primer") once the workbook is opened.
I have gotten around this by turning off auto calculation when I open
the workbook and then turning it back on as soon as the workbook is
open. But this is a pain for me to do everytime and even harder for me
to explain to others when I send my workbooks to them.
I know that I did not have to do this with older versions of Excel.
Does anybody know how I can fix this problem?
Thanks,
Scott
I have a workbook with a complex formula written in VBA that is part of
a circular reference. When the workbook is open, everything works
fine. But when I close the workbook and open it again, I get "#Value"
in the cells with the VBA formula and "#Name" in other cells part of
the circular reference.
I assume it is because there is nothing to start off the circular
reference (sort of a "primer") once the workbook is opened.
I have gotten around this by turning off auto calculation when I open
the workbook and then turning it back on as soon as the workbook is
open. But this is a pain for me to do everytime and even harder for me
to explain to others when I send my workbooks to them.
I know that I did not have to do this with older versions of Excel.
Does anybody know how I can fix this problem?
Thanks,
Scott