Printable View
Anyone know how to find the Excel environment file ?
I had Crystal Reports, which in turn put an icon on the toolbar.
Then Crystal got binned, but whenever I fire up Excel its obviously still looking for the icon as it throws up an error.
I can get in OK after that, its just annoying, so I presume theres maybe an .INI file somewhere where I can remove the reference to it ?
See what you find under C:\Documents and Settings\YourLogInId\Application Data\Microsoft
Two locations to check out.
C:\Documents and Settings\UserName\Application Data\Microsoft\Excel\XLSTART
C:\Documents and Settings\UserName\Application Data\Microsoft\AddIns
I was close.
I forgot to add the Excel\XLSTART. :D
More then likely its in the Add-In folder but I cant verify this as my version of CR doesnt add anything to Excel. Its probably too old. :(
OK nothing in XLSTART directory, and 1 file in ADDINS directory called CRPTACCWZ2K.MDE.
Tried moving this out but still had same problem.
Excel still looking for :
C:\Program Files\Seagate Software\Report Designer Component\CRPTXLS.XLA.
Grrr !
How about -
?:\Program Files\Microsoft Office\OFFICE11\ADDINS
?:\Program Files\Microsoft Office\OFFICE11\STARTUP
?:\Program Files\Microsoft Office\OFFICE11\MACROS
Nothing obvious in \Addins. Only a couple of files in there.
Don't have a \STARTUP or a \MACROS directory using that path.
I'll see if they exist under a slightly different path.
OK found them under C:\Program Files\Microsoft Office\Office ... but no not in those other 2 either !
There is also a personal and public macros folder somewhere but I cant remember off hand. How about searching the registry for anything that may show it placing the startup info for Excel to add the toolbuttons in?
Good point.
Give me 10 minutes and I'll be back asking for links to "Registry Rebuilding Software" !!
:)
:lol: Ok.
I had looked for any obvious keys but not having a newer version of CR I dont think I have the same feature as you.
Cheers Rob. Found 2 entries ... deleted them both ... job done :)
AND no need for a rebuild :)
At least ... not yet as far as I know !
Thanks a lot for your input.
NP :) But could you post the locations in the registry that contained the offending load?
oops !
I would if I hadn't already quit REGEDIT !
Regedit should reopen to the last location you were in. One out of two wouldnt be bad. :)
OK.
The second one was found in :
HKEY_CURRENT_USERS\Software\Microsoft\Office\9.0\Excel\Options
Ok, Thanks.