p01 Kansas City Southern
Skip to main content

Recent Topics

xx
New Windows 10 PC
by Tracy
Today at 11:37:40 AM

xx
Time Machine and OS Install
by Tracy
Today at 11:35:46 AM

poll
Poll: Work Lighting
by Tracy
Today at 09:42:12 AM

xx
Office 365 Outlook
by frailer
December 09, 2018, 05:13:58 AM

xx
Whole of job corruption upstream?
by frailer
December 09, 2018, 05:10:44 AM

xx
A way to find a pdf page size from acrobat reader?
by Tracy
December 06, 2018, 02:55:57 PM

xx
Paper "scam"
by born2print
December 06, 2018, 12:23:25 PM

Topic: "Grant Access" in Excel 2016 (Read 7032 times) previous topic - next topic

"Grant Access" in Excel 2016

At my new job, we are doing a lot of variable data for mailing using the merge features of Publisher and InDesign. Yuck, I know. When we launch our Excel files, we get this button that we have to press that says, "Grant Access," and when we do, it denies it anyway and we an't get in. On Sierra for Mac. No such issues on the Windows side. Any ideas how to disable this feature?
"I'm not addicted to cocaine. I just like the way it smells."
– Richard Pryor

“Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut.”
― Ernest Hemingway

Re: "Grant Access" in Excel 2016

Reply #1
Is this message from Mac OS Sierra, Excel, or InDesign? Does it ask for an admin account password.

Are your Mac Security & Privacy settings set to 'Allow apps downloaded from:'

set to:

'App Store and identified developers'?
Mac OS 10.12 Sierra | Prinergy 7.5 | Adobe Creative Cloud 2017 | Two Luscher XPose 160 CTP units

Prepress: One who does precision guess work based on unreliable data provided by those of questionable knowledge.

Re: "Grant Access" in Excel 2016

Reply #2
The message is from Excel. It apparently needs a "secure" folder. I found a temporary workaround; copy the file into User/Library/Group Containers/UBF8T346G9.Office/Excel folder. From there you can open and save without issue. But you can never move the file to another location if you want to keep working with it. Unfortunately for us, that's the issue. We ned to figure out how to create our server as a safe location so we don't have to constantly use this folder.
"I'm not addicted to cocaine. I just like the way it smells."
– Richard Pryor

“Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut.”
― Ernest Hemingway

Re: "Grant Access" in Excel 2016

Reply #3
Here is a page that tells the 'why it is doing that' but their solution is the same as yours.
Mac OS 10.12 Sierra | Prinergy 7.5 | Adobe Creative Cloud 2017 | Two Luscher XPose 160 CTP units

Prepress: One who does precision guess work based on unreliable data provided by those of questionable knowledge.

Re: "Grant Access" in Excel 2016

Reply #4
Here is a page that tells the 'why it is doing that' but their solution is the same as yours.
What page?
"I'm not addicted to cocaine. I just like the way it smells."
– Richard Pryor

“Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut.”
― Ernest Hemingway

Re: "Grant Access" in Excel 2016

Reply #5
I sent it to you telepathically. :rotf:

But here it is the old fashioned way: http://www.rondebruin.nl/mac/mac034.htm
Mac OS 10.12 Sierra | Prinergy 7.5 | Adobe Creative Cloud 2017 | Two Luscher XPose 160 CTP units

Prepress: One who does precision guess work based on unreliable data provided by those of questionable knowledge.

Re: "Grant Access" in Excel 2016

Reply #6
yeah... that's exactly where I got my info before I posted here
"I'm not addicted to cocaine. I just like the way it smells."
– Richard Pryor

“Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut.”
― Ernest Hemingway

Re: "Grant Access" in Excel 2016

Reply #7
Shut off font management.

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_word-mso_mac/office-2016-for-mac-grant-access-error/784990ca-8565-44ce-9b0a-07959eeda6c2
Speed doesn't kill, rapidly becoming stationary is the problem

I'd rather have stories told than be telling stories of what I could have done.

It's more like grip, grip, grip, noise, then spin and 2 feet in and feel shame.
I once knew a plus-sized girl and this pretty much describes teh secks. :rotf:
They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety.
         —Benjamin Franklin

My other job

Re: "Grant Access" in Excel 2016

Reply #8
Shut off font management.

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_word-mso_mac/office-2016-for-mac-grant-access-error/784990ca-8565-44ce-9b0a-07959eeda6c2
In this shop, not really possible.
"I'm not addicted to cocaine. I just like the way it smells."
– Richard Pryor

“Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut.”
― Ernest Hemingway

Re: "Grant Access" in Excel 2016

Reply #9
It was something I saw that would easily relate to our line of work. It might help if the powers that be are understanding.

HA, HA, who am I kidding.  :hangme:
Speed doesn't kill, rapidly becoming stationary is the problem

I'd rather have stories told than be telling stories of what I could have done.

It's more like grip, grip, grip, noise, then spin and 2 feet in and feel shame.
I once knew a plus-sized girl and this pretty much describes teh secks. :rotf:
They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety.
         —Benjamin Franklin

My other job

Re: "Grant Access" in Excel 2016

Reply #10
Shut off font management.

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_word-mso_mac/office-2016-for-mac-grant-access-error/784990ca-8565-44ce-9b0a-07959eeda6c2
In this shop, not really possible.

Just wondering if you have tried Repairing Permissions with an app like Onyx?

Or are you wanting to store it somewhere else like a Windows server?
Mac OS 10.12 Sierra | Prinergy 7.5 | Adobe Creative Cloud 2017 | Two Luscher XPose 160 CTP units

Prepress: One who does precision guess work based on unreliable data provided by those of questionable knowledge.

Re: "Grant Access" in Excel 2016

Reply #11
Basically the solution is to make an alias of the Excel folder in Group Containers and copy stuff into it you want to work on, and then save to that same folder and copy out when you are finished. It's an extra step, but all other solutions work once and then never again for some reason. The guy that does the IT work here is a prick, so he won't fix the permissions on the server.
"I'm not addicted to cocaine. I just like the way it smells."
– Richard Pryor

“Always do sober what you said you'd do drunk. That will teach you to keep your mouth shut.”
― Ernest Hemingway