PC Review


Reply
Thread Tools Rate Thread

How can I make Excel 2007 addins available to all users

 
 
r_olson@sandiego.edu
Guest
Posts: n/a
 
      31st Aug 2007
I teach at a university. We have the enterprise edition of Office
2007 installed in each of our labs. Each computer has Office
installed on its own hard disk. It isn't housed on a separate
server. The system is set up so that each student logs on the the
machine with their own username. This seems to be creating some
problems with Excel addins.

1) We need the Solver and Analysis ToolPaks available to all students
essentially all the time without needing to turn them on by navigating
the Office Button> Excel Options> Addins.... sequences. Our techs
have tried a few things, but when a new user logs on it looks like
they need to go through the process of adding the tools. The way the
security is set up on the machines, the user profile goes away when
it's rebooted so every student would need to select the tool and wait
a couple of minutes while Excel installs the tool. Is there a way for
an administrator to install Excel addins/tools so that they
automatically appear for all users?

2) This is similar to 1). I also have a set of Excel 2003 .xla files
that I use in one of my classes. On my personal machine I was able to
place them in Docs&Settings\myspace\Application Data\Microsoft
\Addins. They then appear
in the "Addin" box on the Excel 2007 ribbon. Is there a way that we
can install my third party addins so that every user in the lab
automatically sees them in an Addin box on the ribbon?

Thanks in advance--
Rick

 
Reply With Quote
 
 
 
 
Rick Rothstein \(MVP - VB\)
Guest
Posts: n/a
 
      31st Aug 2007
> 1) We need the Solver and Analysis ToolPaks available to all students
> essentially all the time without needing to turn them on by navigating
> the Office Button> Excel Options> Addins.... sequences.


If macros are enabled, have your techs look into putting this code...

AddIns("analysis toolpak").Installed = True
AddIns("solver add-in").Installed = True

in an event that is common to all students (Workbook_Open event of a
standard worksheet template, Personal.xls for each student, etc.)

Rick

 
Reply With Quote
Reply

Thread Tools
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Addins with isaddin property to false in excel 2007 Subodh Microsoft Excel Programming 4 15th Apr 2010 02:28 AM
2003 Addins in Excel 2007 John M Microsoft Excel Programming 13 3rd Sep 2009 04:57 PM
Excel Version 2007 - AddIns load individually dplunkett Microsoft Excel Misc 1 9th May 2009 07:36 AM
Addins for Excel 2007 Ajay Microsoft Excel Misc 1 2nd Jun 2008 06:08 PM
Excel 2003 vs Excel 2007 addins =?Utf-8?B?QWxhbg==?= Microsoft Excel Programming 3 23rd Sep 2006 11:21 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:09 PM.