I have a lot of excel workbook that follows a template. Since each workbook has a lot of sheets. I usually just use the equal formula to refer to the heading of the first sheet for the succeeding sheets. (e.g. the title of the document, number of the document.)
The problem is I notice that when I insert a new formula, the cells format becomes a number again which does not evaluate the formula. Also even if I use Ctrl+F9, the formula does not work. Even If i change the format of the cells to General.
Sample Formulat is Sheet1!A2