Views are a workbook feature--not a worksheet feature.

Make sure each sheet is exactly the way you want it when you define the view.

I bet you'll have to delete the offending view(s).
set up each sheet the way you like it
and redefine that view.

wrote:

I have an Excel 2003 workbook containing just two sheets and 3 custom
views. When I switch between the views, which were created for Sheet1,
Sheet2 scrolls so that the top left cell changes from B4 to C7 or from
C7 to B4 every view change.

E.g. show view2 - sheet2 scrolls so that top-left cell is C7
then show view3 - top-left cell is B4
then show view1 - top-left cell is C7
then show view2 - top-left cell is B4
and so on...

I created the views so that B4 would always be in view.

Has anyone come across a similar phenomenon - is this a bug I'm stuck
with or can I change this behaviour without having to use VBA to ensure
B4 is in view after a view change?

More detail below in case it helps...

Sheet1 is a datalist containing 80 columns and a varying number of rows
depending how much data is imported.

Sheet2 contains a number of tables (incomplete at this stage). To the
left of the tables, column A is hidden and rows 1, 2 & 3 are also
hidden. I.e. B4 is the first visible cell on Sheet2.

At this stage the hidden cells on Sheet2 contain no data but they are
coloured 'Gray-40%' as is the entire sheet. Column B and Row 4 are also
empty to provide a border around the tables. The first table entry cell
(no colour) is C7.

As explained, my workbook contains three custom views - specifically to
show or hide various columns within the datalist on Sheet1. From the
Sheet1 point of view they work just fine - View1 called 'ShowAll'
exposes all columns on Sheet1 - View2 called 'SubGroup1' hides a
selection of columns on Sheet1 - View3 called 'SubGroup2' hides a
different selection of columns.

From past experience I know that saving a custom view saves the view
settings of all sheets in the workbook not just the active sheet. I was
therefore very careful to ensure that Sheet2 was set with cell B4
visible and selected before creating each view. I have deleted and
recreated the custom views several times thinking I was going mad.

--

Dave Peterson