Post reply

MS Excel freezes when opening during DTS test

  • August 29, 2006 at 2:43 am

    #69238

    Hi,

    sometimes when writing DTS packages that export to Excel I find that Excel doesn't open when I double click on a spreadsheet. I have to start Excel then open the spreadsheet from the Excel menu. To fix the problem I have to reboot. This souunds like a memory problem or something.

    Any welcome or advise welcome.

    Thanks,

    Eamon

  • August 29, 2006 at 1:32 pm

    #657374

    This has happened to me as well. Whenever this happens I look at Task manager and find that Excel.exe is still running even if I had closed it. So I kill that excel.exe and then I am able to open the spreadsheet generated by sql process.  Hope this helps.

    Thanks

    Sreejith

  • August 30, 2006 at 1:50 am

    #657433

    Thanks Sreejith that works for me !!

  • August 30, 2006 at 9:57 am

    #657606

    If I understand correctly, you're running a process that, once run, doesn't allow you open excel properly.  If so, in the code, you need to close the application object.  That will terminate the application session, and then you won't have to reboot.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply