Opening Multiple files simultaneously

  • Thread starter Thread starter Lothar
  • Start date Start date
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
 
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.
 
In Excel go to tools options general See if Ignore other applications is
checked or unchecked. Try changing it to the opposite setting
 
Thank you for your recommendation, Ladylayla. However,
this does not seem to work either.

Lothar
 
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
Click to expand...
 
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
 
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!)
 
No problem, Dave. I did it the correct way, but still no
luck! If I find an answer, I will post it!

Lothar
 
Back
Top