formulas are in the cell but not functioning when the workbook is opened

theYaniac

New Member
Joined
Jan 7, 2018
Messages
34
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?
 

theYaniac

New Member
Joined
Jan 7, 2018
Messages
34
I found the issue. The auto calculate was turned off. I feel really stupid right now. Thanks anyway everyone.
 

Forum statistics

Threads
1,085,878
Messages
5,386,509
Members
402,003
Latest member
johnpearson67

Some videos you may like

This Week's Hot Topics

Top