re-associate function to worksheet

ocluett

New Member
Joined
Jan 25, 2005
Messages
10
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.
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

ocluett

New Member
Joined
Jan 25, 2005
Messages
10
Forgot to mention, I have tried hitting F9, CTRL+ALT+F9.. neither works.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,069
Messages
5,570,008
Members
412,304
Latest member
citrus
Top