Opening Multiple files simultaneously

L

Lothar

I am trying to open several excel files at once, ie.
select 2 or more files, right click, then click open, but
I cannot get them to open at the same time. I have to
open each file separately. I can have several files open
at once but they must be opened individually
 
N

Nick

Hi Lothar, I am not sure of a VBA way to do this but you
can certainly open multiple files when using Explorer.
Just shift+click the files you require, right click and
open files.

Regards, Nick.
 
L

Lady Layla

In Excel go to tools options general See if Ignore other applications is
checked or unchecked. Try changing it to the opposite setting
 
L

Lothar

Thank you for your recommendation, Ladylayla. However,
this does not seem to work either.

Lothar
 
D

Dave Peterson

You have one more response at your other post.

I am trying to open several excel files at once, ie.
select 2 or more files, right click, then click open, but
I cannot get them to open at the same time. I have to
open each file separately. I can have several files open
at once but they must be opened individually
 
L

Lothar

Thank you for your response, Dave. I tried your
recommendation but I was unsuccessful. I'm ready to give
up. If you can think of anything else, please e-mail me
at (e-mail address removed)

Lothar
 
D

Dave Peterson

Not to be too irritating, but I just want to make sure you tried selecting your
files and then clicked the Open button on the dialog--not rightclick|open.

But I don't have any other suggestion.

====
Here's something that you may want to try, but I have no faith in it (but it
won't hurt).

Close excel
windows Start button
Run
Excel /regserver

It resets the windows registry to factory defaults.

(You really clicked the open button on the dialog???? Now, I'm getting
irritating!)
 
L

Lothar

No problem, Dave. I did it the correct way, but still no
luck! If I find an answer, I will post it!

Lothar
 

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

Top