Cannot share workbook because it contains a table, except it doesn't really.. Excel 2010

[nWillem]

Hi,

I've run into an issue with one of my commonly used workbooks. When I try to share the workbook I get the notification that it cannot be done because it contains Excel Tables or XML maps.

Indeed, when I click the drop down Name box, I find a name: "Table2".

However, when I click on Table2 in the namebox, nothing happens and my selection doesn't change.

When I take a look in the Name Manager, Table2 cannot be found..

Has anybody encountered this issue or does anybody know how to delete a table that is not there?

cheers

W

 

[RoryA]

Try running this code:

Sub LocateTables()
    Dim ws                  As Worksheet
    Dim oList               As ListObject
    
    For Each ws In ActiveWorkbook.Worksheets
        For Each oList In ws.ListObjects
            MsgBox "Table: " & oList.Name & " is on sheet '" & ws.Name & "' at range " & oList.Range.address
        Next oList
    Next ws
End Sub

 

[nWillem]

Thank you!!! The table was on a hidden sheet, I was unaware of its existence.

Cheers,
W