Excel Formula Bar

[Super6point5]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

With Mac you need to see the left hand side of the formula bar to be able to move it on screen. My formula bar has moved to the extreme left hand side of the screen and although I can extend its length from right hand edge I cannot reposition the bar. Please help?

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

With Mac you need to see the left hand side of the formula bar to be able to
move it on screen. My formula bar has moved to the extreme left hand side of
the screen and although I can extend its length from right hand edge I cannot
reposition the bar. Please help?

You could, with XL closed, delete the preference file, or you could run
this script:

tell application "Microsoft Excel"
tell command bar "Formula Bar"
set bar position to bar floating
set left position to 100
set top to 100
end tell
end tell

 

[jips]

Hi, I have a similar problem with the Formula bar - Except I can not see it at all. Even after selecting it, No Show. This is with Excel 2008 and on a Mac OS 10.5 with a intel processor.
Do I use the script (if so, how do I do that) or is there something else to try.

 

[JE McGimpsey]

Hi, I have a similar problem with the Formula bar - Except I can not see it
at all. Even after selecting it, No Show. This is with Excel 2008 and on a
Mac OS 10.5 with a intel processor.
Do I use the script (if so, how do I do that) or is there something else to
try.

Well, you could try the preference file route that I mentioned...

Or you could open Script Editor, paste the script into the script window
and click Run

 

[SuperSixPoint5]

You could, with XL closed, delete the preference file, or you could run
this script:

tell application "Microsoft Excel"
tell command bar "Formula Bar"
set bar position to bar floating
set left position to 100
set top to 100
end tell
end tell
How do I find the preference file please?

 

[SuperSixPoint5]

Alternatively please tell me how to run the suggested script please?

 

[JE McGimpsey]

How do I find the preference file please?

[/QUOTE]

~:Library:com.microsoft.Excel.plist

where ~ is your home directory

 

[JE McGimpsey]

Alternatively please tell me how to run the suggested script please?

Paste it into a Script Editor application window

 

[SuperSixPoint5]

~:Library:com.microsoft.Excel.plist

where ~ is your home directory
[/QUOTE]
Sorry I had to say it was not helpful because I am not a GINK and the only
way I could add to the reply was to say no. Firstly let me ask about your
running the script answer. I do not know what you mean by a Script Editor
application window. Can you please expand how this is done on Mac please?
Secondly I have opened FINDER but I cannot locate the .plist stlll from your
description. Please help because I am convinced your answers will both work
but I still do not know how to use what you are saying.

 

[JE McGimpsey]

Sorry I had to say it was not helpful because I am not a GINK and the only
way I could add to the reply was to say no. Firstly let me ask about your
running the script answer. I do not know what you mean by a Script Editor
application window. Can you please expand how this is done on Mac please?
Secondly I have opened FINDER but I cannot locate the .plist stlll from your
description. Please help because I am convinced your answers will both work
but I still do not know how to use what you are saying.

I copied and pasted a partial answer.

Preferences:

0) Make sure XL is closed.
1) Open a Finder window to your home directory
2) Select/open the Library folder
3) Select/open the Preferences folder
4) Delete the com.microsoft.Excel.plist file.


AppleScript:

0) Open the Script Editor application (found in your main Applications
folder, or use Spotlight to find it).
1) In the "Untitled" window that opens, paste the Applescript I gave.
3) Click "Run".
4) If desired, save the script for future use.

 

[SuperSixPoint5]

I have to say that I used your preference solution and it worked first time.
Excellent all the frustration is now behind me. I could not get that answer
out of my local Apple shop although the assistant did know the file to delete
he could not find it. Your instructions are excellent and lets hope Apple and
Microsoft in particular also read these articles and perhaps take notice and
resolve the bugs for users.

Thanks again

 

[lukeyoung]

dear sir, i have the same problem and try to locate the "com.microsoft.Excel.plist", but this file is not in the Preferences folder. How can that be possible?

Please help!

Thanks.

 

[lukeyoung]

Oh, I got it. It's my user's Preference folder. Thanks a lot!