Custom View not working in Excel 2007

[mesteptoe]

I have a large spreadsheet from which I need to create separate Reports by hiding various rows and columns. I have followed instructions for creating a couple of Custom Views (View tab, Custom Views, Add, Inserted Name, OK, Saved the document) but nothing happens apart from getting the message "Some view settings could not be applied". In fact none of the view settings were applied.

Any help welcomed.

Thanks

Graham

 

[Andrew Poulsom]

Is the worksheet protected?