Excel using macros Microsoft Visual basic error in loading DLL

[mermaid]

I am using office XP. excel returns "Microsoft Viual basics error in loading
DLL" when I use formulas this only happens in selected Spreadsheets. When I
clear the error the correct calculation is inserted into the cell. An
irritation that needs sorting halpe

 

[Pete D.]

Try removing analysis toolpak and solver addin from excel tools addins.
Close excel and reopen it. Add them back in and see if this cures the
problem.
Also this is a MS Access database newsgroup, you should post future excel
questions to an excel group like

microsoft.public.excel