Maybe autocomplete isn't enabled in Excel?
Here are instructions for enabling/disabling autocomplete
http://spreadsheets.about.com/od/exceltips/qt/090622_autocomplete.htm
Turn AutoComplete On or Off in Excel 2010 / 2013
By default, AutoComplete is turned on in Excel. These steps will
first show you how to turn it off.
* Click on the File tab of the ribbon to open the File menu
* Click on Options to bring up the Excel Options
<http://spreadsheets.about.com/od/glossary/g/90304_dialogbox.htm>dialog box
* Click on the Advanced button in the left hand pane
* Under the Editing Options section
* Click on the Enable AutoComplete for cell values option box to
remove the checkmark
* Click OK
* AutoComplete should now be disabled
* To re-enable AutoComplete, re-check the option box
Turn AutoComplete On or Off in Excel 2007
For help with these steps, see the image above.
* Click on
<http://spreadsheets.about.com/od/no/g/office_button.htm>Office
Button > Excel Options to bring up the Excel Options
<http://spreadsheets.about.com/od/glossary/g/90304_dialogbox.htm>dialog box
* Click on the Advanced button in the left hand pane
* Remove the checkmark from the Enable AutoComplete for cell
values option box
* Click OK
* AutoComplete should now be disabled
* To re-enable AutoComplete, re-check the option
_______________________________________________
Jfw mailing list
[email protected]
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com