|If you feel as though they are the same then I may not be understanding your question because they are not even related to each other.|
There is a setting under Tools...Options...Calculations tab for setting Calculation to either Manual or Automatic. If it is set to Manual, you have to hit F9 (or use the Calc Now button on that tab) for the formulae in a worksheet to update when a change is made to the worksheet. If it is set to Automatic (the default), all formulae will recalculate as soon as a change is made in any cell. While there are certainly times when it is advantageous to set your spreadsheet to Manual calculation, the vast majority of times it will be set to Automatic.
A macro is a series of instructions written (or recorded) in VBA (Visual Basic for Applications) to cause Excel to perform tasks that cannot typically be done with Excel functions.
This site shows a number of short macros as examples.
Some macros contain hundreds of lines of code and may even call other macros as part of their operation.