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

NOt so Excel-ent


  • Please log in to reply

#1
dclarke

dclarke

    Member

  • Member
  • PipPip
  • 19 posts
Good morning Geeks - and HELLLP!

My problem - Excel won't run, it claims two files are being locked by another user.

I may have screwed up, so a brief history:

I have windows XP + Office 2000.

I have never been able to click a spreadsheet and get Excel to open from the C drive, for some reason it wants me to load the Office CD, so in the past I've opened Excel from the C drive then opened the spreadsheet.

I hamfistedly tried to cure this by going into Excel's preferences where I saw an empty box for an alternative startup location (I think it said) so I blithely banged in C:\program files\microsoft office\office in the hope that the system would go there to find Excel.

From that time on, Excel refuses to run. When I try to start it I get two messages, one is that excel9.olb is locked for editing by another user, then a second says xl8galry.xls is locked, then Excel closes.

At someone's suggestion I tried deleting all tmp files, there were some that the system couldn't delete, the problem remained.

I have just re-installed Mcrosoft Office, but this hasn't fixed the problem. I am now up the proverbial [bleep] creek without a paddle, can someone help me???

Thanks - Dave Clarke
  • 0

Advertisements


#2
Retired Tech

Retired Tech

    Retired Staff

  • Retired Staff
  • 20,563 posts
As long as you have the Office CD's, try going to add / remove then click change for Office, if you get 3 options, go with add or remove features, then clear tick for excel, then next and so on. Use search, for the two files you list, include hidden files, delete both files but leave them in the recycle bin. Return to add / remove, Office, change, add or remove features, if you get customize content box, tick that so you can add most things to run all from computer if you have the room, replace tick for excel, click next and so on. See what Excel does.
  • 0

#3
dclarke

dclarke

    Member

  • Topic Starter
  • Member
  • PipPip
  • 19 posts

As long as you have the Office CD's, try going to add / remove then click change for Office, if you get 3 options, go with add or remove features, then clear tick for excel, then next and so on.


Hi Keith.

I followed your instructions up to and including add or remove features, but what I then see is a kind of tree structure with MS Office at the top, and the various programs listed underneath, all with those + or - expand buttons. I don't see any ticks, so I am stuck on the bit where you say clear the tick for excel. Also not sure what you mean by then next and so on - do you mean clear the ticks for all the MS Office programs?

Thanks, Dave
  • 0

#4
Retired Tech

Retired Tech

    Retired Staff

  • Retired Staff
  • 20,563 posts
[attachment=705:attachment][attachment=706:attachment][attachment=707:attachment][attachment=708:attachment][attachment=709:attachment][attachment=710:attachment]

That's how it should go for removing Excel

When you get to putting it back, choose add or remove features then select cutomize installation, replace tick for Excel then check for yellow 1 symbols, click those and select run all from computer
  • 0

#5
Retired Tech

Retired Tech

    Retired Staff

  • Retired Staff
  • 20,563 posts
You just need to remove tick for Excel then press update, after it updates click OK then remove the files then put excel back
  • 0

#6
dclarke

dclarke

    Member

  • Topic Starter
  • Member
  • PipPip
  • 19 posts
Keith, these are the screens I get, they're different from yours. It's not clear to me how I check these options to remove Excel



Posted Image

Posted Image
  • 0

#7
Retired Tech

Retired Tech

    Retired Staff

  • Retired Staff
  • 20,563 posts
Tick the x not available then update now

Edited by Keith, 05 May 2005 - 09:25 AM.

  • 0

#8
dclarke

dclarke

    Member

  • Topic Starter
  • Member
  • PipPip
  • 19 posts
Keith

I removed Excel, did a search, found xl8alry.xls and deleted it, but could not find excel9.olb.

I tried reinstalling Excel as you suggested, checking the Run All From My Computer and the yellow 1 (Installed on First Use) options but Excel didn't re-install. I repeated it but with unchecked yellow 1 and Excel installed. (By the way, at no time did I get a customize option, I only saw the two screens I printed above).

Excel re-installed, but it still won't work I'm afraid, I get the message that excel9.olb is locked by another user and when I close that message window Excel closes down.

Edited by dclarke, 05 May 2005 - 10:32 AM.

  • 0

#9
Guest_jake6535_*

Guest_jake6535_*
  • Guest

[attachment=705:attachment][attachment=706:attachment][attachment=707:attachment][attachment=708:attachment][attachment=709:attachment][attachment=710:attachment]

That's how it should go for removing Excel

When you get to putting it back, choose add or remove features then select cutomize installation, replace tick for Excel then check for yellow 1 symbols, click those and select run all from computer

View Post


Um, he's using Office 2000.
  • 0

#10
Retired Tech

Retired Tech

    Retired Staff

  • Retired Staff
  • 20,563 posts
When you ran search, did you click more advanced options and include search system folders and search hidden files and folders
  • 0

Advertisements


#11
Retired Tech

Retired Tech

    Retired Staff

  • Retired Staff
  • 20,563 posts
Hello Jake,

I'm right out of Office 2000 pics, sorry.

Keith
  • 0

#12
dclarke

dclarke

    Member

  • Topic Starter
  • Member
  • PipPip
  • 19 posts

When you ran search, did you click more advanced options and include search system folders and search hidden files and folders

View Post


I'm sure I did, but I'll tell you what, I'll remove ecxel and run the search again, then get back to you.
  • 0

#13
dclarke

dclarke

    Member

  • Topic Starter
  • Member
  • PipPip
  • 19 posts
Keith, I removed Excel, ran a search including search system folders and search hidden files and folders and the file was not found. I reinstalled Excel and found the file. I just tried opening Excel again - same error.
  • 0

#14
Retired Tech

Retired Tech

    Retired Staff

  • Retired Staff
  • 20,563 posts
Can you rename the file

Edited by Keith, 05 May 2005 - 11:58 AM.

  • 0

#15
dclarke

dclarke

    Member

  • Topic Starter
  • Member
  • PipPip
  • 19 posts
Yes - so I renamed it Keith.olb
  • 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