phantom .xla won't go away

miconian

Well-known Member
Joined
Aug 18, 2004
Messages
768
I made the mistake of downloading the 'file size reducer' xla from ozgrid. It can be found here:

http://www.ozgrid.com/Excel/ExcelProblems.htm

Anyway, I have Excel 2007, and the add-in is apparently made for Excel 2003, and it didn't work for me. I forgot about it for a while, but today I noticed it showing up as a project in my VBA editor.

I can't delete it from the VBA editor. It doesn't show up in the Add-ins Manager.

I searched for it on my hard drive, found it in the add-ins folder, and deleted it.

But now when I start Excel, I get an error... Excel is still looking for it.

"C:\Documents and Settings\myname\Application Data\Microsoft\AddIns\File Size Reducer.xla' could not be found. Check the spelling of the file name..." etc.

I'm realizing that the download page is ancient, and the person who coded the add-in probably died a thousand years ago. How can I get rid of this darn thing... or, put differently, how can I get my Excel to stop expecting it?
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

hiker95

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
miconian,

Your posted link has a reference (check to see if there are instrucitons to delete the addin):

Instructions for its use are in the text file within the zip file.


Or, contact one of the administrators at Ozgrid for help.
 

miconian

Well-known Member
Joined
Aug 18, 2004
Messages
768
hiker95, you are mistaken. The text file within the zip file says nothing about how to remove the add-in.
 

jimrward

Well-known Member
Joined
Feb 24, 2003
Messages
1,759
Office Version
  1. 2016
  2. 2013
  3. 2011
  4. 2010
  5. 2007
Platform
  1. Windows
try looking in the xlstartup folder, or do a search of your C drive for *.xla, as startup folder varies with operating system and version of office

once you find it, move or delete the XLA file
 

miconian

Well-known Member
Joined
Aug 18, 2004
Messages
768

ADVERTISEMENT

As discussed above, I already searched my hard drive, found the file, and deleted it. That is not the problem.
 

jimrward

Well-known Member
Joined
Feb 24, 2003
Messages
1,759
Office Version
  1. 2016
  2. 2013
  3. 2011
  4. 2010
  5. 2007
Platform
  1. Windows
also look in the trusted locations for excel, click the big button and find the trusted location area and remove the reference, microsoft varies between 2007/2010
 

jimrward

Well-known Member
Joined
Feb 24, 2003
Messages
1,759
Office Version
  1. 2016
  2. 2013
  3. 2011
  4. 2010
  5. 2007
Platform
  1. Windows

ADVERTISEMENT

also, try start, run and type in %appdata% and choose microsoft, excel, xlstart, and see if xla is in there, as I said MS is awkward as to where it hides things
 

miconian

Well-known Member
Joined
Aug 18, 2004
Messages
768
I didn't find an .xla file, or anything that looked like a reference to the add-in, in any of those locations.
 

xenou

MrExcel MVP, Moderator
Joined
Mar 2, 2007
Messages
16,687
Office Version
  1. 2013
Platform
  1. Windows
I have fuzzy recollections of seeing this problem before. Maybe try this:

Create a dummy xla of your own and put it in this location:
C:\Documents and Settings\myname\Application Data\Microsoft\AddIns\File Size Reducer.xla

Hope that it shows up in the addins - if so, then uninstall it. Or if not, install it and then uninstall it, and see if it "takes" this time.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,732
Messages
5,524,516
Members
409,583
Latest member
gkarthick

This Week's Hot Topics

Top