p01 Kansas City Southern
Skip to main content

Recent Topics

xx
Proofing for uncoated stocks - suggestions?
by david
May 25, 2018, 09:26:21 AM

clip
New press
by Slappy
May 24, 2018, 12:39:25 PM

xx

xx
PitStop 2018 just announced. Ships in April
by Joe
May 22, 2018, 01:37:18 PM

angry
Trouble with InD VDP
by delooch
May 21, 2018, 06:01:35 PM

xx
Adobe Creative Cloud Price Increases
by Joe
May 17, 2018, 05:48:25 PM

xx
PKG Installer Inspection
by Slappy
May 17, 2018, 01:36:00 PM

xx
Business Card order
by scottrsimons
May 16, 2018, 10:27:26 AM

xx
Ink saving,4d colour conversion
by danydany
May 16, 2018, 10:10:07 AM

clip
java and 3D Export
by Joe
May 15, 2018, 08:42:11 PM

xx
Individual Page Proofs
by Slappy
May 14, 2018, 11:12:05 PM

xx
Prinergy 1st Refines Questions
by DPSprint
May 14, 2018, 10:48:01 PM

xx
Xeikon Indigo toner press Iso standards
by danydany
May 14, 2018, 10:21:55 AM

Topic: "Grant Access" in Excel 2016 (Read 4560 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