Excel 2010 crashes sometimes when some documents are linked together

Posted on 2011-10-19
Last Modified: 2012-05-12
We have documents in excel that have many connections to some (5-10) other excel-documents where data is taken from. From time to time says Excel 2010 that an error occured an Excel is running anymore. With normal excel sheets with less documents data taken from the error don´t occure.
This happens with most(maybe all) computers in LAN. But the same document that sometimes crashes, sometimes works fine.
We have ServicePack1 installed. All computers are Win7 32 Bit, with Office 2010 32 Bit in a win2003-domain.

Any ideas ?
Question by:loosain
    LVL 10

    Expert Comment

    Do you have all the other patches installed?  There are a lot of "compatibility" patches for 7.  SP1 for 7 or Office or both?
    I think Office still has quite a few bugs to work out.  Excel tends to crash with password protected spreadsheets.

    Author Comment

    office 2010 sp1, win 7 sp1 and all latest win-updates are installed... i am going to check wether there are passwords set. but i think there are no password protected excel sheets.
    LVL 11

    Accepted Solution

    This could just be the stability of your network.  If Excel thinks you lose connection to your network occasionally it could be the cuprit.

    If you move these documents to your desktop are you ever able to reproduce the error?  

    Do the errors happen at busy network times?


    Author Closing Comment

    until now we didn´t get back the problem after working with the documents from desktop, so we have to search the network for the error... :-(

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Sometimes we don't want to show zeros in our Excel spreadsheets. This is sometimes most evident in our charts. Look at the chart below, all the zero values are visible. I think that all will agree with the fact that zero values are not looking nice …
    Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now