Data Analysis Add-In not working on specific workbook only

[Lauren_Oz]

Hi!

I am working on a particular workbook that I now need to use the Data Analysis Add-In with. However, it's not working.

I've gone to the Add-Ins menu and checked the box, but it didn't come up in the Tools menu. So I went back thinking I hadn't checked it, but wouldn't ya know it... yup.. its checked. So I opened another workbook.. it's fine there! Opened several others... all a-ok with the Data Analysis Add-In showing in the Tools menu, but not in the one workbook I need it for ahahaha. Typical.

I've changed Macro security to low, unchecked and rechecked it, closed Excel and re-opened, rebooted my computer, and even re-installed Excel (ok a guy from IT did that) ... its still not working!

Any ideas?!

[Lauren_Oz]

I gather no-one can give me any clues on what might be causing this?

[royUK]

I would think that if it is available to other workbooks then there is a problem with that particular workbook. Try copying all the pages to a new workbook, check at each stage. Likewise, with any VBA modules.