Office 2010

How to enable a disabled add-in in Excel 2010

December 27, 2014 by Admin 9 Comments

Office products such as Word, Excel Outlook will automatically disable installed add-in if any add-in prevented the software from functioning correctly. And it also provides option for enabling the disabled add-in items. In Excel 2010 you can enable a disabled add-in using the add-in options.

Click the File menu –> Options link –> Navigate to Add-Ins options.

Select Disabled Items in the Manage dropdown and click the Go button. This would display the following Disabled Items window using which you can see and also re-enable the disabled add-in. You can select the ones you wish to re-enable and click the Enable button.

How to enable or disable multi threading feature in Excel

September 9, 2014 by Admin 1 Comment

Microsoft Excel 2010 has a multi threading feature which when enabled reduces the time taken for complex calculation or Formulas. And you can enable this feature when your computer supports multi processing capabilities. Listed below are the steps to enable or disable multi threading feature in Excel 2013 and Excel 2010

Step 1: Click File menu and select Options from the list.

Step 2: In the Options window, click Advanced tab and scroll down to Formulas section.

Step 3: Now you can enable or disable multi threading feature by using the checkbox with label Enable multi-threaded calculation. This also provides option for specifying the number of processor that has to be used for the calculation. By this way Excel users can turn on or off multi threading feature.

Also See: How to turn off auto calculation in Excel 2010

How to make a workbook read only in Excel

September 8, 2014 by Admin 40 Comments

We have already seen how to How to make a presentation read only in Power Point. Similarly an excel workbook can be made read only using Excel Options. Listed below are the steps to make a workbook read only in Excel 2013 and Excel 2010

Click on the File menu –> Info menu

Click on the Protect Workbook drop down arrow. This would display the following menu list

Click on the Mark as Final menu, the following dialog box would appear.

On selecting OK button the following confirmation box will be displayed.

By this way you can make an workbook in excel 2010 read only and prevent users from making any changes to the file.

Also See: Different ways to protect workbook in Excel 2013