Custom View Problems

[Peter Haworth]

I have defined a custom view with some hidden columns and a filter on 1
column. I checked the box to remember hidden columns, rows, and filters.
When I display the view, the filter does not seem to have any effect. If I
click on the auto filter dropdown menu at the top of the column that has a
filter, the correct filter item is highlighted and if I re-select it, the
filter works. Is there some other setting I have to enable to get this to
work correctly?

Also, I have another custom view that unhides the hidden columns and sets
the auto filter to "All" in order to get back to the normal view of my
spreadsheet. However, when I select this custom view, the rows that were
excluded by the filter in the other custom view are not displayed and I have
to do a Select All from the edit menu and then Row|Unhide from the Format
menu. Any ideas on this?

Thanks,
Pete

 

[RagDyer]

I wouild suggest that when you start off with custom views, the first thing
you do is install a "CustomView" window on your toolbar.
This enables you to tell at a glance what view you're currently using.
You could be in, for example, "The Filter One View", but if you changed a
criteria, and the filter was revised, you might not remember or realize
where you were or had been.
Also, with the "CustomView" window, you could expand it to display *all* the
views currently in the WS, and switch to any view with a single mouse click

Right click in the toolbar and,
<Customize> <Commands> tab,
Click "View" in the left window,
And click on "CustomViews" in the right window, and drag it to your toolbar.

Now, *before* you change or do anything else, *SAVE* the present, original
worksheet view as your *ORIG* view.
This allows you to immediately return to your *unchanged* WS view.

Believe it or not, XL will not allow you to "go back" to the original view,
after you've created a custom view, without *undoing* every change you've
made, step by step, unless you've created this ORIG custom view first!

You can now create then save your various views after completing your
filtering.

No matter what changes you've made, after saving a view, just click in the
"CustomView" window, and toggle between views, to return to the various
saved views, as you originally created them.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I have defined a custom view with some hidden columns and a filter on 1
column. I checked the box to remember hidden columns, rows, and filters.
When I display the view, the filter does not seem to have any effect. If I
click on the auto filter dropdown menu at the top of the column that has a
filter, the correct filter item is highlighted and if I re-select it, the
filter works. Is there some other setting I have to enable to get this to
work correctly?

Also, I have another custom view that unhides the hidden columns and sets
the auto filter to "All" in order to get back to the normal view of my
spreadsheet. However, when I select this custom view, the rows that were
excluded by the filter in the other custom view are not displayed and I have
to do a Select All from the edit menu and then Row|Unhide from the Format
menu. Any ideas on this?

Thanks,
Pete

 

[Peter Haworth]

Thanks for the suggestion, but I have already done the things you mentioned.

One other thing that might be affecting this is that I have autocalc
switched off. Does that setting affect when filters in custom views are
re-evaluated?

Pete

 

[RagDyer]

Why don't you try?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

Thanks for the suggestion, but I have already done the things you mentioned.

One other thing that might be affecting this is that I have autocalc
switched off. Does that setting affect when filters in custom views are
re-evaluated?

Pete