+ Reply to Thread
Results 1 to 2 of 2

Excel File is Locked for Editing

  1. #1
    Registered User
    Join Date
    01-12-2012
    Location
    USA
    MS-Off Ver
    Excel 2007, 2003
    Posts
    84

    Excel File is Locked for Editing

    I recently built a VB.NET project which reads some data from text files and then populates an Excel spreadsheet. In this sheet there are some formulas which I use to build some bar charts. The boss liked this so well he did some kind of link to it from another file to post it on a big screen TV in the customer service room. Since he did this my program can no longer write to this Excel file. Each time I try it is throws an exception indicating that the file is locked. Even when I just try to open the file it pops ups a window which says the file is locked for editing by 'User'. There is no one using that login name as far as I know on this network. And of course the boss says I'm crazy and he's not acknowledging that the link he created could be causing the trouble. To test my theory, I built another Excel file in the same folder and I can write to it via my program all I want. But when I try to go back to the original file. it fails.

    Can anyone comment on this?
    Wish I didn't know now what I didn't know then.

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Excel File is Locked for Editing

    Another instance of the file is definitely running. Is the big screen run by a pc on the network?

    If you have a LAN/Server group I would talk to them about forcing the "user" out of the spreadsheet.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1