Analysis Toolpak Loaded or Not

MacGuy

Guest

Posts: n/a

7th May 2008

I have a template that uses the workday function that the user runs daily;
the analysis toolpak is loaded. Today there is a #NAME error due to excel
not recognizing the toolpak. Checking the addins indicates it is "loaded"
but when deselecting, closing excel, starting excel and selecting Analysis
Toolpak and Analysis Toolpak VBA again, it recognizes the addin and the
workday function.

I've added coding to load the addin when the workbook opens but have no idea
what caused the problem between yesterday and today. Any ideas?
--
MacGuy

« match and offset | Scrolling columns in lockstep »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pre-loaded Excel 2007 missing "Analysis ToolPak"	mapjo11	Microsoft Excel Misc	2	23rd May 2010 02:49 AM
I've loaded the Analysis ToolPak, now where are the tools?	xlsSanga	Microsoft Excel Misc	0	24th Mar 2009 11:50 PM
Alternative to WORKDAY when Analysis ToolPak not loaded	Paul D. Simon	Microsoft Excel Worksheet Functions	9	23rd Mar 2009 05:17 PM
Analysis Toolpak appears loaded, but isn't	johnhildreth@citynet.net	Microsoft Excel Programming	0	19th Dec 2005 07:22 PM
Why can't I see Analysis Toolpak functions when I have loaded it .	=?Utf-8?B?TmlnZQ==?=	Microsoft Excel Worksheet Functions	6	11th Apr 2005 11:31 PM