Excel Crashes when File tab is clicked

[Krishna Khemraj]

There are a series of files on our shared drive that users from various locations can access. It seems like some locations can open it and use it just fine while others can open it but when the File tab is clicked, excel crashes and can only be closed using Task Manager. Since it is mostly location specific (NY office crashes, Chicago office works, KC office crashes, Omaha office works), I assume the cause of crashing is in a setting.

What I've tried -
1. recreating the problem but works fine on my two machines.
2. changing the default printer to XPS printer. Didn't work
3. unchecked all COM-Add Ins and restarted. Didn't work
4. Checked for missing references in VBA. Everything looks good

I'm stuck. Any thoughts?
Is there a way to assign an on-action macro to clicking the File tab on the ribbon? I can't think of a way.

 

[bobhc]

You are not alone.

https://www.google.co.uk/search?q=E...-8&oe=utf-8&gws_rd=cr&ei=YE13VejlG4njU9WbgKAO


.

 

[Krishna Khemraj]

Problem:some rogue corrupted hyperlinks on worksheets. The author didn't put them there, but someone along the way did and eventually the source file became corrupted and it was propagated to all files created from the master. I opened the corrupted file and then a blank file, Copied tabs to new workbook. If they crashed Excel when trying to move them, there was some corrupted data on the worksheet. Once I found a problem sheet. I deleted chunks of rows and columns till I found the section that caused the error. Then I noticed that if I moused over a section that crashes, the cursor switches to give me the finger right before crashing. This made me think of hyperlinks. The following code run in all workbooks removed the hyperlinks and the files don't crash anymore.

Sub NoLinks()
  For Each pSheet In Sheets
    pSheet.Unprotect
    pSheet.Hyperlinks.Delete
  Next pSheet
End Sub

Hope this helps someone with a similar problem.