<div>
Just to clarify, your Macs work, but Win 10 not?<br>And xls can be saved, xlsx not?<br>Your description confuses me a bit.<br>What is working where, what not?<br>What is the target? A file share?&nbsp;<br><br>- But in general, if you can write one format, but not the other, it doesn't have to do with permissions.<br>- UAC (Windows) may play a role (some system folders you can only write with administrative permission, even you are admin), but would not explain, why one format works, the other not. <br>- Excel has some settings to avoid opening or saving old formats. You can set them in the Options - security center - . <br>The settings are a bit confusion, everything what is checked there is denied. <br>- Last but not least, Virus scanners sometime develop their own live, just a point top check. <br><br>
</div>


<div>
thanks - clarifications:<br><br>Just to clarify, your Macs work, but Win 10 not?<br>No the opposite, MACS do not save xlsx, Win 10 does<br><br>And xls can be saved, xlsx not?<br>YES<br>Your description confuses me a bit.<br>Sorry<br>What is working where, what not?<br>No save as on macs, yes save, no save as. Only xlsx is problem<br><br>What is the target? A file share?<br>No, local disks, external such as one drive DOES save.
</div>


<div>
Can you save the files in other locations? &nbsp;Did you check the system preferences &nbsp;privacy settings to see if your Excel can save to the locations?
</div>


<div>
On each mac I cannot "save as" xlsx to the local hard disk. <br>I can save to off disk locations like one drive.<br><br>I have recently been trying an addin that turns out works only on Windows. <br>Also been running VBA snippets.<br>I will re test a few locations again now<br><br>
</div>


<div>
MacBookAir<br>dropbox local - no<br>icloud drive local - no<br>onedrive cloud - YES<br><br>Just tried on Mac Mini<br>No xlsx save on local disk<br>When trying save to onedrive cloud I was required to "Grant access", whihc then worked when i followed the links
</div>


<div>
So, it looks like a MacOS problem, right?<br>At least windows maintains a list of "trusted" file locations. <br>But this would not explain why XLS works and XLSX not. <br><br>You talked about VBA snippets. <br>XLSX can not have macros, you have to save it as XLSM.<br>Maybe this is the issue?
</div>


<div>
No xlsm is neo issue as vba is disabled<br>I suspec Office 365 because it is across all macs, not just one and no problem on Windows 10 but I cannot find a setting, despite having a message on one occasion on one mac saying I did not have permission from the admin (who is myself) to edit on macs <br><br>where is the list of trusted file locations?
</div>


<div>
ok found that.<br><br>So, three Mac s'Excel won't save xlsx files to Mac local disks.&nbsp;
</div>


<div>
I think this is a setting or policy set in 365 Admin online, or in Windows 10 that propagates, because each time I reinstall on Mac I see "privacy settigs" being downloaded from the cloud.<br><br>Any help here?&nbsp;
</div>


Owner

Anthony Mellor

<div>
Ok so reinstalled office on all three macs. The first two I noticed a privacy settings download being applied when starting up. So for mac 3 I copied the installer from one of the others, disconnected from the internet and ran the install, had to allo an auto update, but disconnected again before that could do anythong else.<br><br>Now "save as " XLSX works. I am sure now this is an Office Admin Online settigns matter.
</div>


<div>
The trusted file location is<br>File - Options - Trust Center - Trust Center Settings - Trusted locations.<br><br>Thanks, yes found it, no such thing on Mac.<br><br>At least under Windows Excel. Possibly Preferences on MacOS<br><br>Nothing there.<br><br>Does three Macs mean all of your Macs?<br><br>Yes.&nbsp;<br><br>Or do you have a working mac? Just to compare the settings?<br><br>No.&nbsp;<br><br>Are you in a corporate network? It ist possible, that you IT-Staff defined some Settings?<br><br>No, I am the Admin.<br><br>Have you checked Security and Privacy? Under privacy you can set Access Permissions for Applications.<br><br>Yes, will look again though.<br><br>Have you checked Word in docx format?<br><br>Yes, works ok.<br><br>Have you tried to start the Mac in save mode?<br><br>Safe mode. Not yet.<br><br>Have you checked with a different user (clean profile)?<br><br>Yes. Good question.<br><br>At least make sure for testing, that the file name doesn't contain special characters.<br><br>It doesn't. Tried all sorrts of files and names.<br><br>As you are member in the Office Insider program, <br><br>Yes.<br><br>can it be connected to an update? <br><br>I've installed several times and now got one working. This time there was no "downloading settings" notice so pretty sure that is/was the issue. Still not found where tehse are set.&nbsp;<br><br>Has it worked before and when the issue was starting?<br><br>Oh yes worked for years. Started two or three days ago, noticed today.<br><br>Is your system Up to Date (MacOS as well as office)?<br><br>Yes.<br><br>Thanks for sticking with me, appreciate it.<br><br>Anthony
</div>


<div>
OK, you may have a look if any related update was installed before you recognized the issue. <br>Insider preview comes weekly, because they fix a lot of bugs as well as they create new ones. <br><br>If you have a working MAC now, you may now be able to compare the MAC OS security settings as well as the Excel settings. This looks like, that there is an administrative setting, which either affects the Mac in general or what affects Excel.<br><br>I don't think that Microsoft involves into MacOS settings, but possible that changes from one site involves into this issue. <br>Either Microsoft changed a default setting what is not correctly interpeted by the MacOS, or Apple changed something what is not yet implemented into Office for Mac. <br>Nevertheless, following your decription would lead me to the idea, that there is a central managed administrative setting, which actively changes a default setting. <br><br>So, its time now to walk through all settings on the Microsoft Online side. <br>Keep in mind that not everything, what works for MS clients may not work in the same way on Mac OS. Means the realisation on Mac may be different from Microsoft. And this my result into side effects (seen this a lot of times in the past with Apple devices).&nbsp;<br>If nothing helps, make sceen shots, revert everything to default an then enable one by one to see, which setting results into the issue. &nbsp; &nbsp;
</div>


<div>
well understood! <br>My key thought is this:<br>While my Macs auto update asap, one of them wasn't updated yet, <br>add to this, that Macs don't share their settings of this sort between each other. Sure they are all about permissions, but not to this level of granularity, an MS file type.<br>On the other hand 365 does have central policy control and it's instant, and it is only the one file type xlzx and NOT xls etc. So that really feels like an MS matter.<br><br>I've just been through the trust center yet again.. perplexed why on my last MBA (mac laptop) there was no "settings download" and then file save as xlsx worked.. in fact I'll just check this is still the case..back in a sec&nbsp;&nbsp;<br><br>
</div>


<div>
right the, MBA saves XLSX ok now.<br>MPro does not, still says no permission at location<br>Mini is redownloading to reinstall <br><br>It is conceivable that careful deletion of Mac settings files may make the difference. <br>However, those downloaded settings updates seem to me to possibly be the source of the trouble because I have never seen these before. <br><br>I have looked and looked through Windows security and privacy and Windows Excel and just can't see anything that remotely looks like "don't allow save as xlsx"
</div>


<div>
So you mentioned compare sttings.<br>That suggests comparing the above mentioned carefully deleted settings files before trying to fix the MPro.<br><br>What the one currently downloading to reinstall will do I dare not contemplate.<br><br>Do I think it's a screw up by Apple or MS? No, doesn't feel like it. Feels like an admin policy setting.<br><br>But hey, just a feeling.
</div>


<div>
so, reinstalled the MPro second time, first time reverted to current channel, this time switched it to beta channel, tested before beta channel updates were applied and saved as xlsx ok .. not sure I believe it<br><br>feels like something somewhere has been fixed. There was something about "experiences" that I unticked, having recalled ticking it very recently.. shirley not that.. this was a tick box in Windows Excel options.
</div>


<div>
Finding any settings that appear even remotely relevant is the problem, on both mac and pc
</div>


<div>
I think all three Macs are now working for "save as" as xlsx (from existing xlsx), after reinstalling in some cases twice. <br><br>Not really clear why.<br><br>There was a tick box about "experiences" in the Winodws Excel option settings which I unticked after recalling I ticjked it very recently. But don't really think that was it.<br><br>Anthony
</div>


<div>
<div class="content wysiwyg-content fr-view">
<blockquote><strong>You do not have permission to save files to this location.</strong><br>Make sure that you have write access for this location, or select a different location.</blockquote>I am at my wits' end with this.<br><br>Max OS Big Sur<br>Exel Beta channel.<br><br>ALL my Macs &nbsp;Pro, MacBook Air, Mac Mini, but NOT my DELL Win 10 Pro.<br>On one I saw a message saying the admin does not allow me to edit on macs, but I can save to off local disk locations. <br>I have checked write permissions, but in any case given this is across all mac I suspect something in my MS 365 setup, which I have not knowingly touched in ages. I CAN save the file as long as I do not attempt "save as". I can save as csv or xls just not xlsx<br><br>Other apps can save.<br><br>Do hope someone knows the answer - google suggests all the usual suspects like info/permissions etc, but this worked and suddenly does not, across all my Macs; so that suggests it is Excel related from the admin control?<br><br>Regards<br><br>Anthony
</div>
</div>



You do not have permission to save files to this location.
Make sure that you have write access for this location, or select a different location.
I am at my wits' end with this.
Max OS Big Sur
Exel Beta channel.
ALL my Macs  Pro, MacBook Air, Mac Mini, but NOT my DELL Win 10 Pro.
On one I saw a message saying the admin does not allow me to edit on macs, but I can save to off local disk locations.
I have checked write permissions, but in any case given this is across all mac I suspect something in my MS 365 setup, which I have not knowingly touched in ages. I CAN save the file as long as I do not attempt "save as". I can save as csv or xls just not xlsx
Other apps can save.
Do hope someone knows the answer - google suggests all the usual suspects like info/permissions etc, but this worked and suddenly does not, across all my Macs; so that suggests it is Excel related from the admin control?
Regards
Anthony

HELP! Please. &quot;You do not have permission to save files to this location.&quot;

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Operating systems perform basic tasks, such as recognizing input from the keyboard, sending output to the display screen, keeping track of files and directories on the disk, and controlling peripheral devices such as disk drives and printers. For large systems, the operating system makes sure that different programs and users running at the same time do not interfere with each other. The operating system is also responsible for security, ensuring that unauthorized users do not access the system. Operating systems provide a software platform on top of which other programs, called application programs, can run.

Operating Systems

Office 365 is a group of software plus services subscriptions that provides productivity software and related services to its subscribers. Office 365 allows the use of Microsoft Office apps on Windows and OS X, provides storage space on Microsoft's cloud storage service OneDrive, and grants 60 Skype minutes per month. Office 365 includes e-mail and social networking services through hosted versions of Exchange Server, Skype for Business Server, SharePoint and Office Online, integration with Yammer, as well as access to the Office software. All of Office 365's components can be managed and configured through an online portal; users can be added manually, imported from a CSV file, or Office 365 can be set up for single sign-on with a local Active Directory using Active Directory Federation Services.

Microsoft 365

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Mac OS X is the desktop operating system from Apple Inc., found on Macintosh computers. OS X consists of a Mach/BSD-based kernel, operating system interfaces primarily based on FreeBSD and additional frameworks (written in C, C++ and Objective-C providing user interface and application-level services.

HELP! Please. &quot;You do not have permission to save files to this location.&quot;

HELP! Please. "You do not have permission to save files to this location."