PC Can not run controls after GPF
PC Can not run controls after GPF
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: PC Can not run controls after GPF

  1. #1
    . MrExcel's Avatar
    Join Date
    Feb 2002
    Location
    Merritt Island Florida
    Posts
    858
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Here is an interesting problem. An Excel workbook with numerous userforms crashed on a particular PC. After rebooting, that PC could no longer open the workbook.

    Another laptop could open the workbook OK.

    On the original PC, we uninstalled and re-installed office. Still the same problem.

    Upon further testing, it seems to be that any Workbook which has userform controls is taking forever to load on the original PC.

    Any ideas?

    Thanks

    Bill
    View a collection of recent Excel articles in the Excel Daily News

  2. #2
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I know that some people may have an idea if you state the versions and OS.

    The only thing I can think of with userforms crashing Excel is if one of the forms references an invalid control. e.g.

    http://support.microsoft.com/search/...;en-us;Q231081

    Was the workbook originally created on this machine that crashed?

    _________________
    [b] Mark O'Brien

    [ This Message was edited by: Mark O'Brien on 2002-04-15 07:19 ]

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Re: PC running WInME, excel 2000. File with many userforms & controls crashed, upon reboot, Excel takes several minutes to load file and similar files more than a year old, Creating new file with four command buttons and a couple lines of code, takes fifteen seconds to load & close. Command buttons take several seconds to appear on the sheet. Excel was reinstalled, Registry cleaner run, still same problem. Files run fine on another system. Any ideas?

  4. #4
    New Member
    Join Date
    Mar 2002
    Location
    Manitoba, Canada
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Have you tried to erase all the temp files in the Windows temp directory, and then run a scandisk on your hard drive for any file corruption... Just a thought.
    Peter

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Mood/Peter - Your suggestion to clean out the temp file seems to have worked. I had thousands of small image files of controls and a couple of temp files of the program in the temp file. Many thanks!
    -Mike Robinson

  6. #6
    . MrExcel's Avatar
    Join Date
    Feb 2002
    Location
    Merritt Island Florida
    Posts
    858
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-15 22:17, Mood wrote:
    Have you tried to erase all the temp files in the Windows temp directory,Peter
    Interesting. Wow. Looking my Windows / Temp directory, I have small .emf files of 200 controls, plus some company logos. I recognize most of these as controls from various Excel files that I have opened.

    Why does Excel write these out there? I am not having a problem with the 200, but it must cause a problem when you get to 1000+.

    Does anyone have more information on this?

    Bill
    View a collection of recent Excel articles in the Excel Daily News

  7. #7
    Board Regular
    Join Date
    Feb 2002
    Location
    Huntington Beach, CA USA
    Posts
    327
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I had numerous files that would take up to15 min to open and the same amount of time to close. I read this board every day and
    came across a post of someone in the group having the same problem. Someone suggested
    deleting the "emf" files in the temp dir.
    I found over 3,000 "emf" files....deleted
    and the files now open like they should?

    This board and the people involved are great

    James


  8. #8
    New Member
    Join Date
    Mar 2002
    Location
    Manitoba, Canada
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I think the main reason for all the temp files in XL (just opening a blank sheet drops 12 files here), is for speed. This same principle is used as the cache in Internet Explorer. It is faster to look for the files in the temp folder than it is to recalculate the files again.

    As for any limit, I feel you can get to a certain limit, and it would take longer to find the files (due to file fragmentation) than to redo them from scratch. This is why I erase all my temp files.

    Also,when XL crashes, it can’t delete the files, so you are left with garbage in this folder. Just a thought…

    Peter

    [ This Message was edited by: Mood on 2002-04-17 10:59 ]

  9. #9
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    hi gues as Bill MeExcel has posted this i was surprised but wanted to offer some advice.

    Bill tmp file in internet or windows temp you can delete any OP regardless Win will rebuild in a snap if they are needed, as you know Ivan offer autoexec.bat code to del this dir on boot.

    Me i like to keep em so i can see em, remv as needs be ie once a week after a looks see,

    enf files are different they are built to allow files to build often after crashes kinda like chk after scan disk and also -*. no dos extentions reports as .file or 99 file if pirate sware .. these are from dirty memory and poor saves open 2 click shoul SHOULD open excel to open these xls docs.. ok kinda recovery..

    Windows being tricky i guess..

    all in all i say its windows talking with excel correctly and excel chattin to windows OK, they do this.
    Windows as you know is complex like in VBA you write code A Dave Hawley code B and Icvan code C Aladin pops in a nd formulas that code.. whats best???


    Depends what tyouneed and what you can maintain...


    any help

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com