Whether I save or save as, I cannot update my spreadsheet.
duplicate of
https://ask.libreoffice.org/en/question/284011/why-does-write-error-prevent-saving-my-spreadsheet/
and
https://ask.libreoffice.org/en/question/284012/why-does-write-error-prevent-saving-my-spreadsheet/
Keep track on this one
Hello - you have a problem and are looking for help. That’s what this site is about, but please understand no one willing to help is able to provide a sound answer without some information about your environment. Thus please provide:
- Operating System (Windows, Linux, macOS) and its version?
- LibreOffice version?
- Storage devices (Local disk, Local fileserver, Cloud, Google Drive; OneDrive)?
- Filenames (esp.: Do they contain spaces; e.g: File Name with Spaces.ods)
- If applicable: Access method to remote directories (NFS, SAMBA, Windows Share)?
- Any save/storage problems using other applications
- Did you already try to reset your user profile?
- Did you try to start LibreOffice in Safe Mode?
I use Windows 10. Libre Office currently is version 7.0.4.2, installed Dec. 23, 2020, but problem existed on later versions of version 6. The present issue: On my Calc file Camry mileage.ods (with a space), I want to save to my local drive. I get a report, “Error saving the document Camry mileage. Write error. The file could not be written.” If I try a Save As, if I try to save I get window that wants to save the file “Camry mileage.odf”. I have no choice to save as a .ods fileI get the window message “Camry mileage.ods already exists. Do you want to replace it?” I answer “Yes”. The program reports “Save write error”, and no save is accomplished. I have been able to save the file in Excel, but that really isn’t my purpose. I have no problem with any other program or application. I have not tried to reset my user profile (not sure why I should, even if I knew how) and I have not stated Libre Office in Safe Mode (again, not sure why I should).
You anti-virus is protecting your computer from un-authorised write access to files. You need to makeLibreOffice an authorised app. It depends on your anti-virus butthere is some guidance below. If you don’t have another anti-virus then you have Windows Defender
Allow LibreOffice access to Defender Access Controlled folder
The below numbered list is from Use the Windows Defender Security app to allow specific apps
- Open the Windows Security by
selecting the shield icon in the
task bar or searching the start menu
for Defender. - Select the Virus & threat
protection tile (or the shield
icon on the left menu bar) and then
select Ransomware protection. - Under the Controlled folder
access section, select Allow an
app through Controlled folder
access - Select Add an allowed app and
follow the prompts to add apps. You
need to allow access to
soffice.bin
3rd Party Anti-virus
If you do have a third party anti-virus go into settings and then look for something like anti-ransomware or folder protection. Have a look at the blocked apps list, if you see soffice.bin in there change it to Allowed (you might have to read AV help if not obvious). Otherwise go to the Allowed Apps setting and allow soffice.bin, this might not be easy so you might have to add the different LibreOffice executables (Calc, Writer, etc.) to the Allowed list. Note that 3rd party anti-virus might make files Read Only so you can create a new file but you can’t save it subsequently. Sometimes, you might need to reboot after allowing a program access.
Cheers, Al
Al, Thank you. Appears to be working well in Calc.