Excel 2013 crashes on opening
I'm really hoping someone can help. We have an issue on our network where Excel (2013) will crash on opening. Here is more detail.
It seems to be triggered by those grey rectangular messages that may pop-up at the beginning when you open a file, such as 'need to update links', 'cannot update links due to one being broken', 'password required', or most commonly 'locked for editing by someone else, would you like read-only?', BUT IT NEVER QUITE GETS THIS FAR, so you never see the message itself.
(BTW: what frustrates my internet searches is that there has been a lot of recent issues with false Excel file locks. This is not our issue.) Other people genuinely have got the file open, so there is a genuine and appropriate lock. But the second user never gets the chance to click 'read only' and continue.
IF THEY OPEN THE FILE FROM WINDOWS EXPLORER (after someone else has already got it open), the Excel 2013 green intro box pops up as normal as the program loads to open the file. But it hangs there. You can use the cross at top right of the green intro box. Then launch Excel again. Nothing. Then again, and message will tell you something like 'Excel cannot be stopped at the moment'. Then you get the choice to restart the program.
IF YOU OPEN EXCEL FIRST AND BROWSE TO THE FILE FROM WITHIN PROGRAM then the notification such as 'file locked' opens JUST FINE and there is no problem because you get to click 'read-only' and continue.
When trying to open from Explorer, it is almost as if the component of Excel 2013 that will display the grey message box needs to be launched first, but isn't and so the program gets stuck unable to display the message. I have hoped that this, that, or the other update would solve our problems, but it hasn't happened and I need to seek wider advice.
Any ideas? We are Win7 x64. We did not have this problem when we had Office 2010, but we also went to a 64bit OS about the same time as we went to Office 2013.
Excel 2013 crashes on opening
Not sure how much this helps as not had experience with Excel 2013 however just from experience of Excel 2010 :
1) Ensure the excel file is shared correctly, have had it on some excel files where it shows as shared and we have had to disable sharing and then re-enable sharing on the excel file ( by getting the creator of said excel file to open the excel file and be the only person with it opened ) to do the disabling and re-enabling of the sharing of the excel file and then test ie get other users to launch the excel file, linky to an article, not sure how good the instructions are , you may be able to find a better article, I appreciate this is for 2010 so not sure how relevant the steps or instructions are but will need to ensure that you have given the relevant people access rights to this shared excel file within excel whilst you are sharing the relevant excel document : How To Share Files In Excel 2010
2) The shared area of where the excel file is contained ( whether it is a shared unc path / folder on a shared drive ie R Drive or whatever ) that each user has relevant permissions ie NTFS access rights to read / write to the excel file correctly
3) Within both Internet Options --> Security tab to add the path or failing that at least the FQDN of the domain so that Internet Security settings for both Intranet and trusted sites will trust the shared area on the domain
4) Within Excel, I think it is within the trust centre settings ( Open excel --> File --> Options --> Trust Centre --> Trust Centre Settings --> Trusted Locations --> add new location button --> either navigate to the root directory or type the path out to the root directory of where all the excel documents are located. You can add the full path to where the Excel file(s) are stored and tick a tick box to trust all documents within sub-directories of that path
See attached screen grab ( ensure to tick the tick box so as to include all sub-directories )
SOLUTION! This is Smart Technology related
I know it's been a while since I last updated this. I wanted to let you all know the cause of, and solution to the problem.
We use Smart interactive whiteboards here. With it comes Smart Notebook and Smart drivers. I can't remember exactly which part of their software suite it is (perhaps Smart Ink), but it installs Add-Ins for the MS Office Suite.
Within MS Excel, if you go to File>Options>Add-Ins and within the COM section disable the Smart add-in you'll see there, the problem then disappears! NOTE for new people to this post, the problem that disappears is the EXACT one I have described, please do not confuse this with some other Excel problems.
There are various Smart related Add-Ins (I think), but we could find no adverse effects from disabling the particular add-in I described.
It is rather surprising that Smart Tech's add-ins interfere with the type of MS Office functionality I have been discussing in this thread. I believe my boss has checked that our Smart software version is not that old. Not too pleased with Smart's software development testing in this respect.