I have multiple files that have the same name and I would
like to open them with Excel at the same time so I can
compare all information. The problem is, Excel 2007
won't let me open a file with the same name if another
file of the same name is already open.

How can I open multiple files simultaneously that have the
same name??

you have to open 2 instances of excel.

--


Gary Keramidas
Excel 2003


"Robert Crandal" wrote in message
...
I have multiple files that have the same name and I would
like to open them with Excel at the same time so I can
compare all information. The problem is, Excel 2007
won't let me open a file with the same name if another
file of the same name is already open.

How can I open multiple files simultaneously that have the
same name??

Does excel have a setting regarding automatically opening 2 or more
instances??


"Gary Keramidas" wrote in message
...

you have to open 2 instances of excel.

"Robert Crandal" wrote in message
...
I have multiple files that have the same name and I would
like to open them with Excel at the same time so I can
compare all information. The problem is, Excel 2007
won't let me open a file with the same name if another
file of the same name is already open.

How can I open multiple files simultaneously that have the
same name??



Rename one of them temporarily ?

Tim

I was hoping Excel had a "open doc in new instance" setting
somewhere, because renaming the files temporarily will not
work in my case or will be too inconvenient for users.


"Tim Williams" wrote in message
...

Rename one of them temporarily ?

Tim

Set options in Excel for "ignore other applications.

Have your workbook open in an instance of Excel.

Then open your same named workbook from its folder by double-click......do
not go through FileOpen.

You will start a new instance of Excel and open the same file in the new
instance but you will get the "locked for editing" message and can open in
"read only" mode.


Gord Dibben MS Excel MVP

On Wed, 3 Feb 2010 22:39:24 -0700, "Robert Crandal"
wrote:

I was hoping Excel had a "open doc in new instance" setting
somewhere, because renaming the files temporarily will not
work in my case or will be too inconvenient for users.


"Tim Williams" wrote in message
...

Rename one of them temporarily ?

Tim

I was able to find an option called "Ignore other applications
that use Dynamic Data Exchange (DDE)". Was this the same
thing you mention below??

Also, I went ahead and set the above option, but when I
double on ANY macro enabled file I get an error message
that said something like "Excel cannot find the file".

BTW, I'm using Excel 2007


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...

Set options in Excel for "ignore other applications.

Have your workbook open in an instance of Excel.

Then open your same named workbook from its folder by double-click......do
not go through FileOpen.

You will start a new instance of Excel and open the same file in the new
instance but you will get the "locked for editing" message and can open in
"read only" mode.

On Thu, 4 Feb 2010 11:40:45 -0700, "Robert Crandal"
wrote:

I was able to find an option called "Ignore other applications
that use Dynamic Data Exchange (DDE)". Was this the same
thing you mention below??

Yes


Also, I went ahead and set the above option, but when I
double on ANY macro enabled file I get an error message
that said something like "Excel cannot find the file".

That's most likely because you have no double quotes around your command
line to start Excel.

"C:\yourpath\excel.exe"

I would suggest you re-register Excel 2007

Close Excel first and On the Windows Taskbar

StartRun "excel.exe /regserver"(no quotes)OK.

See the space between exe and /regserver

You might have to designate a full path to excel.exe.

In that case StartRun "C:\yourpath\excel.exe" /regserver(quotes
required)OK

After re-reg open Excel, go in and make sure the "ignore other etc." is
still checked.

I'm not sure why you want to open a bunch of read-only files in the first
place.


Gord


BTW, I'm using Excel 2007


"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .

Set options in Excel for "ignore other applications.

Have your workbook open in an instance of Excel.

Then open your same named workbook from its folder by double-click......do
not go through FileOpen.

You will start a new instance of Excel and open the same file in the new
instance but you will get the "locked for editing" message and can open in
"read only" mode.