I have a workbook for employee time sheets. There are approximately 20 separate sheets in the workbook with cells linked to a master crew sheet. All of the formulas that tie specific cells to the master crew sheet are showing in the cells but are not functioning. If i navigate to one of the cells that contain a formula and click into the formula bar and then press enter the formula works. I have scanned through all macros in the workbook and nothing seems to be tied to this problem. Has anyone here encountered a similar issue? If so, any suggestions on how to fix?