+ Reply to Thread
Results 1 to 2 of 2

"PERSONAL.XLSB is locked for editing" notice when opening second instance of excel

  1. #1
    Registered User
    Join Date
    06-13-2012
    Location
    Philadelphia
    MS-Off Ver
    Excel 2007
    Posts
    32

    "PERSONAL.XLSB is locked for editing" notice when opening second instance of excel

    Hello,

    Whenever I open a second instance of excel on my computer (running XP and Office 2007), I have a box come up that tells me "PERSONAL.XLSB is locked for editing." This occurred after playing around with VBA, but I am not sure why. Is there a way to locate the PERSONAL.XLSB and either close it or get rid of it for good? It doesn't necessarily lead to any problems, but it is kind of annoying to see every time excel is opened.

    Any advice would be great.

    Thanks, csch123

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: "PERSONAL.XLSB is locked for editing" notice when opening second instance of excel

    I guess that you have recorded a macro and saved it to personal.xlsb & so created the workbook. IT should be somewhere like

    at C:\Documents and Settings\user name\Application Data\Microsoft\Excel\XLStart

    Find it & delete it
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ 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