Home

Excel asking to grant access on Mac

%3CLINGO-SUB%20id%3D%22lingo-sub-903826%22%20slang%3D%22en-US%22%3EExcel%20asking%20to%20grant%20access%20on%20Mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-903826%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EMany%20Mac%20computers%20in%20my%20company%20suddenly%20started%20to%20experience%20intermittent%20%22Grant%20Access%22%20dialogs%20upon%20saving%20Excel%20files%20on%20desktop.%20The%20timing%20for%20all%20of%20these%20computers%20seems%20more%20than%20a%20coincidence.%20In%20conjunction%20with%20this%20timing%2C%20some%20users%20have%20various%20problems%20saving%20(causing%20Excel%20to%20freeze%20and%20must%20be%20force-quit)%20or%20re-opening%20files%20(Excel%20file%20can%20not%20be%20read%20and%20opened%2C%20and%20I%20had%20to%20load%20the%20files%20in%20Google%20Sheets%20to%20retrieve%20the%20data%2C%20which%20appeared%20perfectly%20intact).%20If%20a%20file%20is%20passed%20to%20another%20computer%2C%20it%20opens%20fine%2C%20so%20it's%20not%20a%20file%20issue%20-%20it's%20a%20software%20issue.%20All%20software%20is%20updated%2C%20and%20these%20are%20locally%20stored%20files%20-%20they%20are%20not%20on%20OneDrive%2C%20nor%20are%20they%20shared.%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EWe%20have%20reset%20permissions%20on%20the%20Mac%20per%20Microsoft's%20guidance%2C%20but%20that%20didn't%20resolve%20the%20issue.%20Our%20only%20work-around%20is%20uninstalling%20Excel%20version%2016%2C%20and%20reverting%20back%20to%20Excel%20version%2015%2C%20but%20that%20is%20not%20a%20long%20term%20solution%20because%20it%20means%20we%20can't%20perform%20software%20updates.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThis%20has%20been%20plaguing%20us%20since%20version%2016%20was%20introduced.%20Some%20computers%20encounter%20it%20more%20than%20others%2C%20and%20if%20a%20computer%20doesn't%20experience%20this%20often%2C%20I%20didn't%20revert%20that%20one%20back%20to%20version%2015.%20However%2C%20for%20the%20remaining%20computers%20who%20are%20stuck%20in%20version%2015%2C%20I%20need%20to%20eventually%20let%20them%20start%20updating%20again%2C%20although%20the%20users%20of%20those%20computers%20won't%20let%20me%20upgrade%20them%20until%20I%20am%20100%25%20confident%20in%20the%20solution.%20They%20don't%20want%20to%20be%20guinea%20pigs%20for%20testing%20solutions.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EDoes%20anyone%20know%20how%20to%20resolve%20this%20issue%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-903826%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
adambernhardt
New Contributor

Many Mac computers in my company suddenly started to experience intermittent "Grant Access" dialogs upon saving Excel files on desktop. The timing for all of these computers seems more than a coincidence. In conjunction with this timing, some users have various problems saving (causing Excel to freeze and must be force-quit) or re-opening files (Excel file can not be read and opened, and I had to load the files in Google Sheets to retrieve the data, which appeared perfectly intact). If a file is passed to another computer, it opens fine, so it's not a file issue - it's a software issue. All software is updated, and these are locally stored files - they are not on OneDrive, nor are they shared.

 

We have reset permissions on the Mac per Microsoft's guidance, but that didn't resolve the issue. Our only work-around is uninstalling Excel version 16, and reverting back to Excel version 15, but that is not a long term solution because it means we can't perform software updates.

 

This has been plaguing us since version 16 was introduced. Some computers encounter it more than others, and if a computer doesn't experience this often, I didn't revert that one back to version 15. However, for the remaining computers who are stuck in version 15, I need to eventually let them start updating again, although the users of those computers won't let me upgrade them until I am 100% confident in the solution. They don't want to be guinea pigs for testing solutions.

 

Does anyone know how to resolve this issue?

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies