Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

How does one disable or hide the "PERSONAL.xlsb is locked for editing" message when opening more than one instance of Excel 2007?

I have at least two instances of Excel open at all times, since I use multiple monitors, but this message is a continual annoyance. (Alternatively, if someone could suggest a way to improve Excel 2007's support for multiple monitors within a single instance, that would get around the problem as well)

Screenshot of Excel Dialog

I'm aware of the "Ignore other applications that use Dynamic Data Exchange (DDE)" but that isn't what I'm looking for, since it cripples other features that I use regularly.

share|improve this question
    
This bugged me sooo much, thank you! –  CodeBlend Aug 19 '11 at 11:03

3 Answers 3

up vote 15 down vote accepted

Unhide your Personal.xlsb and turn on the share workbook option. You can then open as many instances of Excel as you want without that pesky read-only message.

The only drawback is that if you want to actually add or edit a personal macro you will have to unhide Personal.xlsb again and turn the share option off again (you can't see or edit macros of shared workbooks, but you can run them.)

To find the share workbook option, press the 'Review' tab and then press the 'Share Workbook' button, which is in the 'Changes' group.

In Office 2007/2010, unhide personal.xlsb by opening a single instance of excel and choosing unhide from the view tab, window section, unhide button In Office 2007, share the workbook from the review tab, changes section, share workbook

share|improve this answer
2  
Outstanding! That did the trick. Thanks! –  anschauung Jan 9 '10 at 15:19
    
This bugged me sooo much, thank you! –  CodeBlend Aug 19 '11 at 11:03
3  
Thanks very much for this - it was really bugging me. Just to add: In Office 2007, unhide personal.xlsb by opening a single instance of excel and choosing unhide from the view tab, window section, unhide button In Office 2007, share the workbook from the review tab, changes section, share workbook –  sahmeepee Sep 21 '11 at 11:28

This thread provides some options on how to stop this from happening. I have not had a change to test Excel 2010 multi monitor support but I can confirm that 2007 has no way of supporting one instance with files open on multiple monitors.

share|improve this answer
    
Thanks, but I've already tried that particular solution ("Ignore other applications that use Dynamic Data Exchange (DDE)") and didn't like the result. I've edited the post so others know. –  anschauung Aug 25 '09 at 16:40
    
Thanks -- I suppose that will have to do :( –  anschauung Aug 27 '09 at 13:54

If you are not reliant on your personal macros, you can navigate to:

C:\Users\user name\AppData\Local\Microsoft\Excel\XLStart

and make the Personal.xlsb file read only. That should stop the nagging.

If 2 instances aren't necessary, you can also force Excel to open a new window for each file. It will show multiple instances in the taskbar (which I assume you can drag across monitors) but it will only have 1 copy of Excel running.

share|improve this answer
    
Is there a way to force Excel to open a new window for each file from outside Excel? That is, can I make this behavior default and not have to use Excel's open dialog? –  anschauung Aug 25 '09 at 16:37
    
not without the DDE trick unfortunately –  John T Aug 25 '09 at 17:13
    
Ugh. I can't hep but thing there's a solution somehow -- Word handles this perfectly, though probably because it doesn't load the template file as a 'hidden' document for each instance. –  anschauung Aug 25 '09 at 17:21

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.