There are many versions of Excel which are still being used by different users. This article with shows how to enable Smart Tags in the following versions:
Excel 2016 (Also covers 2010 and 2013)
Excel 2007
Excel 2016
Open Excel on the computer required.
In the top left, on the File tab, at the bottom, click Options. The Excel Options window appears.
On the left, click Proofing.
Click AutoCorrect Options. The AutoCorrect... window appears.
On the Smart Tags tab, in the Recognizers section, select all the check boxes which being with Access - ... (e.g. Access β Customers)
Click OK.
Close Excel.
Open Excel to enable the new settings.
Try to put in a Supplier, Customer or Stock code.
Excel 2007
Open Excel on the computer required.
In the top left, click Microsoft Office.
In the bottom left, click Excel Options. The Excel Options window appears.
On the left, click Proofing.
Click AutoCorrect Options. The AutoCorrect... window appears.
On the Smart Tags tab, in the Recognizers section, select all the check boxes which being with Access - ... (e.g. Access β Customers)
Click OK.
Close Excel.
Open Excel to enable the new settings.
Try to put in a Supplier, Customer or Stock code.
