Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Errors Opening Excel 2002


  • Please log in to reply

#1
jaxisland

jaxisland

    Member 1K

  • Member
  • PipPipPipPip
  • 1,703 posts
I receive an error everytime I open or close an Excel spreadsheet. It doesnt matter if I open a blank document or an existing file. I have done the Detect and Repair as well as a full uninstall and re-install of Office 2002. Nothing has helped so far.

The error says:
"Object library invalid or contains references to object definitions that could not be found"


Also I made sure that I removed or disabled all of my Add-Ins so nothing starts up when excel starts, or at least nothing should start.

I am kinda at a lose here, all the info I found was people receiving this error when trying to execute something, not simply clicking on the link to open excel.

Thanks!
  • 0

Advertisements


#2
Ax238

Ax238

    Tech Staff

  • Technician
  • 1,323 posts
Hello jaxisland,

Are you using any macros or VBA logic in the Excel file you are working with? Do you make use of a Personal.xls document? Are there any macros listed on the Tools | Macros window?

Regards,

Ax
  • 0

#3
jaxisland

jaxisland

    Member 1K

  • Topic Starter
  • Member
  • PipPipPipPip
  • 1,703 posts
It is not dependant on the file, even a blank file does it. No macros and no VBA. I am working with a blank sheet.
  • 0

#4
Ax238

Ax238

    Tech Staff

  • Technician
  • 1,323 posts
Excel can load other files when it is opened up as standard functionality. Can you press Alt-F11 and let me know if you see any code within it?

Also, check to make sure there are no files in the following Excel startup directories:
• C:\Program Files\Microsoft Office\Office10\Xlstart
• C:\Documents and Settings\User name\Application Data\Microsoft\Excel\XLSTART

You may need to choose the "Show hidden files and folders" from the Tools | Folder Options View tab in Explorer.

Ax
  • 0

#5
jaxisland

jaxisland

    Member 1K

  • Topic Starter
  • Member
  • PipPipPipPip
  • 1,703 posts
Hitting Alt+F11 brings up a blank VB Book. But C:\Program Files\Microsoft Office\Office10\Xlstart had InsertText.xla

I deleted the file and the error goes away.

Thanks for the help.
  • 0

#6
Ax238

Ax238

    Tech Staff

  • Technician
  • 1,323 posts
:) Glad to hear that resolved your issue. It was my pleasure assisting, you're welcome!

Ax
  • 0

#7
dsenette

dsenette

    Je suis Napoléon!

  • Administrator
  • 26,019 posts
  • MVP
congratulations jax! you finally got someone besides me to answer one of your questions HAHAHA
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP