cells don't recognize formula

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top