Knowledge Base

XL7: AutoCalculate Not Available on Macro Sheet

PSS ID Number: 133415

Article Last Modified on 10/23/2000


The information in this article applies to:


This article was previously published under Q133415

SUMMARY

The AutoCalculate feature is not available in a Microsoft Excel 4.0 macro sheet. This behavior is by design.

MORE INFORMATION

With Autocalculate, you do not need to use a calculator or enter temporary formulas on a worksheet when you want to quickly check a total. Now you can just select the range you want to sum, and the answer will appear in the status bar at the bottom of the screen. You can also average the selected numbers or count the entries by clicking the AutoCalculate area in the status bar with the right mouse button.

Keywords: KB133415
Technology: kbExcel95 kbExcel95Search kbExcelSearch kbExcelWinSearch