File in Use Error Message

  • Thread starter Thread starter ypukpete
  • Start date Start date
Y

ypukpete

I have designed a program which contains several userforms for adding and
retrieving data. It also has several pivot tables.
It was working OK for a time but now will not open and has the error warning..
File in Use: Locked for editing by ypukpete
It occasionally pops up and says File Error: Data may be lost.
I have looked thru the MS Help site and this site and cannot find a solution.
Fortunately I had a backup of an earlier version so all is not lost.
I would like to be able to delete the program (which it wont let me)
But more importantly find the cause so I can prevent it from happening again
Thanks for any help.
 
Without seeing the code it is not easy to diagnose! Other than the program
has errors or the environment is corrupted.
 
Yes... Nigel, that is one of the problems, I cant get back in to check the
code.
Could it be a userform that hasn't closed properly and is waiting for data.?
However, if I can't get into the code, I would just prefer to delete the
program.
It would be nice however to find out what the cause is.
Any help with this would be very much appreciated.
 
Back
Top