Can't open data analysis tools

%3CLINGO-SUB%20id%3D%22lingo-sub-1495765%22%20slang%3D%22en-US%22%3ECan't%20open%20data%20analysis%20tools%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1495765%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20cannot%20run%20data%20analysis%20tools%2C%20even%20thought%20I%20have%20check%20the%20option%20in%20adds-ins%20and%20check%20%22Trust%20access%20to%20VBA%20project%20object%20model%22%20in%20macro%20settings.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20shown%3C%2FP%3E%3CP%3ERun-time%20error%20'1004'%3A%3C%2FP%3E%3CP%3ECannot%20run%20the%20macro%20'fDialog'.%20The%20macro%20may%20not%20be%20available%20in%20this%20workbook%20or%20all%20macros%20may%20be%20disabled.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20anyone%20help%20me%20solve%20this%20problem.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1495765%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi

 

I cannot run data analysis tools, even thought I have check the option in adds-ins and check "Trust access to VBA project object model" in macro settings.

 

It shown

Run-time error '1004':

Cannot run the macro 'fDialog'. The macro may not be available in this workbook or all macros may be disabled.

 

Could anyone help me solve this problem.

0 Replies