[DISREGARD] "Checking Defined Name" making Excel sluggish

DISREGARD - I still don't know what the problem is but this has just stopped happening so it must be something else

Hi All,

I have a sizeable Excel workbook that I'm working on (approx 35,000 formulas across 60 sheets).

The workbook was set up by someone else and I've noticed recently that using named ranges really makes everything incredibly slow. I also just noticed that, rather than saying 'Ready', the status bar says it is "Checking Defined Name 'LTCP Indicator dataset 2010'!_FilterDatabase".

I gather this means that it is referring the the filtering in the 'LTCP Indicator dataset 2010' sheet, so I used the following code (from http://www.j-walk.com/ss/excel/tips/tip88.htm) to try and resolve it but it doesn't seem to have made any difference:

Sub ShowAdvancedFilterDialog()
'   Delete names
    On Error Resume Next
    With ActiveWorkbook
      .Names("_FilterDatabase").Delete
      .Names("Criteria").Delete
      .Names("Extract").Delete
    End With
    On Error GoTo 0
'   Display the dialog box
    Application.Dialogs(xlDialogFilterAdvanced).Show
End Sub

Does anyone have any suggestions? This is really urgent, any help is appreciated.

Thanks,
Ad