S
SidBord
It started when I was using Win 98. Now I'm using Win XP, Excel 2004(?).
For no apparent reason, some of my workbooks will get the "Locked for
Editing..." notice. It keeps me from creating backup files and from
deleting a workbook. And of course I can't update a workbook having this
condition. I know I can do a restart and clear the condition, sometimes
only temporarily and sometimes for several days. I am the ONLY user of my
computer and I am NOT on a network. I regularly run Spybot, Norton Antivirus,
Norton Internet Security System, Ad-aware. They all say the system is
clean. I update all systems regularly. The locked condition does not
occur just when a workbook session crashes (which is seldom). It occurs
just by using the workbook. I don't know it's occurred until the next time I
open the workbook, or my backup system complains.
My most recent experience is with a small workbook that I decided to add a
chart to. Everything worked great., except then I started getting the
"locked" condition. I would sometimes have to restart my computer 3 or 4
times in an hour just so I could go in and out of that workbook. After a
month of trying to find the problem, I decided to move the chart to another
workbook and link to the original to get the data. That went well, and it
seems to have stopped the "locked" condition from occurring. Why would a
chart cause the problem?? I have about 50 workbooks, some with as many as 20
charts that seldome if ever have the "locked" condition. The only thing
different about the most recent one if that I wrote some macros that will
move the chart up and down in the window under certain conditions. I also
wrote macros to scroll the window under certain conditions. None of my
other workbooks have these macros. I'd love to have a means of releasing
the "lock" without haviing to restart my computer. Anyone out there have
any ideas?
For no apparent reason, some of my workbooks will get the "Locked for
Editing..." notice. It keeps me from creating backup files and from
deleting a workbook. And of course I can't update a workbook having this
condition. I know I can do a restart and clear the condition, sometimes
only temporarily and sometimes for several days. I am the ONLY user of my
computer and I am NOT on a network. I regularly run Spybot, Norton Antivirus,
Norton Internet Security System, Ad-aware. They all say the system is
clean. I update all systems regularly. The locked condition does not
occur just when a workbook session crashes (which is seldom). It occurs
just by using the workbook. I don't know it's occurred until the next time I
open the workbook, or my backup system complains.
My most recent experience is with a small workbook that I decided to add a
chart to. Everything worked great., except then I started getting the
"locked" condition. I would sometimes have to restart my computer 3 or 4
times in an hour just so I could go in and out of that workbook. After a
month of trying to find the problem, I decided to move the chart to another
workbook and link to the original to get the data. That went well, and it
seems to have stopped the "locked" condition from occurring. Why would a
chart cause the problem?? I have about 50 workbooks, some with as many as 20
charts that seldome if ever have the "locked" condition. The only thing
different about the most recent one if that I wrote some macros that will
move the chart up and down in the window under certain conditions. I also
wrote macros to scroll the window under certain conditions. None of my
other workbooks have these macros. I'd love to have a means of releasing
the "lock" without haviing to restart my computer. Anyone out there have
any ideas?