Excel file not opening

Dear Experts
I have an excel file on my network in a folder on x: drive, which is available to permitted users to the folder. Issue I am having is some users cannot open the file at all, it will keep loading and eventually not responding. Other users can open it just fine. Rough size of the file is about 20 mb. I have tried even upgrading the tower RAM to 8 GB from 4 with no luck. Office version installed on each users is same and same configuration towers for all. Same permission to these users as well. OS is windows 7 Pro.
Please provide your expert advice.

Thanks in advance.
itcsproAsked:
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.

MrSlithyCommented:
So I take it there other Excel files on the X Dr. and they all open fine for these users. Is it possible the XL file as an older version and it has to do with some users being able to open the file fine whereas others can't or is the XL file in the same version?. What version of Microsoft office are you running.

Permission it might be right but is this possibly a Microsoft office trust issue?
0
itcsproAuthor Commented:
Office 2010. Not everyone is having this issue. I doubt it's a trust issue. There are other random excel files as well with random people same issue.
0
MrSlithyCommented:
Is the errant Excel file an older Excel file or is it a .xlsx file.  Just like the others, huh?

 If was an older format I try opening it and saving it as a newer format and see if the problem goes away for the other users. This wouldn't really say why it's happening but it would get you past the issue. But I suspect I'm batting zero here as well?
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

itcsproAuthor Commented:
They all are .xlsx
That what driving me crazy. I suspect it's something to do with the folder they are in on network, but I am a no pro.
0
MrSlithyCommented:
And you can see no difference and it whatever security groups related permissions to different users might be in. Are all the users having problems in a particular group in the permissions are not correct?
1
itcsproAuthor Commented:
Not all of the users are in same group.
0
MrSlithyCommented:
What would happen if you fetched a copy of the file that won't open for some users and place it on one of their desktops and have them open it there. Just to see what happens.
0
itcsproAuthor Commented:
You mean copy the file to their desktop? I haven't tried that, but even it worked how would it help the current situation?
0
MrSlithyCommented:
I was just thinking if you put it on your desktop and it opens it's just a way of getting it off the network to see if it's something in the file itself or something regarding network active directory permissions etc.
0
itcsproAuthor Commented:
I would like to mention which I have missed before, this excel file was one example but it happens with multiple (only excel) files size ranging 5-25 mb.
I will try to copy it on my desktop in the morning although I am not sure how much useful would that be, as it would be a local file.
0
itcsproAuthor Commented:
I was doing some search on Microsoft website and below registry tweak link helped resolving this issue. I want to share it here for anyone else with same issue. FYi, I have set superfetch to 1 and it worked for me.

http://answers.microsoft.com/en-us/office/forum/office_2010-excel/opening-excel-file-directly-is-very-slow/788b0991-ad84-40bd-b5c1-21b7fdc8d2bf?page=2
0

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
MrSlithyCommented:
Great job not giving up! Glad you got it working.
0
itcsproAuthor Commented:
Thanks for all your help.
0
itcsproAuthor Commented:
Kept digging on Microsoft answers community, had to resolve it with in timely fashion. I found a tweak, applied and it worked.
0
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.