Author Topic: "Grant Access" in Excel 2016  (Read 9817 times)

0 Members and 2 Guests are viewing this topic.

Offline DigiCorn

  • A legend in my own mind
  • Supreme Ninja
  • ***
  • Posts: 14769
  • Gender: Male
  • There is no Dana, only Zul!
    • Clerks.
"Grant Access" in Excel 2016
« on: February 08, 2017, 07:15:33 PM »
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

Offline Joe

  • Master of Nothing
  • Administrator
  • Ninja Warlord
  • *****
  • Posts: 36414
  • Gender: Male
    • B4Print.com
Re: "Grant Access" in Excel 2016
« Reply #1 on: February 08, 2017, 09:25:20 PM »
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.14.3 Mojave | Prinergy 8.2 | Adobe Creative Cloud 2019 | Two Luscher XPose 160 CTP units

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

Offline DigiCorn

  • A legend in my own mind
  • Supreme Ninja
  • ***
  • Posts: 14769
  • Gender: Male
  • There is no Dana, only Zul!
    • Clerks.
Re: "Grant Access" in Excel 2016
« Reply #2 on: February 09, 2017, 11:17:58 AM »
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

Offline Joe

  • Master of Nothing
  • Administrator
  • Ninja Warlord
  • *****
  • Posts: 36414
  • Gender: Male
    • B4Print.com
Re: "Grant Access" in Excel 2016
« Reply #3 on: February 09, 2017, 12:41:47 PM »
Here is a page that tells the 'why it is doing that' but their solution is the same as yours.
Mac OS 10.14.3 Mojave | Prinergy 8.2 | Adobe Creative Cloud 2019 | Two Luscher XPose 160 CTP units

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

Offline DigiCorn

  • A legend in my own mind
  • Supreme Ninja
  • ***
  • Posts: 14769
  • Gender: Male
  • There is no Dana, only Zul!
    • Clerks.
Re: "Grant Access" in Excel 2016
« Reply #4 on: February 09, 2017, 03:38:44 PM »
Quote from: Joe date=1486662107 link=msg=288260

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

Offline Joe

  • Master of Nothing
  • Administrator
  • Ninja Warlord
  • *****
  • Posts: 36414
  • Gender: Male
    • B4Print.com
Re: "Grant Access" in Excel 2016
« Reply #5 on: February 09, 2017, 04:54:30 PM »
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.14.3 Mojave | Prinergy 8.2 | Adobe Creative Cloud 2019 | Two Luscher XPose 160 CTP units

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

Offline DigiCorn

  • A legend in my own mind
  • Supreme Ninja
  • ***
  • Posts: 14769
  • Gender: Male
  • There is no Dana, only Zul!
    • Clerks.
Re: "Grant Access" in Excel 2016
« Reply #6 on: February 09, 2017, 07:43:36 PM »
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

Offline Farabomb

  • #NoLivesMatter
  • Supreme Ninja
  • ***
  • Posts: 17207
  • Gender: Male
  • Wait, what?
    • My other job
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.

Quote from: Ear date=1459965256 link=msg=278846
Quote from: Farabomb date=1459964381 link=msg=278844
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

Offline DigiCorn

  • A legend in my own mind
  • Supreme Ninja
  • ***
  • Posts: 14769
  • Gender: Male
  • There is no Dana, only Zul!
    • Clerks.
Re: "Grant Access" in Excel 2016
« Reply #8 on: February 10, 2017, 11:23:09 AM »
Quote from: Farabomb date=1486732523 link=msg=288280

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

Offline Farabomb

  • #NoLivesMatter
  • Supreme Ninja
  • ***
  • Posts: 17207
  • Gender: Male
  • Wait, what?
    • My other job
Re: "Grant Access" in Excel 2016
« Reply #9 on: February 10, 2017, 11:41:33 AM »
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.

Quote from: Ear date=1459965256 link=msg=278846
Quote from: Farabomb date=1459964381 link=msg=278844
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

Offline Joe

  • Master of Nothing
  • Administrator
  • Ninja Warlord
  • *****
  • Posts: 36414
  • Gender: Male
    • B4Print.com
Re: "Grant Access" in Excel 2016
« Reply #10 on: February 10, 2017, 01:20:09 PM »
Quote from: DigiCorn date=1486743789 link=msg=288296

Quote from: Farabomb date=1486732523 link=msg=288280

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.14.3 Mojave | Prinergy 8.2 | Adobe Creative Cloud 2019 | Two Luscher XPose 160 CTP units

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

Offline DigiCorn

  • A legend in my own mind
  • Supreme Ninja
  • ***
  • Posts: 14769
  • Gender: Male
  • There is no Dana, only Zul!
    • Clerks.
Re: "Grant Access" in Excel 2016
« Reply #11 on: February 20, 2017, 03:21:50 PM »
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