software

I have a worksheet with 3000 rows and 20 columns for many users to access,
one at a time (not share file). The first row is the header and I have
applied auto filter so that the user can filter the relevant row for adding
data on the worksheet. I also set freeze pane on cell B2, so that the data
on the first column and first row are always visible when scrolling left or
scrolling down.
The problem I have frequently is that the freeze pane may be moved to other
cell, say B1000, without my notice. When the next user select the auto
filter on the header row, sometime they may not scroll the resulting rows
because the freeze row 1000 is beyond the display screen.
Any idea how the freeze pane position may change to another row? Whenever
this problem occur, I have to unfreeze pane, remove autofilter, goto cell B2,
select freeze pane to reset. But I want to find out the reason so that I
don't have to reset the freeze pane again and again.
Thanks in advance.

Hi Marisa

I may be totally off track here, but the magic number 1000 caught my
eye.
With Autofilter, 1000 rows is the maximum numbers of rows that can
display in the Filter.
Maybe, if you just chose Datagt;Filtergt;Show All, you would get back to
your normal freeze panes view based on row 2.
Just a thought.

I have an Icon for Show All on my normal toolbar.
Right click on the toolbar area, select Customisegt;Datagt;left click on
Show All and drag it to your Toolbargt;Close

--
Regards

Roger Govierquot;Marisaquot; gt; wrote in message
...
gt;I have a worksheet with 3000 rows and 20 columns for many users to
gt;access,
gt; one at a time (not share file). The first row is the header and I
gt; have
gt; applied auto filter so that the user can filter the relevant row for
gt; adding
gt; data on the worksheet. I also set freeze pane on cell B2, so that the
gt; data
gt; on the first column and first row are always visible when scrolling
gt; left or
gt; scrolling down.
gt; The problem I have frequently is that the freeze pane may be moved to
gt; other
gt; cell, say B1000, without my notice. When the next user select the
gt; auto
gt; filter on the header row, sometime they may not scroll the resulting
gt; rows
gt; because the freeze row 1000 is beyond the display screen.
gt; Any idea how the freeze pane position may change to another row?
gt; Whenever
gt; this problem occur, I have to unfreeze pane, remove autofilter, goto
gt; cell B2,
gt; select freeze pane to reset. But I want to find out the reason so
gt; that I
gt; don't have to reset the freeze pane again and again.
gt; Thanks in advance.
Roger,

Slightly misleading terminology - it is the autofilter pull-down list
which is limited to 1000 unique values (fill a blank column with a
sequence 1 to 2000 then filter it to see), not the number of rows that
can be filtered, as you may have several duplicates of these 1000
values.

PeteHi Roger, and Pete,
Thanks very much for your hint :-)
Marisa

quot;Roger Govierquot; wrote:

gt; Hi Marisa
gt;
gt; I may be totally off track here, but the magic number 1000 caught my
gt; eye.
gt; With Autofilter, 1000 rows is the maximum numbers of rows that can
gt; display in the Filter.
gt; Maybe, if you just chose Datagt;Filtergt;Show All, you would get back to
gt; your normal freeze panes view based on row 2.
gt; Just a thought.
gt;
gt; I have an Icon for Show All on my normal toolbar.
gt; Right click on the toolbar area, select Customisegt;Datagt;left click on
gt; Show All and drag it to your Toolbargt;Close
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;Marisaquot; gt; wrote in message
gt; ...
gt; gt;I have a worksheet with 3000 rows and 20 columns for many users to
gt; gt;access,
gt; gt; one at a time (not share file). The first row is the header and I
gt; gt; have
gt; gt; applied auto filter so that the user can filter the relevant row for
gt; gt; adding
gt; gt; data on the worksheet. I also set freeze pane on cell B2, so that the
gt; gt; data
gt; gt; on the first column and first row are always visible when scrolling
gt; gt; left or
gt; gt; scrolling down.
gt; gt; The problem I have frequently is that the freeze pane may be moved to
gt; gt; other
gt; gt; cell, say B1000, without my notice. When the next user select the
gt; gt; auto
gt; gt; filter on the header row, sometime they may not scroll the resulting
gt; gt; rows
gt; gt; because the freeze row 1000 is beyond the display screen.
gt; gt; Any idea how the freeze pane position may change to another row?
gt; gt; Whenever
gt; gt; this problem occur, I have to unfreeze pane, remove autofilter, goto
gt; gt; cell B2,
gt; gt; select freeze pane to reset. But I want to find out the reason so
gt; gt; that I
gt; gt; don't have to reset the freeze pane again and again.
gt; gt; Thanks in advance.
gt;
gt;
gt;