They might be workbooks that are referenced by your "normal"
workbook(s). If a workbook has a reference (in the VBA/VBE meaning of
"reference", not a cell/formula "reference"), Excel will open the
referenced workbook when the workbook referencing that workbook is
opened. The referenced workbook may be configured so as not to be
visible in the Excel UI.
Also, you might want to examine your Registry settings. (Be VERY
CAREFUL, though, when working with the Registry. All updates and
changes are done "live" and there is no "undo" or "close without save"
option.) From the Windows Start menu, choose Run, then enter RegEdit.
There, navigate to the HKEY_CURRENT_USER region and find the key
Software\Microsoft\Office\11.0\Excel\Add-in Manager
Change the 11.0 to your version (10.0 = 2002, 11.0 = 2003, 12.0 =
2007). See what add-ins are listed there and if you don't want or need
them, delete their values. Also, go to the key
Software\Microsoft\Office\11.0\Excel\Options
Look for values whose name begins with "OPEN". If you don't want/need
the files in those values, delete the values.
Also, examine the key
Software\Microsoft\Office\Excel\AddIns
If there are add-ins there that you don't want/need, delete the
values.
Nagivate to the HKEY_LOCAL_MACHINE region and examine the values in
the key and subkeys:
SOFTWARE\Microsoft\Office\11.0
Again, if you find references to add-ins or files you don't want/need,
delete their values.
As noted before, be VERY CAREFUL when working with the Registry and
RegEdit. If you delete the wrong key or value, applications may
misbehave or fail to start. In the worst case, Windows itself may not
be able to start. Be VERY CAREFUL.
If you do find that you are not happy with the Registry changes you
made, you can restore Excel's Registry items to "factory defaults".
With Excel closed, go to the Windows Start menu, choose Run, and enter
Excel.exe /regserver
You may have to include the entire path to Excel. E.g.,
"C:\Program Files\Microsoft Office\Office11\Excel.exe" /regserver
Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
On Mon, 17 Nov 2008 15:05:02 -0800, RyanH
wrote:
In the VBE, I looked in the Add-InsAdd-In Manager and saw nothing. Our IT
guys dosn't have a clue. One of the projects is a PDF maker that I never
use, plus another is an Add-in from Crystal Reports but I see no way to
remove it. Any ideas on how?