Link to home
Start Free TrialLog in
Avatar of itcspro
itcspro

asked on

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.
Avatar of MrSlithy
MrSlithy

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?
Avatar of itcspro

ASKER

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.
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?
Avatar of itcspro

ASKER

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.
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?
Avatar of itcspro

ASKER

Not all of the users are in same group.
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.
Avatar of itcspro

ASKER

You mean copy the file to their desktop? I haven't tried that, but even it worked how would it help the current situation?
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.
Avatar of itcspro

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of itcspro
itcspro

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Great job not giving up! Glad you got it working.
Avatar of itcspro

ASKER

Thanks for all your help.
Avatar of itcspro

ASKER

Kept digging on Microsoft answers community, had to resolve it with in timely fashion. I found a tweak, applied and it worked.