Auto Calculating vs. Macros

June 8, 2009 at 10:15:25
Specs: Windows Vista
Can someone please explain the difference between the two? I feel as though they are the same.

Very Confused

See More: Auto Calculating vs. Macros

Report •

June 8, 2009 at 11:03:24
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.

Auto Calculating

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.

Report •
Related Solutions

Ask Question