Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Apr 2002
    Location
    Busselton, Western Australia, Australia
    Posts
    59
    Thanks
    1
    Thanked 2 Times in 2 Posts

    Thumbs up

    I have an unusuall problem that has only cropped up this morning.
    We are running Terminal Services with Office 2000 SP3 running on the system.
    One user has reported that they can not view or set any tools/options within Excel.
    They can not get even a simple thing like the vertical or horizontal scroll bars to display.
    I wrote a small macro to turn them on, but this failed to make any difference also.
    Other users are able to view the same spreadsheet on their logon with full access to the options.
    Any ideas on how I can restore this functionality?
    Thanks
    Brian.

  2. #2
    Star Lounger
    Join Date
    Feb 2009
    Location
    Kings Park, Victoria, Australia
    Posts
    90
    Thanks
    15
    Thanked 5 Times in 5 Posts
    [quote name='BRoby' post='772102' date='24-Apr-2009 13:55']I have an unusuall problem that has only cropped up this morning.
    We are running Terminal Services with Office 2000 SP3 running on the system.
    One user has reported that they can not view or set any tools/options within Excel.
    They can not get even a simple thing like the vertical or horizontal scroll bars to display.
    I wrote a small macro to turn them on, but this failed to make any difference also.
    Other users are able to view the same spreadsheet on their logon with full access to the options.
    Any ideas on how I can restore this functionality?
    Thanks
    Brian. [/quote]
    It may be that the user has accidentally turned off the menu's - get them to use Alt-V whilst in Excel to bring up the view menu, then Toolbars and get them to select Standard and Formatting menu's.

    Regards,
    Maria
    Maria
    Simmo7
    Victoria, Australia

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Sounds like the Excel key in the registry has been corrupted. You can safely remove the key, Excel will recreate it with its default settings. See the part about the registry on this page:

    http://www.jkp-ads.com/Articles/StartupProblems.asp
    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
  •