PERSONAL.xlsb locked for editing??

Discussion in 'Microsoft Excel Discussion' started by Ed from AZ, Jun 24, 2008.

  1. Ed from AZ

    Ed from AZ Guest

    I have my PERSONAL.xlsb in UserName\Application Data\Microsoft\Excel
    \XLStart so it opens when I open a workbook. In XL2003, I could open
    any number of workbooks and never had a problem. In 2007, though, If
    I open a second workbook, I get the notice that "PERSONAL.xlsb is
    locked for editing" by me.

    How can I avoid this?

    Ed
     
    Ed from AZ, Jun 24, 2008
    #1
    1. Advertisements

  2. You could open the second and subsequent workbooks in the same instance of
    excel.

    Ed from AZ wrote:
    >
    > I have my PERSONAL.xlsb in UserName\Application Data\Microsoft\Excel
    > \XLStart so it opens when I open a workbook. In XL2003, I could open
    > any number of workbooks and never had a problem. In 2007, though, If
    > I open a second workbook, I get the notice that "PERSONAL.xlsb is
    > locked for editing" by me.
    >
    > How can I avoid this?
    >
    > Ed


    --

    Dave Peterson
     
    Dave Peterson, Jun 25, 2008
    #2
    1. Advertisements

  3. Ed from AZ

    Ed from AZ Guest

    Did something change in XL2007 as to how the program handles opening
    multiple files? Or do I have a setting off somewhere? In XL2003, I
    could simple double-click another Excel file and it would open with no
    warnings. In XL2007, I have to drill down through the Open command to
    avoid this?? That's a royal pain!!

    Ed


    On Jun 24, 4:35 pm, Dave Peterson <> wrote:
    > You could open the second and subsequent workbooks in the same instance of
    > excel.
    >
    > Ed from AZ wrote:
    >
    > > I have my PERSONAL.xlsb in UserName\Application Data\Microsoft\Excel
    > > \XLStart so it opens when I open a workbook.  In XL2003, I could open
    > > any number of workbooks and never had a problem.  In 2007, though, If
    > > I open a second workbook, I get the notice that "PERSONAL.xlsb is
    > > locked for editing" by me.

    >
    > > How can I avoid this?

    >
    > > Ed

    >
    > --
    >
    > Dave Peterson
     
    Ed from AZ, Jun 25, 2008
    #3
  4. In xl2003 and below, I'd do one of these:

    Tools|Options|General|Ignore other applications (uncheck it)

    --- or ---

    Close Excel and
    Windows Start Button|Run
    excel /unregserver
    then
    Windows Start Button|Run
    excel /regserver

    The /unregserver & /regserver stuff resets some of the windows registry to
    excel's factory defaults.

    ====
    In xl2007, that first one is:
    Office button|excel options|Advanced category
    Ignore other applications that use Dynamic Data Exchange (DDE) (Uncheck it)



    Ed from AZ wrote:
    >
    > Did something change in XL2007 as to how the program handles opening
    > multiple files? Or do I have a setting off somewhere? In XL2003, I
    > could simple double-click another Excel file and it would open with no
    > warnings. In XL2007, I have to drill down through the Open command to
    > avoid this?? That's a royal pain!!
    >
    > Ed
    >
    > On Jun 24, 4:35 pm, Dave Peterson <> wrote:
    > > You could open the second and subsequent workbooks in the same instance of
    > > excel.
    > >
    > > Ed from AZ wrote:
    > >
    > > > I have my PERSONAL.xlsb in UserName\Application Data\Microsoft\Excel
    > > > \XLStart so it opens when I open a workbook. In XL2003, I could open
    > > > any number of workbooks and never had a problem. In 2007, though, If
    > > > I open a second workbook, I get the notice that "PERSONAL.xlsb is
    > > > locked for editing" by me.

    > >
    > > > How can I avoid this?

    > >
    > > > Ed

    > >
    > > --
    > >
    > > Dave Peterson


    --

    Dave Peterson
     
    Dave Peterson, Jun 25, 2008
    #4
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Lenny

    Excel Macro --- personal.xls locked for editing

    Lenny, Nov 7, 2006, in forum: Microsoft Excel Discussion
    Replies:
    1
    Views:
    569
    Dave Peterson
    Nov 7, 2006
  2. James Graham

    Personal.xlsb does not load automatically when I start Excel 2007

    James Graham, Aug 1, 2007, in forum: Microsoft Excel Discussion
    Replies:
    14
    Views:
    6,830
  3. C C

    Excel 2007 double close when you have PERSONAL.XLSB

    C C, Sep 25, 2007, in forum: Microsoft Excel Discussion
    Replies:
    0
    Views:
    258
  4. GlennUK

    Excel Send xlsb workbook problem

    GlennUK, May 14, 2008, in forum: Microsoft Excel Discussion
    Replies:
    6
    Views:
    370
    Ron de Bruin
    May 23, 2008
  5. herrdue

    Personal.XLSB comes up by default launching Excel 2007

    herrdue, Oct 7, 2011, in forum: Microsoft Excel Discussion
    Replies:
    1
    Views:
    438
    Dave Peterson
    Oct 8, 2011
Loading...

Share This Page