LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 25
Default Analysis Toolpak Loaded or Not

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pre-loaded Excel 2007 missing "Analysis ToolPak" mapjo11 Excel Discussion (Misc queries) 2 May 23rd 10 02:49 AM
I've loaded the Analysis ToolPak, now where are the tools? xlsSanga Excel Discussion (Misc queries) 0 March 24th 09 11:50 PM
Alternative to WORKDAY when Analysis ToolPak not loaded Paul D. Simon Excel Worksheet Functions 9 March 23rd 09 05:17 PM
Analysis Toolpak appears loaded, but isn't [email protected] Excel Programming 0 December 19th 05 07:22 PM
Why can't I see Analysis Toolpak functions when I have loaded it . Nige Excel Worksheet Functions 6 April 11th 05 11:31 PM


All times are GMT +1. The time now is 10:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"