Cannot open any Microsoft Office 2013 document on the server from one workstation

Andreas Gieryic
Andreas Gieryic used Ask the Experts™
on
I have a Windows 7 Pro workstation running Office 2013. The workstation has all of the latest Windows 7 and Office 2013 updates.
-  Its connected to an SBS2008 server
- Everyone is set up to use SBS2008 Exchange server 2007 email. The Microsoft Office 2013 is a full install and not a subscription

When the user opens a spreadsheet saved on the server, he cannot open it up. Excel starts to open by displaying the Excel logo twice and then only opens the Excel template page where it shows all of the recently open files on the left side and all of the available Excel templates to the right
- Confirmed that this issue is true for all of the Office data files (Word, Excel, Powerpoint. .etc
- There are no issues opening any Office data files on the local drive
- No other user is having this issue

Troubleshooting Steps
-      tested and confirmed,  opening any office application files on the local drive, opens fine
-      tested and confirmed,  opening any office application files anywhere on the server, will not open,  
-      Logged off as the user and then logged on as the server administrator from his PC and was able to open any office document on the server as well as local files
-      ran a repair of the Microsoft Office 2013.  No Change
-      restriped the users full control security access to all his data on the server to no avail. User has no issues opening any non-office data files suchs PDF's and JPG's  . .etc
However, if I copy any office related data file from the server to the local PC, it opens fine
- I have not yet tried to log in to another workstation as this one user
-      My thought at this point is that I’ll have to recreate his user profile. We plan retiring the server and upgrading. I could move the user to a workgroup and reconfigure the email and drive mappings.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
Try a full Repair of Office and test again.

Then, make a new, test, Windows User Profile (account).  At this point, this is just a different test account.  Log in, set up Office (not much to do) and test opening a document.  Does it work?
Andreas GieryicComputer Networking, Owner

Author

Commented:
I already performed a full office repair as mentioned above.
I tested the server admin account with no issues

I created an SBSTEST account.  Gave it access to the PC and added domain account to the local administrator's group. Worked fine with no issues
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
So then the user account is damaged and you need to re-create it.
CompTIA Security+

Learn the essential functions of CompTIA Security+, which establishes the core knowledge required of any cybersecurity role and leads professionals into intermediate-level cybersecurity jobs.

Andreas GieryicComputer Networking, Owner

Author

Commented:
That's what I thought.  
Not looking forward to doing that for this profile is quite large.
I was mistaken, I am still using the SBS2008 Exchange, we have not yet moved to Office 365 Exchange email
Just to give me peace of mind, I'll try logging on with his credentials on another workstation. I'm not using a roaming profile. Not sure what that will prove.
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
Please keep us posted.
Andreas GieryicComputer Networking, Owner

Author

Commented:
I logged onto a different workstation as the problematic user and experienced no issues opening any office data files on the server

I'm wondering what the easiest task would be now with reference to the user's profile.
-We will be retiring this server within the next month or so. At that time, I'll have to move the PC into a workgroup before moving it into a new domain with the new server and server operating system
- I have to think this through because it's been near 10 years when I had to re-create a user profile using the SBS 2008 console and hopefully pointing it back to its current exchange email folder
Business Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018
Commented:
Profiles can interfere with the operating system, so if you are happy the profile works in a new computer (but we know does not in the old computer), then rebuild the old computer (reinstall Windows) and use the existing profile.
Andreas GieryicComputer Networking, Owner

Author

Commented:
I also forgot to mention above, that I believe this issue happened after I installed 38 additional Microsoft updates. This particular PC had issues getting updates and I had to force the updates. I tried to do a system restore to an earlier time, but that's disabled by default. I could try to uninstall all the updates that were recently installed. What's your thought on that?
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
We update our client machines and do not damage profiles in the process.  

… I had to force the updates   <-- I think something went wrong and the best way would be to rebuild the machine and then use the existing profile.
Andreas GieryicComputer Networking, Owner

Author

Commented:
I agree with you, John. I do have a Windows 7 system image that was created a few months ago that I may use but I think a rebuild is the best option. This will resolve other small issues that this PC was having

If I rebuilding, I will rebuild it in a workgroup and then point to the exchange server for email. That way, when I set up the new 2016 server, it will be ready to enter the new domain.
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
That seems correct and certainly worth a try.
Andreas GieryicComputer Networking, Owner

Author

Commented:
Thanks John
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
You are most welcome and /I was pleased to help you resolve this
Olgierd UngehojerSenior Network Administrator

Commented:
Did you check GPO for this computer, it sound like some permission issue, but by Computer GPO. Is this computer in the same OU like others computers?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial