Jump to content

Welcome Guest 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. Feel free to browse the site as a guest. However, you must log in to reply to existing topics or start a new topic of your own, and enjoy all this forum has to offer. Additionally, if you can assist another member by sharing your knowledge, please post a reply! Best of all - Registration and all assistance, is FREE! Learn more about How it Works. Infected? Malware Cleaning Guide. What are you waiting for?
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,765 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,765 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,765 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




Similar Topics: Excel file locked for editing     x


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

featured