I am preparing a worksheet, and entering formulas that are referenced to worksheets that haven't been created yet. As data becomes available, new worksheets will be created and named with a proper naming convention. My problem is that although the formula is correct, after the new sheet is created my value shows REF. By simply making the formula active (not changing anything) and hitting enter, it evaluates itself and works. Is there a way to apply this to an entire sheet of formulas, without the tedious task of going cell by cell? Thanks to anyone who can help or offer a suggestion.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
re-associate function to worksheet
- Thread starter ocluett
- Start date
Similar threads
- Solved
