Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2016-07-26
11
Medium Priority
?
60 Views
Last Modified: 2016-08-16
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!
Thanks,
0
Comment
Question by:MostHated
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
  • 2
  • +2
11 Comments
 
LVL 11

Expert Comment

by:Scott Silva
ID: 41729574
I remember something like this before... See if this helps...

https://support.microsoft.com/en-us/kb/2994633
1
 
LVL 1

Author Comment

by:MostHated
ID: 41729688
Scott,
    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.
0
 
LVL 14

Expert Comment

by:ThomasMcA2
ID: 41729770
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.
0
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 
LVL 27

Expert Comment

by:tliotta
ID: 41729806
Can authority differences be found between this user and others, for the file, the directory and the share?
0
 
LVL 1

Author Comment

by:MostHated
ID: 41729809
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.
0
 
LVL 11

Expert Comment

by:Scott Silva
ID: 41729831
You can try restarting the System I Access File server process on the AS400 and see if it helps...
0
 
LVL 1

Author Comment

by:MostHated
ID: 41729832
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.
0
 
LVL 14

Assisted Solution

by:wsh2
wsh2 earned 2000 total points
ID: 41729859
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.
0
 
LVL 1

Accepted Solution

by:
MostHated earned 0 total points
ID: 41729863
It looks like the MS Excel team replied to a post someone else and I had made earlier on technet. You can see below.

https://social.technet.microsoft.com/Forums/office/en-US/4a15e472-a265-4058-b439-7d79c2670817/xls-file-will-not-open-in-excel-2016-only-gray-view?forum=excel&prof=required
0
 
LVL 27

Expert Comment

by:tliotta
ID: 41734798
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.
0
 
LVL 1

Author Closing Comment

by:MostHated
ID: 41757591
I came across a forum post that had information directly from the Microsoft Excel team, I have linked to their Technet page.
0

Featured Post

Understanding Web Applications

Without even knowing it, most of us are using web applications on a daily basis. Gmail and Yahoo email, Twitter, Facebook, and eBay are used by most of us daily—and they are web applications. We often confuse these web applications tools for websites.  So, what is the difference?

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Originally, this post was published on Monitis Blog, you can check it here . It goes without saying that technology has transformed society and the very nature of how we live, work, and communicate in ways that would’ve been incomprehensible 5 ye…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question