Capacity Column Not Calculating After 2nd Daily Inventory Is Entered / Help

[izgetsmail]

When the 5AM numbers are entered into the Inventory tab, the Capacity column calculates properly on the Spreadsheet tab. Yet when the 9AM numbers are entered, the Capacity column do not seem to calculate at all.

Could someone please help me correct this problem? Please indicate, specifically, where the problem is so that I can make the proper corrections on additional worksheets that share these formulas.

Thank you!!!!

[FlameRetired]

izgetsmail,

It works at my end. What column are you entering the data in 'Inventory'? I used column AP.

BTW you've uploaded an *.xlsx file yet your profile says Excel 2003. Please update your profile.
Forum members key on things like location and Excel version(s) when proposing solutions. It helps us help you.

[izgetsmail]

Try entering data into the 9AM section in the Inventory tab. The Capacity column in the Spreadsheet tab will not calculate.

[FlameRetired]

That is what I did. Column AP is under the 9AM section heading.

Edit By any chance are calculations set to "Manual"?