Excel file - unable to open, "Access denied. Contact your administrator


Recommended Posts

As the title states, I have a file on a shared network drive (accessed by 10 or so people). Everything worked fine for a few days, file was updated by at least 6 or 7 people. Came into work the other day, double click to open the file and get the following error message:

"Access denied. Contact your administrator."

I am the creator of the file and the file permissions are set to normal so nothing has been changed there. I used to have this problem before we were upgraded to Office 2010 and as a last resort I was able to just copy the file and then use the new one. Now if I attempt to copy and paste the file to my desktop, I get the following message:

"File Access Denied" - You need permission to perform this action, You require permission from <a user in my office> to make changes to this file. (I can only choose Try Again or Cancel)

This person gets the same error message on their PC so that does me no good. So is there anyway to recover this file or get access to it?

Thanks

  On 18/01/2012 at 17:06, jerzdawg said:

As the title states, I have a file on a shared network drive (accessed by 10 or so people). Everything worked fine for a few days, file was updated by at least 6 or 7 people. Came into work the other day, double click to open the file and get the following error message:

"Access denied. Contact your administrator."

I am the creator of the file and the file permissions are set to normal so nothing has been changed there. I used to have this problem before we were upgraded to Office 2010 and as a last resort I was able to just copy the file and then use the new one. Now if I attempt to copy and paste the file to my desktop, I get the following message:

"File Access Denied" - You need permission to perform this action, You require permission from <a user in my office> to make changes to this file. (I can only choose Try Again or Cancel)

This person gets the same error message on their PC so that does me no good. So is there anyway to recover this file or get access to it?

Thanks

Right click the file > properties > security tab. Post screenshot please.

  On 18/01/2012 at 17:10, Open Minded said:

Is the file open in another location?

Office 2007-2010 show "this file is open by X. Do you want to notify that user, open a read only copy, and "something else.

  On 18/01/2012 at 17:30, nik louch said:

Have you considered SharePoint?

OP doesn't seem to be the network admin.

  On 18/01/2012 at 17:26, still1 said:

Call the Help desk and ask them to disconnect all connection to that file.

Or if you have access(which is least possible) to the file server you can do it yourself.

call is already in, been waiting a few days already- trying to speed up the process

  On 18/01/2012 at 17:30, nik louch said:

Have you considered SharePoint?

yea, not the admin

  On 18/01/2012 at 17:35, cybertimber2008 said:

Right click the file > properties > security tab. Post screenshot please.

Office 2007-2010 show "this file is open by X. Do you want to notify that user, open a read only copy, and "something else.

OP doesn't seem to be the network admin.

For "Users" it has Allow for Modift, Read & Execute, Read, Write (Full control is available to Admin only)

The user who is listed is getting the same error messages I got when attempting to copy to the local drive

  On 18/01/2012 at 17:47, Grunt said:

Sounds corrupt. Copy to local disk and see if that opens. If not:

unable to copy to local disk

  On 18/01/2012 at 17:57, Zumiiiiii said:

We had this issue on some shared Excel files when we moved from Office 2003 to 2010. Had to wipe the permissions and add the permissions again and it worked after.

ill try that.

edit - I get an access denied when attempting to change any permissions.

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • Nice! My $100 refurbished iPad 8 that I bought last year for a small project (and still runs like new cuz it's been mostly in storage the past several months) will get this v26 upgrade. I'm definitely gonna scope out OS26 on this device before upgrading my also-supported refurbished iPhone SE 3rd Gen (only got it for the 5G UW support).
    • Hello, The separate discussion about VLC has been moved to its own thread at  Regards, Aryeh Goretsky  
    • Hello, I am guessing this is the result of using a third-party tweaking tool instead of changing things within Windows settings. Windows 11 has a decent set of configuration options for the display, but they tend to be scattered throughout the operating system due to fragmentation of product ownership/inconsistent standards being applied by Microsoft. There are a few places in Windows 11 where you can modify the various display settings in order to get them to your liking: Under Settings → System → Display you can stroll down to the Scale & layout section and change the Scale and Display resolution settings to whatever you prefer.  For the Scale option, you can click on the text box to choose between the various pre-populated settings.  If none of those are exactly what you are looking for, click on the caret ("") caret to open the Custom scaling setting (also available under Settings → Display → Custom scaling).  I would recommend this as an option of last resort as this can cause display issues in various programs. I strongly recommend using the screen's native Display resolution here; it should show up as the "(Recommended)" resolution.  If it does not, you may need to install your monitor's profile information file (basically, a device driver for your monitor) to get the correct setting. Another place to look at making changes to fonts is under Accessiblity → Text size.  There is a slider bar for changing the text size from 100% to 225% there. You can try making changes to the ClearType settings.  It's a little bit finer-grained than the others, but it may make the text easier to view on the display.  Run the ClearType Text Tuner (filename: CTTUNE.EXE) and go through the wizard. You may want to do this several times under different lighting conditions or times of the day to figure out what works best for you overall. Lastly, you may want to look into using a dedicated assistive screen technology program from a third-party.  Microsoft provides a Screen Magnifier and a Narrator for text-to-speech, but they provide only basic functionality, and you may find that a third-party program works a lot better.  The pros of this is that third-party assistive technology programs tend to work quite well under Windows; Microsoft has historically worked closely with third-party developers of assistive technologies.  The cons of this are that such tools tend to be on the expensive side, since they are often sold to schools, businesses, or paid for by insurance companies, not individuals. Regards, Aryeh Goretsky  
    • Totally agree with you. I think people, especially on tech sites, need to realize that they’re the minority. Microsoft isn’t going to waste time on things that, in the big picture, don’t matter to the majority.
    • I think a lot of people here are too young to even remember Aqua.
  • Recent Achievements

    • Dedicated
      MadMung0 earned a badge
      Dedicated
    • Rookie
      CHUNWEI went up a rank
      Rookie
    • Enthusiast
      the420kid went up a rank
      Enthusiast
    • Conversation Starter
      NeoToad777 earned a badge
      Conversation Starter
    • Week One Done
      VicByrd earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      506
    2. 2
      ATLien_0
      267
    3. 3
      +FloatingFatMan
      257
    4. 4
      Edouard
      203
    5. 5
      snowy owl
      178
  • Tell a friend

    Love Neowin? Tell a friend!