Excel Saving Violation on External Hard Drive

%3CLINGO-SUB%20id%3D%22lingo-sub-1094461%22%20slang%3D%22en-US%22%3EExcel%20Saving%20Violation%20on%20External%20Hard%20Drive%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1094461%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20WD%20Elements%20external%20hard%20drive%20which%20is%20directly%20usb%20hooked%20up%20to%20my%20Mac%20mini%20which%20is%20where%20we%20store%20all%20our%20data.%20This%20in%20turn%20is%20backed%20up%20through%20our%20home%20network%20to%20a%20WD%20MyCloudMirror%20device.%20I%20can%20save%20an%20Excel%20file%20in%20.xlsm%20format%20and%20also%20.xlsb%20for%20the%20first%20time%20on%20to%20the%20WD%20Element%20drive%2C%20however%20if%20I%20make%20a%20change%20or%20want%20to%20re-save%20the%20file%20and%20in%20theory%20overwrite%20the%20original%20file%20I%20receive%20the%20following%20warning%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3E'Your%20changes%20could%20not%20be%20saved%20to%20'Home%20Budget%20Planner%202020.xlsx'%20because%20of%20a%20sharing%20violation.%20Try%20saving%20to%20a%20different%20file.'%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20followed%20by%20these%20two%20messages%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3E'The%20file%20format%20and%20extension%20of%20%E2%80%9942D87A00.MACTF%E2%80%99%20don%E2%80%99t%20match.%20The%20file%20could%20be%20corrupted%20or%20unsafe.%20Unless%20you%20trust%20its%20source%2C%20don%E2%80%99t%20open%20it.%20Do%20you%20want%20to%20open%20it%20anyway%3F'%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3E'Your%20changes%20could%20not%20be%20saved%20to%20'Home%20Budget%20Planner%202020.xlsx'%2C%20but%20were%20saved%20to%20a%20temporary%20document%20named%20'42D87A00.MACTF'.%20Close%20the%20existing%20document%2C%20then%20open%20the%20temporary%20document%20and%20save%20it%20under%20a%20new%20name.'%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20WD%20elements%20drive%20has%20been%20for%20ExFAT%20so%20should%20work%20to%20that%20capacity.%20All%20share%20options%20have%20been%20set%20as%20read%20%26amp%3B%20write%2C%20so%20I'm%20not%20too%20sure%20why%20this%20violation%20keeps%20popping%20up.%20I%20can%20save%20the%20file%20directly%20to%20the%20Mac%20and%20rewrite%20over%20it%20no%20problem%2C%20its%20just%20saving%20it%20to%20an%20external%20source%20which%20seems%20to%20be%20the%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20apps%20and%20drives%20etc%20are%20fully%20up%20today%20from%20what%20I%20can%20tell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHopefully%20someone%20can%20help%20solve%20what%20should%20be%20a%20simple%20solution%20I%20would%20imagine%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1094461%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1143050%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Saving%20Violation%20on%20External%20Hard%20Drive%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1143050%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F509029%22%20target%3D%22_blank%22%3E%40PhilTWP%3C%2FA%3E%26nbsp%3BI%20am%20receiving%20the%20very%20same%20message.%26nbsp%3B%20Look%20forward%20to%20reading%20any%20resolution.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Regular Visitor

Hi there,

 

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. This in turn is backed up through our home network to a WD MyCloudMirror device. I can save an Excel file in .xlsm format and also .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:

 

'Your changes could not be saved to 'Home Budget Planner 2020.xlsx' because of a sharing violation. Try saving to a different file.'

 

Then followed by these two messages:

 

'The file format and extension of ’42D87A00.MACTF’ don’t match. The file could be corrupted or unsafe. Unless you trust its source, don’t open it. Do you want to open it anyway?'

 

'Your changes could not be saved to 'Home Budget Planner 2020.xlsx', but were saved to a temporary document named '42D87A00.MACTF'. Close the existing document, then open the temporary document and save it under a new name.'

 

The WD elements drive has been for ExFAT so should work to that capacity. All share options have been set as read & write, so I'm not too sure why this violation keeps popping up. 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.

 

All apps and drives etc are fully up today from what I can tell.

 

Hopefully someone can help solve what should be a simple solution I would imagine?

 

Many thanks

1 Reply

@PhilTWP I am receiving the very same message.  Look forward to reading any resolution.