Custom views disabled

Question

I'm trying to use the custom views in Excel 2007 but in some workbooks the button to create a view is enabled and in other workbooks it's disabled.  I made sure that my sheets or my workbook did not have any protection and it still wouldn't work.  I've used custom views in the past and I never had such a problem.  Any ideas?

Answer 1

If you have selected multiple sheets, Custom Views is disabled.

The window title bar would show [Group] in such a case.

---

Bill Manville. Excel MVP, Oxford, England. www.manville.org.uk

Answer 2

Hi

I discovered the same issue in some Excel applications where I used the "Custom View" function.

My apps were created in an earlier version Excel 2003 and worked fine until I converted a normal range of data (matrix) to the "the new "table" function (which is indeed a very nice new feature). When I did this the Custom View function became disabled. For some reason you can't use the Custom View in the entire workbook together with a "table", not even if the table is located in another sheet. Seems strange for me why it's like this but I assume MS has a good reason for it, but atleast there should be a message to user when a table is created that possible Custom Views will be disabled.

Workaround?

If you absolutely need your Custom Views you can always convert a Table back to an ordinary range matrix, right click inside Table range, Select Table/Convert to range. You have to do this for all Tables in the workbook.

Below macro does the same thing but for all possible tables at once.

Sub Convert_TableToRange()

 Dim wrksht As Worksheet

 Dim objListObj As ListObject

 Dim iSheet As Integer, iList As Integer

 For Each wrksht In ActiveWorkbook.Worksheets

    iList = 1

    Do Until iList >= wrksht.ListObjects.Count + 1

       Set objListObj = wrksht.ListObjects(iList)

       objListObj.Unlist

    Loop

  iList = iList + 1

 Next wrksht

End Sub

There are of course ways to reconvert the ranges back Tables with Macros but it becomes much more complex

than above examaple.

I hope this helped out a little bit.

 regards Kimmo

Answer 3

I found that if you have a link to an external database also custom views are disabled.

Answer 4

I have the same problem with the custom view.  the first thing I did was to check if I had more than 2 tabs selected.- I do not.  cannot figure why the custom view is disabled in only one file.