none
"PERSONAL.XLS Is Locked" In Excel 2010 Everytime two different excel documents are opened by this user.

    Question

  • <//span>I have a user that everytime he attemps to open multiple excel files he get this error message repeatedly that states:

    "

    Each Excel file that is opened prompts the following message. Tried reinstalling his micosoft suite thinking that may be the fix. That did not work figuered i would try posting and see if anybody had any sound advice for where to start to look for a fix.

    Monday, April 30, 2012 8:55 PM

Answers

  • Apparently each workbook is opened in a new instance of Excel.

    Let him try this:

    Select File | Options.

    Click Advanced.

    Scroll down to the General section.

    If the check box "Ignore other applications that use Dynamic Data Exchange (DDE)" is ticked, clear it, then click OK.

    Otherwise, let him open the workbooks from within Excel (it is possible to select multiple workbooks in the Open dialog)


    Regards, Hans Vogelaar

    Monday, April 30, 2012 9:05 PM