Excel file that holds environmen data
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 ?
Re: Excel file that holds environmen data
See what you find under C:\Documents and Settings\YourLogInId\Application Data\Microsoft
Re: Excel file that holds environmen data
Two locations to check out.
C:\Documents and Settings\UserName\Application Data\Microsoft\Excel\XLSTART
C:\Documents and Settings\UserName\Application Data\Microsoft\AddIns
Re: Excel file that holds environmen data
I was close.
I forgot to add the Excel\XLSTART. :D
Re: Excel file that holds environmen data
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. :(
Re: Excel file that holds environmen data
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 !
Re: Excel file that holds environmen data
How about -
?:\Program Files\Microsoft Office\OFFICE11\ADDINS
?:\Program Files\Microsoft Office\OFFICE11\STARTUP
?:\Program Files\Microsoft Office\OFFICE11\MACROS
Re: Excel file that holds environmen data
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.
Re: Excel file that holds environmen data
OK found them under C:\Program Files\Microsoft Office\Office ... but no not in those other 2 either !
Re: Excel file that holds environmen data
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?
Re: Excel file that holds environmen data
Good point.
Give me 10 minutes and I'll be back asking for links to "Registry Rebuilding Software" !!
:)
Re: Excel file that holds environmen data
: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.
Re: Excel file that holds environmen data
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.
Re: Excel file that holds environmen data
NP :) But could you post the locations in the registry that contained the offending load?
Re: Excel file that holds environmen data
oops !
I would if I hadn't already quit REGEDIT !
Re: Excel file that holds environmen data
Regedit should reopen to the last location you were in. One out of two wouldnt be bad. :)
Re: Excel file that holds environmen data
OK.
The second one was found in :
HKEY_CURRENT_USERS\Software\Microsoft\Office\9.0\Excel\Options
Re: Excel file that holds environmen data