Hi Chris, Have you tried setting up another user account, opening excel and creating a new worksheet and trying in that. I would have thought that if that still gave you problems then it points to your version of excel (or possibly some conflict between excel and some particular software/hardware?) - A system wide problem, anyway.
On the other hand, if that is OK it would seem point to some personal Excel user setting or preference problem? Just a thought. Cheers Neil -- Neil R. Houghton Albany, Western Australia Tel: +61 8 9841 6063 Email: n...@possumology.com on 29/5/12 9:52 PM, Chris Burton at c...@it.net.au wrote: > Hi Ray > > This is really becoming perplexing now as I have loaded many other > spreadsheets, both with numbers, and text and tried without any success to get > the autocomplete to work. It just doesnt work any more in any sheets!!?? > > So I thought I would load up my previous version of Excel (Excel: Mac X) and > AutoComplete works perfectly, in the same spreadsheets as I had just tried. In > addition it works when there are more than one blank cell between other cells > with entries (only talking about columns here). > > Im really stumped now Ray. Must be something wrong with my version of excel, > or perhaps some other setting is interferring with the autocomplete!? > > Many thanks > > Chris > > > > On 29/05/2012, at 5:32 PM, Ray Forma wrote: > >> Chris, >> >> I have just tested my Excel 14.2.2 under MacOS 10.6.8, with AutoComplete >> ticked. >> >> Excel offers to AutoComplete only if one of the cells directly above has the >> same starting sequence. Note that a blank cell breaks the sequence. Try entry >> in any other cell and there is no offer to AutoComplete. >> >> I have plagiarised the following from elsewhere: >> >> Excel only tries to match your new entry with immediately adjacent cells >> above the one in which you are entering the information. It stops trying to >> match entries when a blank cell is reached. For instance, suppose you have >> information in cells A1 through A14 and A16 through A23. When you start >> typing an entry in cell A24, Excel only tries to match it with values in A16 >> through A23; the blank cell at A15 halts the comparisons. >> >> In addition, Excel does not try to match with cells that contain only >> numbers, dates, or times. The cells must contain either text or a combination >> of text and numbers. >> >> On 29/05/2012, at 5:12 PM, Chris Burton wrote: >> >>> 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 >> >> 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> -- 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>