You don't have permission to add a Form to this shared workbook.

%3CLINGO-SUB%20id%3D%22lingo-sub-1508620%22%20slang%3D%22en-US%22%3EYou%20don't%20have%20permission%20to%20add%20a%20Form%20to%20this%20shared%20workbook.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1508620%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20create%20a%20Form%20for%20Excel%20in%20onedrive%20but%20I%20am%20experiencing%20the%20error%20message%3A%20You%20don't%20have%20permission%20to%20add%20a%20Form%20to%20this%20shared%20workbook.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20folder%20that%20i'm%20trying%20to%20create%20this%20in%20is%20one%20that%20has%20been%20shared%20by%20my%20colleague%20with%20me%20and%20I%20have%20permissions%20to%20access%20it.%20What%20happens%20is%20that%20the%20Excel%20Sheet%20is%20created%20ok%20and%20can%20be%20opened%20(and%20edited)%20but%20the%20Form%20loads%20in%20another%20tab%20and%20after%20a%20few%20seconds%20gives%20the%20above%20errror%20message.%20I%20noticed%20it%20says%20%22saving...%22%20at%20the%20top%20before%20giving%20the%20error.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20created%202%20other%20forms%20for%20excel%20in%20exactly%20the%20same%20way%20in%20the%20past%20in%20the%20same%20folder%20which%20work%20perfectly%20so%20I'm%20puzzled%20why%20it's%20not%20working.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20help%3F%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1508620%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOneDrive%20for%20Business%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1551814%22%20slang%3D%22en-US%22%3ERe%3A%20You%20don't%20have%20permission%20to%20add%20a%20Form%20to%20this%20shared%20workbook.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1551814%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F297522%22%20target%3D%22_blank%22%3E%40reprised%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOur%20users%20are%20having%20the%20exact%20same%20issue.%20I%20cannot%20find%20a%20resolve%20posted%20for%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

 

I am trying to create a Form for Excel in onedrive but I am experiencing the error message: You don't have permission to add a Form to this shared workbook.

 

The folder that i'm trying to create this in is one that has been shared by my colleague with me and I have permissions to access it. What happens is that the Excel Sheet is created ok and can be opened (and edited) but the Form loads in another tab and after a few seconds gives the above errror message. I noticed it says "saving..." at the top before giving the error.

 

I have created 2 other forms for excel in exactly the same way in the past in the same folder which work perfectly so I'm puzzled why it's not working.

 

Can anyone help?

Thanks

2 Replies

@reprised 

Our users are having the exact same issue. I cannot find a resolve posted for this.

this might be an old issue, but we are experiencing as well

Try checking on your O365 Group linked to the sharepoint site, and check if the group has permissions on the library and if the users are members of the group

We have found out that when the permission of the linked group to the library are removed
or when the user is removed from the linked group, then you receive that access error.

My theory is that Forms is trying to access the Excel file by using the O365 Linked group instead of the actual user account thus, getting the access error.