Jump to content

Free help from tech experts
Welcome to Geeks to Go forums. Create a FREE account now to gain access to all our features. Once registered and logged in, you will be able to create topics, post replies to existing topics, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. Best of all, registration and all assistance is 100% free! This message, and all ads will be removed once you sign 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

Similar Topics: Excel file locked for editing     x


#2
dsenette

dsenette

    Je suis Napoléon!

  • Administrator
  • 25,746 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,746 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,746 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


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

featured