C
Chris D
In a workbook I'm building I use formulas which refer to worksheets which do
not all already exist( use it for calculating totals when worksheets are
inserted).
For explanation: this workbook is used for daily reporting, each day in the
project a worksheet is inserted, for day 1 the worksheet is named "1", for
day 2 "2" etc
I have 2 problems:
The formulas in the cells are not recognized as formulas, they do not
calculate cells. When I place cursor in the formula bar and give enter then
the formula is calculated.
In edit=> links I've set the " update links" to " don't update", this might
be the cause.
Second problem is that when I set cursor in a cell which has a formula that
refers to a worksheet that doesn't already exist, I get a popupscreen "
Update values".
I would like to know a macro in which I turn on the "automatic update
values", but when the the popupscreen " update values" appears, it
automatically selects "cancel".
If I could solve this than I can run the calculations for the worksheets
already in the workbook, and references to worksheets that don't exist are
then disregarded.
Would appreciate your help.
Thank you
not all already exist( use it for calculating totals when worksheets are
inserted).
For explanation: this workbook is used for daily reporting, each day in the
project a worksheet is inserted, for day 1 the worksheet is named "1", for
day 2 "2" etc
I have 2 problems:
The formulas in the cells are not recognized as formulas, they do not
calculate cells. When I place cursor in the formula bar and give enter then
the formula is calculated.
In edit=> links I've set the " update links" to " don't update", this might
be the cause.
Second problem is that when I set cursor in a cell which has a formula that
refers to a worksheet that doesn't already exist, I get a popupscreen "
Update values".
I would like to know a macro in which I turn on the "automatic update
values", but when the the popupscreen " update values" appears, it
automatically selects "cancel".
If I could solve this than I can run the calculations for the worksheets
already in the workbook, and references to worksheets that don't exist are
then disregarded.
Would appreciate your help.
Thank you