Today i came across excel files opening slowly when you search for this problem there appear to be many people having similar issues, to cut a long story short it turned out to be the Office File Validation tool that had come down with the windows updates.
Method 4 solved the issue for me on the Microsoft website