Hi Brian, Neil, Ray and other muggers, Apologies for the delay on this I had to go the Perth and back yesterday.
I have finally been able to track down the culprits for the quirky nature of Excel and its' Preferences option, AutoComplete for not working!! After Ray had sent a new test file to me, that still didnt work on my machine, but did on Rays, I asked him to send me his preference settings so I could duplicate them. And guess what, it worked!! Since then I have backtracked and found something very unusual that seems to cause the fault: there appears to be a 'combination effect' from two preference options - Edit and AutoComplete: All tick boxes should be checked on under AutoComplete. All but the last two tick boxes should be checked on under Edit. If I turn off the top box under Edit (Double click allows editing) then hit Ok, the AutoComplete does not work!! I can then check this by going back into Excel Preferences to the AutoComplete option, and can see the top box is now un-ticked (Enable AutoComplete for cells)!!?? What the! I then tick this 'Enable AC' box and hit ok, and it still doesnt work. Back into preferences, check 'Double click' box under Edit then ok. Then AC works!! It seems that both boxes have to be checked on. That is weird and not sure if it is the same for others, but thought you may be interested in this result Many thanks to everyone for their time and offers of advice, I great appreciate it Kind regards Chris Christopher L.K. Burton Director Western Whale Research PO Box 1076 Dunsborough WA 6281 Mobile: 0419 199 120 Email: [email protected] On 30/05/2012, at 10:00 PM, Brian Risbey wrote: > Hi Chris, > > just checked Excel Version 14.2.2 (120421), bracketed numbers might mean > something, on a MacBookPro OSX 10.7.4: > I get auto-suggest/ autocomplete words but numbers don't work as I go down a > column. > As with Ray, miss a cell and it stops autocomplete, > I had all autocomplete preferences ticked. > > Also, between the lines, I have noticed some 'gremlins' and odd behaviours > since last Office update. > > Brian > > > > On 29/05/2012, at 9:52 PM, Chris Burton 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> -- 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>
