Custom Views

[mynameisjeff]

So I have a workbook with multiple sheets in it.

For some reason, I am not able to set custom views on any sheets.

What am I missing?

 

[BrianJN1]

What have you done, for example, to create one? That may give guidance.

 

[RoryA]

Do you have any Tables in the workbook?
Is it a Shared Workbook?
Do you have multiple sheets selected?

Any of those would prevent you from using Custom Views.

 

[mynameisjeff]

Crap I have a table. So there is no way to set custom views with a table?

 

[RoryA]

Nope. Don't ask me why.

 

[mynameisjeff]

Well, do you know how to have formula range automatically change when you add more data to that range? I have only been able to do that with a table.

 

[RoryA]

Dynamic named ranges. See the Formula section of Debra's page here: http://www.contextures.com/xlNames01.html#Dynamic

 

[mynameisjeff]

Nevermind forget that questions. Can you show me how to add a custom view if I was able to? I still won't show up on another sheet I have that doesn't have a table.

 

[RoryA]

If there is a table in the same workbook, you can't do it. Or if any of the other things I mentioned applies.

 

[mynameisjeff]

Ah man...ok thank you.