Hi Ray Thanks so much for your persistence on this. I just updated to 14.2.2 and I am on a Mac Book Pro with 10.6.8. I then restarted the machine and repaired permissions.
Still No luck. I also typed in known names that were just above the cell and it didnt recognise the letters. I did some searching and it seems that others have had similar problems for quite a while with no solution I could find. Not sure what to do now Ray Many thanks Chris On 29/05/2012, at 4:32 PM, Ray Forma wrote: > Chris, > > I stupidly forgot to do what I always tell others to do; include version > numbers etc. > > I use Excel 14.2.2 under MacOS 10.6.8 > > That version of Excel, with the appropriate preference set, happily offers to > AutoComplete data I'm entering in a cell as long as there is another cell > somewhere in the sheet that has the same starting character sequence. > > I therefore suggest you update to the current version 14.2.2 and then keep > your fingers crossed. > > On 29/05/2012, at 2:26 PM, Chris Burton wrote: > >> Hi Ray and Ronni >> >> Thanks for your suggestions. Ronnie I dont think it is solver but more like >> that which Ray has offered. >> >> However I already to have that box checked in the AutoComplete section. I >> Ray reloaded Excel and in the file which I have been using, typing in names >> for which I know there are several above in the column: there is no auto >> complete happening. >> >> I remember, it provides a list to choose from. This seems really weird as it >> was working perfectly a few weeks ago. >> >> One thing Im concerned is that it changed when I did the Office 2011 update >> about a month ago. >> I have just checked again and there is another update to 14.2.2. Not sure if >> I should do this one now, but it may address this problem? Anyone know about >> it? >> >> I will also do a search for any discussion about this in Excel >> >> Many thanks for your help >> >> Kind regards >> >> Chris >> >> >> On 29/05/2012, at 1:55 PM, Ray Forma wrote: >> >>> Chris, >>> >>> Excel > Preferences…; then AutoComplete and tick Enable AutoComplete for >>> cell values. >>> >>> On 29/05/2012, at 12:11 PM, Chris Burton wrote: >>> >>>> Hi everyone >>>> >>>> I have just noticed that while using Excel (2011 V 14.1.4), it no longer >>>> pre-empts (not sure what the appropriate word is here) my cell entry with >>>> those of previous cells above. The program used to do this all the time >>>> which did help with data entry. >>>> >>>> I have checked through preferences several times thinking it must be in >>>> there somewhere, but to no avail! I can see AutoComplete and this box is >>>> ticked. AutoCorrect is also present with boxes ticked. >>>> Do I need to restart or something? >>>> >>>> Can someone please let me know how to switch this back on? >>>> >>>> >>>> Many thanks for any help >>>> >>>> Chris >>>> >>>> >>>> >>>> Christopher L.K. Burton >>>> Director >>>> Western Whale Research >>>> PO Box 1076 >>>> Dunsborough WA 6281 >>>> Mobile: 0419 199 120 >>>> Email: [email protected] > > Regards, > > Ray Forma > Mob +61 (0) 428 596938 > > -- The WA Macintosh User Group Mailing List -- > Archives - <http://www.wamug.org.au/mailinglist/archives.shtml> > Guidelines - <http://www.wamug.org.au/mailinglist/guidelines.shtml> > Settings & Unsubscribe - > <http://lists.wamug.org.au/listinfo/wamug.org.au-wamug> -- The WA Macintosh User Group Mailing List -- Archives - <http://www.wamug.org.au/mailinglist/archives.shtml> Guidelines - <http://www.wamug.org.au/mailinglist/guidelines.shtml> Settings & Unsubscribe - <http://lists.wamug.org.au/listinfo/wamug.org.au-wamug>
