Home » Questions » Computers [ Ask a new question ]

Open Multiple Instances of Excel without PERSONAL.xlsb Lock Message

Open Multiple Instances of Excel without PERSONAL.xlsb Lock Message

Whenever I open more than I instance of Excel, I get the following message:

Asked by: Guest | Views: 55
Total answers/comments: 2
Guest [Entry]

"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"
Guest [Entry]

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.