copying/pasting cells not working

When I copy a formula and paste it into another cell it is correctly showing the new cell, however, the answer to the formula is not correct. It is just showing the answer from the originally copied cell.

It happens whether I use the pull down method or copy and paste. It is making me re-enter each formula manually in order to get a correct response.

Any thoughts on why this would happen?

It sounds like you've got the Excel Calculation mode set to Manual.
This often happens if the first workbook you open in a new Excel session was saved from an Excel session which was already in manual. The calc mode persists even when you close the first workbook.

Go to Tools Preferences and check the calculation state.

HTH