Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Apr 2015
    Posts
    153
    Thanks
    70
    Thanked 0 Times in 0 Posts

    Excel Form Stopped Working Properly

    Hi Experts,

    I have been busy working on a project and haven't used Excel for a few months. Last night I opened an Excel 365 file that worked flawlessly two months ago. Now it is not working like it should.

    Everything opens OK, but when I click a command button or option button on a form not all of the data on the form shows unless I click and move the form. When I click and move the form all the data pops up. I've never seen this kind of problem before. To check if the Excel file had a problem, I opened it on another computer and it works perfectly.

    I am using Windows 8.1. My guess is that the problem is in Windows 8.1. However, everything works normally except for the Excel form problem as described above.

    I ran the System File Checker
    tool (SFC.exe) and it didn't show any integrity problems.

    I thought I would run this by you pros to see if you've dealt with this kind of problem.

    Thanks in advance for any help you can provide.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    There were a few bugs with forms introduced in the September updates, but the latest release should fix them. Have you tried updating your Office installation? Which build do you have?
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    2 Star Lounger
    Join Date
    Apr 2015
    Posts
    153
    Thanks
    70
    Thanked 0 Times in 0 Posts
    Rory,

    I'm have the following for Excel:

    Version 1609
    Build 7369.2038

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    7369.2054 has the fixes in. Did you try to update?
    Regards,
    Rory

    Microsoft MVP - Excel

  5. The Following User Says Thank You to rory For This Useful Post:

    Excelnewbie (2016-11-07)

  6. #5
    Star Lounger
    Join Date
    Dec 2009
    Location
    Findlay, Ohio
    Posts
    57
    Thanks
    4
    Thanked 6 Times in 6 Posts
    to do it manually:

    cd %programfiles%\Common Files\Microsoft Shared\ClickToRun

    officec2rclient.exe /update user updatetoversion=16.0.7369.2054

  7. The Following User Says Thank You to orangehat For This Useful Post:

    Excelnewbie (2016-11-07)

  8. #6
    2 Star Lounger
    Join Date
    Apr 2015
    Posts
    153
    Thanks
    70
    Thanked 0 Times in 0 Posts
    I now have .2054 after updating. I tested it and it looks like the problem is solved!

    Thank you, thank you.

    I paid for another year of 365 last week and thought it updated at that time. Apparently, it didn't, at least to .2054.

Posting Permissions

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