Jump to content

Welcome to Geeks to Go - Register now for FREE
Geeks To Go is a helpful hub, where thousands of friendly volunteers serve up answers and support. 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. This message and all ads will be removed once you have signed in.
Create an Account Login to Account

Excel file locked for editing


  • Please log in to reply

#1
hulud

hulud

    Member

  • Member
  • PipPipPip
  • 268 posts
i'm getting the error

file.xls is locked for editing

it wont let me open it unless its in read-only mode. last time i found a very quick fix online that involved just clicking a few buttons and it worked... but i cant find it now for some reason. i didnt have to do anything to the server, clear any temp files, or anything like that. it was changing something in excel i think. any ideas?

please :whistling:
  • 0

Advertisement


#2
dsenette

dsenette

    Je suis Napoléon!

  • Administrator
  • 25,768 posts
  • MVP
is this a file located on a file server or is it saved locally? does it say who has it locked?
  • 0

#3
hulud

hulud

    Member

  • Member
  • PipPipPip
  • 268 posts
it is located on a server. it says who has it locked, but they do not have it open, and in fact have never opened the file
  • 0

#4
dsenette

dsenette

    Je suis Napoléon!

  • Administrator
  • 25,768 posts
  • MVP
do you have administrative access to the server?
  • 0

#5
hulud

hulud

    Member

  • Member
  • PipPipPip
  • 268 posts
yes
  • 0

#6
dsenette

dsenette

    Je suis Napoléon!

  • Administrator
  • 25,768 posts
  • MVP
log onto the server....right click on "my compute"r and choose "manage"...expand the "shared folders" section on the left side and click on "open files" find the file on the right side...right click it and choose "close open file"
  • 0

#7
hulud

hulud

    Member

  • Member
  • PipPipPip
  • 268 posts
thanks so much!

looks like a remote citrix user had lost their citrix connection and not gotten back in, therefore leaving the file locked.

strange though, last time it was such a quick fix for this problem... i changed the macros security or something and then was able to open it right back up...

anyway, thanks very much for your help, greatly appreciated!
  • 0

Advertisement



0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

featured