B
Brad
I am an experienced user of Excel but have recently built
a large workbook containing many spreadsheets (60). Many
of the worksheets containg refrence cells to other
worksheets and I have noticed that the file does not
calculate and update the cells. This is not a case of
having turned off the the autocalc function in the options
menu or anything related to a circular reference. The
only way that I can force the file to calc is to pick up
and move a worksheet from one place in the file to
another. Please note that the worksheet I am moving, and
it could be one of several, are not linked in any way to
the other sheets. Any thought anyone has would be
appreciatted.
a large workbook containing many spreadsheets (60). Many
of the worksheets containg refrence cells to other
worksheets and I have noticed that the file does not
calculate and update the cells. This is not a case of
having turned off the the autocalc function in the options
menu or anything related to a circular reference. The
only way that I can force the file to calc is to pick up
and move a worksheet from one place in the file to
another. Please note that the worksheet I am moving, and
it could be one of several, are not linked in any way to
the other sheets. Any thought anyone has would be
appreciatted.