MS Excel 2013 hanging problem

So we have a problem with Excel 2013 hanging when opening spreadsheets. I have a link to a video so you can see the problem.

We have repaired the installation and we have also swapped the PC. We have tried copying the files to the desktop from the server.
The PC's are HP with Windows 7 Pro, 4GB RAM, 500GB HDD, Network is gigabit

YouTube Video of Excel Hanging
James NewportAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Robberbaron (robr)Commented:
'seeing the problem' doesnt help i'm afraid.
it looked to me like the workbook openned, but failed when running a macro that opened a second workbook.

more details on what it is doing are needed, along with the code that runs when the second worksheet is activated.
James NewportAuthor Commented:
There are no macros. So all that the video shows is that if you have excel open then try to open another workbook you get a blue spinning wheel. If you click on a sheet in the original workbook the file you are trying to open then opens straight away.
Robberbaron (robr)Commented:

1. In the video, the first workbook that is open is actually in 'cell-edit' mode (@ Cell B3) and this effectively locks Excel from any other action.  (I can tell because the formula bar at the top shows the Tick & Cross , along with fx)
2. By clicking on another sheet, you are forcing it out of 'cell-edit' mode and the app can respond to other commands, such as open a new workbook.  
3. You usually exit cell-edit by pressing escape key, or use the tick or cross to accept or reject the changes to the cell.  Or clicking any other cell or worksheet works as you have discovered.
4. Something must be putting the cell into Edit modedifference between edit mode and std mode;  usually double click or F2 button if no macros are involved.  
5. Enable the Developer tab to access the list of VBA modules that may be loaded.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.