Results 1 to 12 of 12
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Save as Greyed Out (Excell 2002)

    Hi
    Can anyone help please my Save As tab has suddenly become greyed out , I am desperate to resovle this.

    Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Save as Greyed Out (Excell 2002)

    Braddy,
    Can you give some more info: like,
    Is the Save As command greyed out in all your workbooks, or only in a certain book?
    Is there any sort of protection on the workbook?
    Have you tried resetting your toolbars, or "rebooting" excel?
    At what moment did this happen; can you recall the last set of actions that might have caused this?

    If you can give some more detail, it will be easier to try solve!
    Regards,
    Rudi

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Save as Greyed Out (Excell 2002)

    Hi Rudi

    The Save As command is greyed out for everything, even if I open a new workbook.
    There is no protection on.
    How do you reset the toolbars?
    Unfortunately it seemed fine yesterday, I did open some protected work books this morning that's when I discovered the problem.
    I have rebooted the machine.

    Thanks
    Braddy
    If you are a fool at forty, you will always be a fool

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Save as Greyed Out (Excell 2002)

    I doubt that resetting toolbars would help, but you can try it:
    - Select Tools | Customize...
    - Activate the Toolbars tab.
    - Click on 'Worksheet Menu Bar' (on the name, not on the check box)
    - Click Reset... and confirm.
    - Close the Customize dialog.

    Take a look at Pieterse's <!post=Systematic Approach to Behavioral Problems in XL,290455>Systematic Approach to Behavioral Problems in XL<!/post>.

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Save as Greyed Out (Excell 2002)

    Hi Hans

    I tried what you suggest, but Tools / Customize is greyed out aswell.

    Thanks for your reply

    Braddy
    If you are a fool at forty, you will always be a fool

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Save as Greyed Out (Excell 2002)

    I would definitely look at Pieterse's post then.

  7. #7
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Save as Greyed Out (Excell 2002)

    Hi Hans

    I went to View / Toolbars / Customize and reset Worksheet Menu Bar and it did the trick.

    I will look at Pieterse's post aswell

    Thanks to all who helped with this problem.

    Braddy
    If you are a fool at forty, you will always be a fool

  8. #8
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Save as Greyed Out (Excell 2002)

    While this subject is active, could I ask a question?
    I recall reading a reply that <!profile=jscher2000>jscher2000<!/profile> posted about doing a clean restart of Word (obv. on the Word Board)! He mensioned something to the point of going to the office10 directory and double clicking on the word.exe file while holding down SHIFT! This would do a clean reopen of Word! (I cannot recall the precise steps). I tried it with Excel and it did something...saying it will not open some add ins!
    Is this a way to open these applications if something is wrong with its startup sequence???
    ALSO
    I held down CTRL, and it startups the application in SAFE MODE!
    Is this a valid way of overcoming some startup problems???
    Regards,
    Rudi

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Save as Greyed Out (Excell 2002)

    Starting an Office application (Windows too, by the way) with the Shift key held down is a way to avoid things loading automatically, such as global templates, add-ins etc.

    Starting an Office application with the Ctrl key held down, or /safe at the end of the command line used to start it, opens the application in safe mode. This disables a whole lot of features, look up 'safe mode' in the Answer Wizard.

    Both options can indeed be used to troubleshoot problems - Pieterse mentions safe mode in the post I referred to higher up in this thread.

  10. #10
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Save as Greyed Out (Excell 2002)

    The shortcut key to start Excel in safe mode (ctrl) was introduced with Excel XP. It is a handy method for troubleshooting Excel when it misbehaves.

    It is no alternative way to work with a disfunctional Excel though, it is meant for troubleshooting.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  11. #11
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    THANX

    When I read the post of jscher2000, i tried out his steps, (this was in Word), and it started Word as if it was a clean fresh install. IE, the office assistant activated and gave the option to start using Word, just as if it was the first time you opened it after an installation. As I say, I cannot recall the exact steps. I tried SHIFT, and it does not open in this "fresh" way! Is there something that I am missing!?
    (I tried to find the post using Search, but can't find it!)
    Regards,
    Rudi

  12. #12
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: THANX

    Hold down the control key while Word (or Excel) is starting. It will prompt whether you want to start it in safe mode.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •