As outlined in the video tutorial it works perectly....however, what i'm really after is doing the same thing whilst having the "Allow Users to Edit Ranges" in place. It seems the online version doesn't allow for cell protection for users but the nature of my data doesn't permit each user to see what the other is inputting.
I tried the alternate merge format by emailing a separate copy to each user and merge the final copy and that DIDNT worked either. Seems like there's no user rights access for the Online version.
i can get it to work using share/copy/merge legacy option on the destop or Office365 version but not all users have excel destop or Office 365 and I'd also want them to access the file on any device hence the Online version would have been perfect. Guess i'll have to employ the legacy destop and 365 methods only.
unless u can think of another work around.