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

personal.xls locked for editing 4
personal.xls 2
Macros Available without hiding 'personal.xls'? 3
Personal.xls will not open when I open excel 2
Problem with Personal.xls 4
Personal.xls 5
Macros in Personal.xls Not Accessible 8
Auto adding a macro when Excel 2003 opens 3

Top