#Microsoft excel add ins ph stat update#
#Microsoft excel add ins ph stat trial#
#Microsoft excel add ins ph stat windows#

If your Excel application is made of normal spreadsheets ( XLS, XLSM…) and XLAs do not forget to update the references for all the files referencing your addin, not only the spreadsheets. I’ve seen this happen a few times, at least when the two methods have the same signature and are close in the API, otherwise you should have an explicit error.

VBA/addin interface mismatch: from VBA you call method “ A” of your addin but you end up in method “ B“.

in the top menu choose “ Tools” then “ References” :.

go into the VBA editor ( ALT-F11 is a handy shortcut).

If the error message does not inspire you or Excel crashes without notice when you call an external API from VBA (this often happens when you are using a third-party API that can evolve independently of the worksheets that use it) and you want or need to move fast you can try this as a first shot: The magic solution that works almost 50% of the time So to be as efficient as possible you’d better have a checklist and this is precisely what this article will be, enumerating all the errors I have encountered describing usual causes and solutions.

#Microsoft excel add ins ph stat windows#

Sometimes the root-cause is obvious: you have delivered a new version, but in many cases you will hardly ever know the root-cause of this annoying situation: Windows update, Office update, quick and dirty moving/installation of the addin from a workstation to another one, bad alignment of Uranus and Jupiter…Ī wealth of errors can happen, then it’s hard to have them all in mind, especially when you are in a hurry and with stress you start to get mixed up. So you have deployed your awesome Excel addin in production and all is working fine for some weeks : you are enjoying your success…īut one day the phone rings and the guy at the other side is not really happy no, he is completely upset and you could almost smell his breath when he screams.īut why? Because your awesome addin has stopped working on his workstation without notice. 7 NullReferenceException thrown by the.5 “Error in loading DLL” when compiling the VBA project.

4 “Error in loading DLL” when referencing a TLB.

3 Excel is crashing before you can try the magic solution.

2 The magic solution that works almost 50% of the time.

#Microsoft excel add ins ph stat trial#

* The trial lets you try all the features of Analyse-it (including excel stat add-in) with no commitment to buy. There's no new interface to learn, no locked-in file formats, and you can easilyĮxchange your data and analyses with colleagues that have Excel.

Multivariate analysis including correlation matrix, covariance matrix, scatter plot matrix, and Principal Components Analysis (PCA) & Factor Analysis (FA) to reduce dimensionality.įit simple and advanced multiple linear, logistic, probit & weighted regression models, ANOVA & ANCOVA models, with extensive fit diagnostics, leverage plots, interaction plots, outlier and influence plot, multiple comparisons, and the ability to predict future observations.Ĭonduct all your statistical analysis without leaving Microsoft Excel. Multivariate/Correlation, PCA and Factor analysis.Explore the distribution of a sample with descriptive statistics, histogram, box-whisker plots, then test hypotheses, test normality.Ĭompare samples with box-plots, test location/dispersion with tests like t-test, ANOVA, then examine differences with multiple comparisons like Hsu, Steel, Steel-Dwass-Critchlow-Fligne, Student-Newman-Keuls (SNK), Duncan's and more.