Issues opening Excel .xls file directly from AS400 network share on Windows 7 and Excel 2013

Hello all,
    I had a user who was having issues opening Excel .xls files directly from an AS400 network share. It would launch Excel, say that it was downloading the file, get to 100% but then would just stay with a blank Excel window that had everything grayed out and then that would be where it ends. If they take the file and save it to the local disk, it will open just fine, but not when opening from the AS400 share.

I tried a few things I found online, such as disabling WebClient under services.msc, renaming the local Office folder under AppData so that a new one gets rebuilt, but have had no luck thus far.

If anyone has any suggestions, I would appreciate it!
MostHatedIT ManagerAsked:
Who is Participating?
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.

Scott SilvaNetwork AdministratorCommented:
I remember something like this before... See if this helps...
MostHatedIT ManagerAuthor Commented:
    I appreciate the reply, unfortunately I had tried that already, and all it did was make it so that no Excel files were able to be opened at all for some reason.

It is only .xls files that are on a network share, the same workbook can be opened if saved to the local drive with out any problem.
Does another user have the same issues when opening the same file?

If so, it could be an issue with the file itself.
If not, then it could be an issue with the configuration of the first user's computer.
CEOs need to know what they should worry about

Nearly every week during the past few years has featured a headline about the latest data breach, malware attack, ransomware demand, or unrecoverable corporate data loss. Those stories are frequently followed by news that the CEOs at those companies were forced to resign.

Can authority differences be found between this user and others, for the file, the directory and the share?
MostHatedIT ManagerAuthor Commented:
Thomas, no one else had an issue before today, so I thought it was an issue with that particular user (it might still be) but the exact same thing is now occurring with another user. Both Windows 7 and Office 2013. I have office 2013 and Windows 10 but am able to open the file just fine from a network share, as well as someone else who tried who also has windows 10.

I am wondering if perhaps it is related to a Windows 7 update that may have been installed over night on the newly effected persons PC, as I was looking at the update install date of the first user, and she noticed the issue right around the same time updates were installed.
Scott SilvaNetwork AdministratorCommented:
You can try restarting the System I Access File server process on the AS400 and see if it helps...
MostHatedIT ManagerAuthor Commented:
The server did an IPL over the weekend (it does one every weekend), would that have restarted the process you are referring to? If so, that did not help, as the original person having the issue is still having it.
Three things to try:

1. Make sure the shared folder you are using is listed in "Trusted Location"s.

2.  Whenever opening a workbook, MsExcel creates an accompanying workbook in the source directory. Make sure the User has write permissions to the source folder.

3.  Assuming 1 and 2 above are ok, save the workbook out in xlsx format and then try opening it.
MostHatedIT ManagerAuthor Commented:
It looks like the MS Excel team replied to a post someone else and I had made earlier on technet. You can see below.

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
I don't see the server OS version in the thread. In case I didn't just miss it, can you post the version? If you can find out, can you also post the the cume group PTF level?

Because MS sometimes changes its networking protocols, it can require matching protocols on the server. That can mean either having an appropriate server OS version or appropriate PTFs.
MostHatedIT ManagerAuthor Commented:
I came across a forum post that had information directly from the Microsoft Excel team, I have linked to their Technet page.
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.