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.

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

Thanks Dave,

If you read the last paragraph of my original post you'll see that I've
done that - several times. :(

Nick.

Oops. Sorry. (I didn't read all the message.)

I don't have a guess, though. Each time I created a custom view, the view was
saved the way I wanted it. (Column A off the screen or not--depending...).

Personally, I don't recall ever using a custom view in real life. What I have
done, though is create a macro that hides/filters everything I want.

Then I just run the macro when I need that "view".



Nick H wrote:

Thanks Dave,

If you read the last paragraph of my original post you'll see that I've
done that - several times. :(

Nick.

--

Dave Peterson

No worries Dave,

I was a bit wordy but wanted to give the full details in case something
I was doing had any bearing on the problem.

I can see I'm going to have to frig it with VBA. It just seemed custom
views were the right tool for the job. Having said that, judging by
posts on the subject, they do seem to be a bit buggy.

Nick.

No worries Dave,

I was a bit wordy but wanted to give the full details in case something
I was doing had any bearing on the problem.

I can see I'm going to have to frig it with VBA. It just seemed custom
views were the right tool for the job. Having said that, judging by
posts on the subject, they do seem to be a bit buggy.

Nick.

In case it helps anyone else - I've 'fixed' the problem...

I decided that I won't be needing the hidden rows and columns on Sheet2
so deleted them.

That was it!

Nick.

Patient: Doctor, doctor. It hurts when I do this.

Doctor: Don't do that.

Excellent fix!



Nick H wrote:

In case it helps anyone else - I've 'fixed' the problem...

I decided that I won't be needing the hidden rows and columns on Sheet2
so deleted them.

That was it!

Nick.

--

Dave Peterson