Excel file that holds environmen data

**TheBionicOrange** · Mar 22nd, 2006, 03:48 AM

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 ?

**Hack** · Mar 23rd, 2006, 09:13 AM

See what you find under C:\Documents and Settings\YourLogInId\Application Data\Microsoft

**RobDog888** · Mar 23rd, 2006, 12:23 PM

Two locations to check out.

C:\Documents and Settings\UserName\Application Data\Microsoft\Excel\XLSTART
C:\Documents and Settings\UserName\Application Data\Microsoft\AddIns

**Hack** · Mar 23rd, 2006, 12:41 PM

I was close.

I forgot to add the Excel\XLSTART.

**RobDog888** · Mar 23rd, 2006, 12:43 PM

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.

**TheBionicOrange** · Mar 27th, 2006, 02:35 AM

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 !

**RobDog888** · Mar 27th, 2006, 10:29 AM

How about -
?:\Program Files\Microsoft Office\OFFICE11\ADDINS
?:\Program Files\Microsoft Office\OFFICE11\STARTUP
?:\Program Files\Microsoft Office\OFFICE11\MACROS

**TheBionicOrange** · Mar 27th, 2006, 10:52 AM

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.

**TheBionicOrange** · Mar 27th, 2006, 10:54 AM

OK found them under C:\Program Files\Microsoft Office\Office ... but no not in those other 2 either !

**RobDog888** · Mar 27th, 2006, 10:55 AM

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?

**TheBionicOrange** · Mar 27th, 2006, 10:58 AM

Good point.

Give me 10 minutes and I'll be back asking for links to "Registry Rebuilding Software" !!

**RobDog888** · Mar 27th, 2006, 11:00 AM

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.

**TheBionicOrange** · Mar 27th, 2006, 11:06 AM

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.

**RobDog888** · Mar 27th, 2006, 11:31 AM

NP

But could you post the locations in the registry that contained the offending load?

**TheBionicOrange** · Mar 27th, 2006, 11:56 AM

oops !

I would if I hadn't already quit REGEDIT !

**RobDog888** · Mar 27th, 2006, 11:57 AM

Regedit should reopen to the last location you were in. One out of two wouldnt be bad.

**TheBionicOrange** · Mar 28th, 2006, 02:36 AM

OK.

The second one was found in :

HKEY_CURRENT_USERS\Software\Microsoft\Office\9.0\Excel\Options

**RobDog888** · Mar 28th, 2006, 03:44 AM

Ok, Thanks.

Thread: Excel file that holds environmen data

Thread Tools

Display

Excel file that holds environmen data

Re: Excel file that holds environmen data

Re: Excel file that holds environmen data

Re: Excel file that holds environmen data

Re: Excel file that holds environmen data

Re: Excel file that holds environmen data

Re: Excel file that holds environmen data

Re: Excel file that holds environmen data

Re: Excel file that holds environmen data

Re: Excel file that holds environmen data

Re: Excel file that holds environmen data

Re: Excel file that holds environmen data

Re: Excel file that holds environmen data

Re: Excel file that holds environmen data

Re: Excel file that holds environmen data

Re: Excel file that holds environmen data

Re: Excel file that holds environmen data

Re: Excel file that holds environmen data

Posting Permissions