Discussion on:

Office challenge: Why is an Excel custom view generating an error?

The reason why the user is getting the specified error is becasue some of the columns or cells specified in the custom view may be protected and hence Excel prevents them from being viewed. If the user un-protects the excel sheet, user will no longer face that issue.