Custom views

[Martel]

Workbook has no tables and no protected sheets. Have created several custom views but excel does not successfully switch between them e.g. view “males only” works. Switch view to show people from e.g. certain town - also works but switch back to “males” only view and it fails - includes “females as well. These are simple examples only. Have other more complex views but Excel fails to set view correctly as defined. I have tried Microsoft support but they were no help. Has anyone else experienced this issue? Thank you

 

[Martel]

[FONT=&quot][FONT=&quot]Excel Custom Views

Hi. This is not an answer to my thread. I am Martel, live in Devon and still thwarted by the excel custom view feature. I am new to this forum so apologies if i am breaking any rules. I had no replies so hoping by re-wording and re-submitting i may get some response.

My workbook has no tables or protected sheets. i have created a default custom which shows all data and columns. i then create another custom view to show ‘male’ members only. this works fine but when i select ‘default view’ again this not work - view shows ‘male’ only is still applied. anyone else experienced this problem? Perhaps I am the only person with this issue. Workbook and VBA content work fine in all other respects. Thanks in anticipation. Martel [/FONT][/FONT]

 

[My Aswer Is This]

When I try using Custom Views I have no problem

Select a range give it a custom View name

Then when you select that name from the custom view Dialog Box your taken to that custom View.

 

[Martel]

When I try using Custom Views I have no problem

Select a range give it a custom View name

Then when you select that name from the custom view Dialog Box your taken to that custom View.

Hello and thank you. Not sure if I am doing this correctly, not clued up yet on how this forum thing works.

Sorry, not understanding your range suggestion. Given that my “default view “ would be the entire sheet, how would a filter on just one column e.g ‘gender’ work. Or are you suggesting I apply the filter then give the whole sheet a range name to use as a custom view name..? Sorry if i am being wooden but thanks for your response. I will try your suggestion ASAP and get back.

 

[My Aswer Is This]

Your original post said:

Workbook has no tables and no protected sheets

But then you said:

i then create another custom view to show ‘male’ members only

How do you do this if your not using a table filter

You also said:
how would a filter on just one column e.g ‘gender’ work

A filter is normally used with a table but you said:
Workbook has no tables and no protected sheets​

_{^{<strike>
</strike>}}​

 

[Martel]

Hi. Returning to an issue which I first raised back in 2019 but never got a working solution. Would like to try again

A worksheet with only 4 columns : Firstname, Surname, ID Number and Current Y/N

Set up Custom View 1 to sort by Surname, Firstname , filter on Current Y/N to be YES

Set up Custom View 2 to sort by ID number, with same filter

Changing Custom View from ribbon does not change the view. As previously reported, there are no tables in the workbook. Has anybody else experienced this or similar issue please?