As far as I know, the only way to show firmulas instead of values is to use Ctrl + ` otherwise known as the grave accent on the key to the left of the number 1 key. There might be a way to call this in a Workbook Open Event if you want the same file to always show the formulas when it opens.