Is your Excel is additional Add-Ins that require you to select manual calculation? With this feature you can select the calculation you want. Is it only a range, entire sheet, a workbook, or even entire workbook?
The following options are available:
- Calculate Selected Range
- Calculate Active Sheet
- Calculate Active Workbook
- Calculate All Workbooks
Note:
If you chose the 3rd option, you will be asked which sheets that will be calculated as the following picture:
Nice share gan.,.,salam kenal,,gan mohon pencerahanya :
cara membuka formula di xls yg di protect ,,, di tunggu pencerahanya di edybilla@gmail.com