I have a file I have used successfully for 3 or 4 years. I am using Excel 2016. Now all or a sudden some formulas don't seem to recalc successfully. The suspect formulas are verifying that the sum of a lot of SUMIFS() formulas equals the total of the data that is being extracted selectively in the SUMIFS. The ONLY way I can seem to get them to recalculate is to hit F2 and then enter on those formulas. Quite annoying. Anyone have suggestions?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Recalculation Not Working
- Thread starter MikeDBMan
- Start date
-
- Tags
- formulas recalc successfully sumifs
steve the fish
Well-known Member
- Joined
- Oct 20, 2009
- Messages
- 8,894
- Office Version
- 365
- Platform
- Windows
Check the calculation mode.
Upvote
0
Similar threads
- Solved
- Question
