Your suspicion that the issue happens on overwriting the data is completely correct This is entirely a permissions issue between your MacOS, Excel client, and the WD external hard drive. Excel does not have the proper permissions to overwrite the existing file where you have it hosted (in this case, your external hard drive).Ĭreating and saving a new file to the External hard drive works without issue because you're not overwriting existing data, you're creating new data. You can open the file, you can close the file, you can edit the instance of the file you have open, but the second you try to commit the file changes, you will encounter this error. Like mentioned above, I am able to close excel and open the file direct from the external drive, I just can't save any changes without saving the file with a new name.īasically the Excel file is stuck opening in a fake read-only mode. When I carry out the following File > Save the external hard drive location appears but the. This is when the violation message occurs. This works fine, then without making any changes and keeping the file still open I select the little disk (save) icon at the top of the excel toolbar. However I am able to open the file in excel, I just can't re-save it.Ĭreate new excel workbook > File > Save As > Home Drive (the USB external hard drive name) > Documents (subfolder) > Finance (subfolder) > Save (.xlsx) Gave extra detail on the mirror back-ups just incase the file changes its permmissions once backed up to the mirror over the network. The mirror is purely on the network to back up the external hard drive as a fail safe, which it does automatically as soon as new data is saved down onto the hard drive. Excel files are being saved on to the external hard drive directly (usb connection) and not the mini hard drive or through the network to the mirror. The cloud mirror is connected to the network. The external hard drive is usb connected directly to the mini. Hopefully someone can help solve what should be a simple solution I would imagine? I can save the file directly to the Mac and rewrite over it no problem, its just saving it to an external source which seems to be the problem.Īll apps and drives etc are fully up today from what I can tell. All share options have been set as read & write, so I'm not too sure why this violation keeps popping up. The WD elements drive has been for ExFAT so should work to that capacity. Close the existing document, then open the temporary document and save it under a new name.' 'Your changes could not be saved to 'Home Budget Planner 2020.xlsx', but were saved to a temporary document named '42D87A00.MACTF'. Unless you trust its source, don’t open it. 'The file format and extension of ’42D87A00.MACTF’ don’t match.
'Your changes could not be saved to 'Home Budget Planner 2020.xlsx' because of a sharing violation. xlsb for the first time on to the WD Element drive, however if I make a change or want to re-save the file and in theory overwrite the original file I receive the following warning:
This in turn is backed up through our home network to a WD M圜loudMirror device.
I have a WD Elements external hard drive which is directly usb hooked up to my Mac mini which is where we store all our data.
0 kommentar(er)
