Jun 30 2022 07:32 AM
Formulas copied and pasted into new cells do not yield results at all (see cell E8):
or are not calculating automatically based upon what should be the new reference cells unless the cursor is put at the end of the formula in the formula bar and one hits enter
Jun 30 2022 08:32 AM
Activate the Formulas tab of the ribbon.
Make sure that Calculation Options in the Calculation group is set to Automatic.
Also make sure that there is no message "Circular References" in the status bar at the bottom of the Excel window.
Jun 11 2023 07:11 PM
Jun 30 2022 09:34 AM
Solution