Permissions to "Allow users to edit ranges"

[Craig1]

Hi All,
We have a multiple spreadsheets where each sheet is limited to who can enter data only, basically each department enter their own data but others can view the data.
I have added another user to 3 spreadsheets but we can't seem to get him working. Every time he tries to add the data the system tells him to add the password.
Initially we thought we had inputted him incorrectly, but all good, the tick to allow users to make changes is ticked as it should be.
He has recently been upgraded to O365 and we had to down grade him from 64bit office to 32bit office, simply because no VBA works with the 64bit, so everyone who is required to use VBA for their job is down graded to the 32bit version, he is now on 32bit.
He has all the same settings as everyone else and all other users for his department can enter data as required, it's just this one person.
We can't work this out.
Any idea's or something you have come across that may guide us in the right direction.
I can't seem to get to the right question & answer from Google.
His user name is inputted correctly as well.

Thanks in advance.
Craig.

 

[jkpieterse]

A screen-shot of that password prompt would be helpful.

On that 32 bit Office issue: VBA works fine on 64 bit Office, but you have to make sure you convert API calls to the correct syntax and don't use any third-party libraries which are only available in 32 bit.

 

[Craig1]

Thanks for the reply Jan, some good info there regarding the 32bit and 64bit versions.
See screen grab from the spreadsheet when it is a user not recognised, or in the case of my colleague he is inputted correctly as a user but he is getting this message.

 

[jkpieterse]

When setting up the range, did you click the Permissions button and add the new user and checked the allow editing without password box:

Make sure you selected the correct user.

 

[Craig1]

Hi Jan,

 

[Craig1]

Hi Jan, thanks for the reply. Everything is exactly as you mention.

 

[jkpieterse]

Hmm. odd. If you have the user in question open a fresh Excel file and let him/her set allow edit ranges and add him/herself; does the dialog show exactly the same user+email as in your screenshot? And does it work without a password then?

 

[Craig1]

Thanks for the suggestion Jan, I will try this when I next see them, but due to holidays it won't be until mid March, i will try then and get back to the board with the results.
Thanks for the continued support.

 

[Craig1]

Hi Jan,
I have done a little more digging by having my colleague log on and see where it took us, I now know why it isn't working for him but not sure how to get round it.
Because his PC has just been upgraded to Windows 11 and most others are still on Windows 10 the permissions box looks completely different and I can see why it won't let him do anything. Basically I even tried to search for his log on name whilst on his PC and it couldn't find him, on his own PC, so it looks like the way it looks at the names has changed. See snippets (all work could be done by removing passwords etc but we need to keep away from that and use the permissions correctly).
So the one on the left is Windows 11 where the user names look nothing like our normal set up in Windows 10, on the right. Like I said, even trying to add Mark wouldn't find him when I checked his name. Any idea's guys?

 

[jkpieterse]

This sounds to me like IT hasn't set up the user properly (I have no experience with this kind of stuff however).
What users are listed under the C:\users\ folder on his Win 11 box?