Windows 10: Can't Save Excel To D Drive

Can't save Excel to D drive The message appear when I want to save as to D drive "You are attempting to save a file type word 2007 and later Documents and Templates that is blocked by your file block settings in the Trust Centre"Context this PC is Pre-built MSI with HDD and W11 Home, so I upgrade myself with OEM W11 Pro, add NVME as main C drive.After installing Microsoft Office Professional 2021 digital download, the excel can't save to D drive, I only can save to C drive but in document folder. Context there is Administration user and user' user.So how do we solve this issue?

:)

 

No permission to save to D:\ drive

Hi Charlotte,

Thank you for writing to Microsoft Community Forums.

In order to get clarity on this issue and assist you with appropriate troubleshooting steps, please reply with the answers to the questions below.

• Have you mapped the libraries to the D: drive?
• Is the issue specific to the subfolder in D: drive?

Try the below methods and check if this helps.

Method 1: Creating New File In D: Drive.

1. Go to D: drive > Right-click on an empty space in D: drive > Click on
   New > Click Text Document.
2. Give a name to the Text Document and save it and check if you get the same error.

If you don't get any error while saving the file in D: drive and you get this error message only while saving a document in D:\charl\Documents, then follow
Method 2 to take the ownership of Documents folder, else follow
Method 3.

Method 2: Taking Ownership Of A Particular Folder.

1. Click on Start Menu > Search for Command Prompt >
   Right-click on Command Prompt > Click on Run As Administrator.
2. Once the Command Prompt is up and running, type the following commands and hit
   Enter after each command.

takeown /f <foldername> /r /d y

icacls <foldername> /grant administrators:F /T

Note: Replace foldername with the path of the folder.

3. Once the above commands are executed successfully,
restart the computer once, and check if you are able to save the documents in that folder.

Method 3: Check If You Are The Administrator From Netplwiz.

1. Click on the Start menu > Search for Netplwiz > Hit
   Enter.
2. Click on your user name and click on Properties.
3. Go to Group Membership tab and choose Administrator > Click on
   Apply > OK.
4. Once you change this setting, restart the computer once and check for the issue.

Method 3: Disabling Antivirus.

If you have installed any third-party security software, I suggest you to temporarily disable them, restart the computer once, and check for the issue.

Note: Antivirus software can help protect your computer against viruses and other security threats. In most cases, you shouldn't disable your antivirus software. If you have to temporarily disable it to install other
software, you should re-enable it as soon as you're done. If you're connected to the Internet or a network while your antivirus software is disabled, your computer is vulnerable to attacks.

Give it a shot and let us know of any changes.

Hope it helps.

 

D drive

Hi,

Based on the details you have provided us, it appears that there might be some corrupted contents on the said partition. We can also consider that this is caused by a virus.

For us to check if a certain virus is hiding your files, kindly follow the steps below:

• Type Command prompt in the search bar.
• Type-in the following command:
  
  attrib -h -r -s /s /d D:\*.*
• Press Enter to execute the command.

If you think that there is nothing important stored in it, then we suggest that you reformat your D drive so that you can use the free space for important files.

You can follow the steps below to start with the process:

• Click on the File Explorer.
• Select This PC.
• Right-click on your D drive, then click on Format.
• Follow the on-screen process to finish formatting the partition.

Let us know how it goes so that we can further assist you.

 

excel not auto recovering and manually saving

Hi,

The concern you have encountered with Excel not auto saving may be due to a corrupted file or a misconfigured setting.

May we ask if you have 3rd party software running when using Excel? If yes, we suggest to temporarily disable it to isolate the issue.

Any changes made on your computer prior to the issue?

Have you tried any possible troubleshooting steps? If yes, what are those steps and did you get any error messages?

You can turn-on the auto save option by the following steps:

• Open Excel
  
• Go to File then Options
  
• Under Save option, check the 'Save AutoRecovery information in every' option
  

the best way to check when auto save is disabled is to hover over the toggle and read the reason that the popup tool tip identifies. Simply follow the steps provided in this

article.

According to this
article the autosave function will be disabled when the file is in the old file format .xls.

Kindly keep us posted with the results.

Regards.