It sounds like you're experiencing significant issues with Excel, particularly with file protection and saving capabilities. Here are some potential reasons and solutions for the problems you described:
- File Protection: If your files are coming up as protected, it may be due to permissions settings. Ensure that you have the necessary permissions (read, write, modify, delete) for the folder where you are trying to save your files. If you only have read permissions, you won't be able to make changes.
- Third-Party Add-Ins: Sometimes, third-party add-ins can interfere with Excel's functionality, including saving files. You can try starting Excel in Safe Mode to see if the issue persists. To do this, hold down the Ctrl key while starting Excel, and then try saving your file again.
- Saving Issues: If you're unable to save files, consider trying to save the workbook with a new file name or in a different file format. You can do this by selecting Save As from the File menu and choosing a unique name or a different format (like .xlsx or .xlsm).
- Exporting from Sage 50: If you're having trouble exporting files from Sage 50, it might be related to how the software interacts with Excel. Ensure that both programs are updated to their latest versions, as compatibility issues can arise with outdated software.
- Temporary Files: If the saving process is interrupted, Excel may not save correctly. Check for any temporary files in the folder where you are trying to save your work, as they could indicate issues with the save process.
If these suggestions do not resolve your issues, you may want to reach out to Microsoft Support for further assistance, especially since your work as a professional bookkeeper relies heavily on these tools.
References: