Excel (2003) hanging when opening spreadsheets

Home Forums Office Office XP / 2003 General Issues Excel (2003) hanging when opening spreadsheets

This topic contains 19 replies, has 9 voices, and was last updated by Avatar scousemate 8 years, 2 months ago.

Viewing 20 posts - 1 through 20 (of 20 total)
  • Author
    Posts
  • Avatar
    mudcow007
    Member
    #155257

    Hello all

    this is annoying the hell out of me

    we have a small domain of about 40 computers, some of them can open a particular spreadsheet, but on other machines Excel hangs and eventually “

    i have tried

    excel.exe /unregserver
    excel.exe /regserver

    no effect

    also tried Tools > Options > General > “ignore other applications”

    no effect

    any ideas anyone??!

    Avatar
    Virtual
    Member
    #333933

    Re: Excel (2003) hanging when opening spreadsheets

    Is the problem Excel sheet in the newer format? Does the same happen if the file is opened from the local machine?

    Avatar
    mudcow007
    Member
    #292693

    Re: Excel (2003) hanging when opening spreadsheets

    hi

    all outlook installations are 2003 so should all be the same format

    documents are all stored on our file server (which has been restarted, with no effect)

    i have just had a crash on my own machine from opening one the “effecting” spreadsheets so just waiting to see if can see anything in the dump file

    odd how 1 machine can not open it, then another can? is there any setting i can flush in excel?

    i thought it could have been a dns issue with the docs being on the file server but i have flushed dns an can ping the server etc?!

    any ideas?

    im stumped

    Avatar
    Virtual
    Member
    #333934

    Re: Excel (2003) hanging when opening spreadsheets

    When you open the excel document, does it state that it is in compatibility mode?

    Avatar
    mudcow007
    Member
    #292694

    Re: Excel (2003) hanging when opening spreadsheets

    nothing at all, just stalls at a white blank page, after about 4-5mins if you try to close the window you get the classic “unresponsive program”

    Avatar
    Ossian
    Moderator
    #184569

    Re: Excel (2003) hanging when opening spreadsheets

    Anything in event logs (client AND server)?

    tehcamel
    tehcamel
    Moderator
    #357709

    Re: Excel (2003) hanging when opening spreadsheets

    if you relocate the files that cause the problems off the server, and onto local disk

    can you replicate the issue ?

    Avatar
    wullieb1
    Moderator
    #243171

    Re: Excel (2003) hanging when opening spreadsheets

    HOw large is the spreadsheet and does it have links to other docs that have been moved???

    Avatar
    mudcow007
    Member
    #292695

    Re: Excel (2003) hanging when opening spreadsheets

    hi all thanks for the replies

    the problem doesn’t happen when the sheet is copied locally to an “affected” machine, the spreadsheet opens normal

    i can browse the network on my machine without any issues

    it seems its size related on the spreadsheets, if the spreadsheet is over a 1 or 2mb it locks up?

    word docs on the server don’t seem to be affected by the issue, they open fine.

    on my machine (affected) in the event logs im receiving

    error.jpg

    weird

    any ideas?!

    i really appreciate it guys thanks

    Avatar
    wullieb1
    Moderator
    #243175

    Re: Excel (2003) hanging when opening spreadsheets

    Do you have the latest updates installed??

    Have you tried a repair/removal/reinstall???

    Avatar
    yungsuki
    Member
    #382398

    Re: Excel (2003) hanging when opening spreadsheets

    First post, came across this after google search. I administer a network of 15 workstations. All of our workstations that use Excel 2003 are experiencing the hang issue. The workstations on Excel 2007 have no problems.

    This issue just started happening the last couple days. I’m wondering if one of the windows/office updates is the culprit. I will post back if I can get to the bottom of it. In most cases, if you let excel run, it will eventually open the spreadsheet. while it’s hanging, excel.exe is taking up a lot of resources.

    Avatar
    yungsuki
    Member
    #382399

    Re: Excel (2003) hanging when opening spreadsheets

    I can’t post links yet, so google microsoft 2570623

    the article was posted yesterday on microsoft support: Excel 2003 Office File Validation (OFV) opens workbooks slower across the network

    Testing now, will post back.

    Avatar
    yungsuki
    Member
    #382400

    Re: Excel (2003) hanging when opening spreadsheets

    I’m confused by the help article. My workstations don’t have that registry folder.
    they have HKEY_CURRENT_USERSoftwarePoliciesMicrosoft but there is no folder Office after that. Anyone have any advice?

    tehcamel
    tehcamel
    Moderator
    #357728

    Re: Excel (2003) hanging when opening spreadsheets

    do you have different versions of excel, or is everyone on 2003 ?

    Avatar
    yungsuki
    Member
    #382401

    Re: Excel (2003) hanging when opening spreadsheets

    Everyone on Office 2003.

    Avatar
    harinath
    Member
    #382416

    Re: Excel (2003) hanging when opening spreadsheets

    I had the same issue with Office 2003 users and the only way to fix it was by removing “MS Office File Validation Add-in”. After having removed that add-in Excel opened files without any problems.

    Avatar
    yungsuki
    Member
    #382402

    Re: Excel (2003) hanging when opening spreadsheets

    how did you remove the add-in?

    Edit: nm, i was looking in windows installed updates. Saw it in the main program list. Thanks!

    Avatar
    gkarasik
    Member
    #280403

    Re: Excel (2003) hanging when opening spreadsheets

    Hi,

    More data: With “Microsoft Office Validation Add-In” loaded, .XLS files refuse to open over a VPN (PPTP) connection (either Excel 2003 or 2007). Removing “Microsoft Office Validation Add-In” resolves the problem.

    Workaround if “Validation Add-In” is present is to force-shut Excel, then restart it. The file that failed to open is then present in the repair/recovery window and will open with a double-click, although a blank Excel workbook also opens.

    GaryK

    Avatar
    scousemate
    Member
    #382885

    Re: Excel (2003) hanging when opening spreadsheets

    Hi,

    not sure if this is related but i ran into the same problem.

    Opening .xls files from excel 2003 over a pptp vpn takes a very long time however .xlsx files are fine.

    My resolution was to remove 2 windows updates for excel,

    KB2502786 and KB2541025

    It’s in my blogpost

    Not allowed to post links yet but it’s at www . bothathiart .com

    cheers

    Avatar
    mudcow007
    Member
    #292696

    Re: Excel (2003) hanging when opening spreadsheets

    Hi guys sorry i haven’t updated this since i opened the tread it was indeed caused by a bad windows update, i believe it was the “MS Office File Validation Add-in” update in June

    rolled back effected machines an all is well

    hope this helps those that are affected!

Viewing 20 posts - 1 through 20 (of 20 total)

You must be logged in to reply to this topic.