Autofill not working

[isidey]

Since changing to the Mac, I have been unable to get the autofill
feature to work with lists. I checked the help page on autofill
troubleshooting, and seem to have the right techniques as listed there.
I am using OS X 10.3.8, Office for Mac 2004 v11.1. The original
spreadsheet was created using a Windows version of Excel a recent
version, but I no longer have the details. Any ideas would be much
appreciated.

 

[CyberTaz]

Have you looked in Excel>Preferences to make sure the feature is
enabled? |:>)

 

[isidey]

Have you looked in Excel>Preferences to make sure the feature is
enabled? |:>)

 

[isidey]

CyberTaz - Good question, but yes, I have enabled autofill in
preferences!

 

[CyberTaz]

Three other thoughts:

You might try Trashing Excel's Preferences file (while the program is
not running),

Did you use Disk Utility to Repai Disk Permissions after installing?,

Do you have the latest Office update (I believe it is now 11.1)?

Hope this is helpful |:>)

 

[J Laroche]

Since changing to the Mac, I have been unable to get the autofill
feature to work with lists. I checked the help page on autofill
troubleshooting, and seem to have the right techniques as listed there.
I am using OS X 10.3.8, Office for Mac 2004 v11.1. The original
spreadsheet was created using a Windows version of Excel a recent
version, but I no longer have the details. Any ideas would be much
appreciated.

To help with troubleshooting, can you describe an example of list you want
to auto-fill, the starting data, what you expect, what you get and how you
do it. These seem like very basic questions but often very basic details
block the operation.

JL
Mac OS X 10.3.8, Office v.X 10.1.6

 

[isidey]

Thanks, Cybertaz and J Laroche. I'm travelling this week, will try
Cybertaz's suggestions next week when I return, and will advise results
then.

 

[isidey]

OK, so I finally got to this today.

(1) I am using Office for Mac v11.1
(2) I never repaired permissions - I'm a newbie to Mac. I did it today,
and tried Excel - still the same autofil not working problem.
Incidentally wh/when does one normally repair permissions?
(3) I identified a file:-

Users/myuserID/library/Preferences/Microsoft/com.microsoft.excel.prefs.plist

Is this the file to trash? As a newbie, trashing that sort of thing
makes me nervous.What exactly does it do when one trashes it - does it
regenerate a new one when one opens excel next time?

I appreciate your assistance on this.

 

[Michael R Middleton]

Just to be sure we're talking about the same "autofill" feature:

Excel | Preferences | Edit | Allow cell drag and drop

Is that what you have enabled?

- Mike
www.mikemiddleton.com

 

[isidey]

Good catch, Mike. I've been using the wrong word. It is
Preferences...Edit...Enable Autocomplete for Cell values that I am
talking about. Sorry.

 

[CyberTaz]

Hi is-

Welcome back!

Now that we're focused on the appropriate feature, can you be a bit more
specific on exactly what you are expecting and what is/is not happening
instead? |:>)

Good catch, Mike. I've been using the wrong word. It is
Preferences...Edit...Enable Autocomplete for Cell values that I am
talking about. Sorry.

-- (e-mail address removed)

 

[CyberTaz]

Suggestions for Repairing Disk Permissions:

Anytime you install/uninstall software
Anytime you install OS or program updates
Anytime you experience "irregularities" especially if it involves programs
not launching or docs not opening or programs 'ask' to be allowed to do
something (other than standard confirmations for deleting files, saving
changes, etc.)
Some say you should run before & after, but after is a definite.

You may also want to visit Apple Discussions at

http://discussions.info.apple.com/

For more Mac-specific information

God Luck |:>)

OK, so I finally got to this today.

(1) I am using Office for Mac v11.1
(2) I never repaired permissions - I'm a newbie to Mac. I did it today,
and tried Excel - still the same autofil not working problem.
Incidentally wh/when does one normally repair permissions?
(3) I identified a file:-

Users/myuserID/library/Preferences/Microsoft/com.microsoft.excel.prefs.plist

Is this the file to trash? As a newbie, trashing that sort of thing
makes me nervous.What exactly does it do when one trashes it - does it
regenerate a new one when one opens excel next time?

I appreciate your assistance on this.

-- (e-mail address removed)

 

[isidey]

Hi CyberTaz,

Thanks for the info on repairing disk permissions.

OK, what I want to do, and what I could do in Excel for Windows, is to
build a list in a column, such as Alpha, Bravo, Charlie, Delta. Then in
the next cell in the column, if I started typing "Bravo", after typing
"B", the progam would automatically fill in the rest of the "ravo", and
I could enter it by hitting return. I can't get this to work for me in
Office for Mac v11.1

 

[David southwick]

It does work a little different now. When you start typing and the choices
show up, you have to select the choice you want. I use the arrow keys for
this.
dave

 

[J Laroche]

Simple question, but is the cell where you want AutoComplete to work
contiguous with the source list? A single blank cell in-between will disable
AutoComplete. I know you wrote "in the next cell", but just in case...

JL
Mac OS X 10.3.8, Office v.X 10.1.6



David southwick wrote on 2005/03/16 10:39:

 

[isidey]

Dave, It would be fine if "choices show up", but they don't! Any
advice? Remember that I have set preferences so it is supposed to do
this.

And JL - Yes, the cells are contiguous rows, same column.

IS

 

[David southwick]

IS
Been away and wondering how you made out. Sorry but I have no new ideas
.....Wait...OK I'm back. Just had a hunch and went to try it. Make sure you
have "edit directly in cell" enabled too. I disabled it on my machine and
the auto complete feature quit working.
Dave