Using personal.xls in two windows

  • Thread starter Thread starter Michel
  • Start date Start date
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?
 
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.
 
Save your Personal.xls as an add-in *.xla

Should have no problem with multiple instances of Excel.


Gord Dibben MS Excel MVP
 
Back
Top