Using personal.xls in two windows

M

Michel

I've been opening two instances of excel for quite a while, but I can't get personal.xls to work in both. Is there a way to access the file and macros in both windows?
 
D

Dave Peterson

Instead of using a .xls file, you could save the workbook as an addin
(personal.xla).

If that doesn't work for you, then you could mark the personal.xls file as
ReadOnly (using windows Explorer).

It will make it a little more difficult to make changes to personal.xls, though.

You'll have to remove that readonly mark, make your changes in excel (a single
instance only!), save the workbook, and then mark it as ReadOnly.
 
G

Gord Dibben

Save your Personal.xls as an add-in *.xla

Should have no problem with multiple instances of Excel.


Gord Dibben MS Excel MVP
 

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
personal.xls 2
Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
Menu Macro Not Executing - Need Help 1
Excel freezing after sharing document by Email 0
Error After Copying Excel 2003 Macros and Toolbars from Windows Vistato Windows 7 1
Found few bugs in my daily routine of work in excel for MAC 0
personal.xls locked for editing 4

Top