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.