Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default run a single instance of excel

When I click on a file in windows explorer, it opens that file in a new
instance of excel. I know that it is supposed to open up in the same instance
of excel. How do I get new files that I click on in windows explorer to open
up in the currently running instance of excel by default like it should be?

I don't know if this has anything to do with it, but when I look at the
shortcut to excel in C:\Documents and Settings\All Users\Start
Menu\Programs\Microsoft Office and click the advanced properties, the "run in
separate memory space" is checked and grayed out so I can't change it.

Thanks for any help,
Randy
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default run a single instance of excel

Try the usual fix for this.

ToolsOptionsGeneral Uncheck "Ignore Other Applications"

If no joy with that................

Close Excel first and On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) 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.


Gord Dibben MS Excel MVP

On Mon, 1 Dec 2008 14:39:01 -0800, Teamlevy
wrote:

When I click on a file in windows explorer, it opens that file in a new
instance of excel. I know that it is supposed to open up in the same instance
of excel. How do I get new files that I click on in windows explorer to open
up in the currently running instance of excel by default like it should be?

I don't know if this has anything to do with it, but when I look at the
shortcut to excel in C:\Documents and Settings\All Users\Start
Menu\Programs\Microsoft Office and click the advanced properties, the "run in
separate memory space" is checked and grayed out so I can't change it.

Thanks for any help,
Randy


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default run a single instance of excel

I tried everything mentioned below and it did not change anything. When I run
"1) StartRun "excel.exe /unregserver"(no quotes)OK. " it doesn't seem to do
anything, but when I run "2) StartRun "excel.exe /regserver"(no quotes)OK."
windows installer pops up and acts like it is doing something. I tried
rebooting after running 1) & 2) above, but that didn't help either.

I don't know if this matters, but I am running windows XP in Parallels on a
Mac.


"Gord Dibben" wrote:

Try the usual fix for this.

ToolsOptionsGeneral Uncheck "Ignore Other Applications"

If no joy with that................

Close Excel first and On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) 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.


Gord Dibben MS Excel MVP

On Mon, 1 Dec 2008 14:39:01 -0800, Teamlevy
wrote:

When I click on a file in windows explorer, it opens that file in a new
instance of excel. I know that it is supposed to open up in the same instance
of excel. How do I get new files that I click on in windows explorer to open
up in the currently running instance of excel by default like it should be?

I don't know if this has anything to do with it, but when I look at the
shortcut to excel in C:\Documents and Settings\All Users\Start
Menu\Programs\Microsoft Office and click the advanced properties, the "run in
separate memory space" is checked and grayed out so I can't change it.

Thanks for any help,
Randy



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default run a single instance of excel

I have had no experience running XP in parallels on a Mac

Might have something to do with the problem.

The unregserver won't show it is doing anything.

The regserver coomand normally takes a while.........several
minutes.......to complete


Gord

On Mon, 1 Dec 2008 16:15:02 -0800, Teamlevy
wrote:

I tried everything mentioned below and it did not change anything. When I run
"1) StartRun "excel.exe /unregserver"(no quotes)OK. " it doesn't seem to do
anything, but when I run "2) StartRun "excel.exe /regserver"(no quotes)OK."
windows installer pops up and acts like it is doing something. I tried
rebooting after running 1) & 2) above, but that didn't help either.

I don't know if this matters, but I am running windows XP in Parallels on a
Mac.


"Gord Dibben" wrote:

Try the usual fix for this.

ToolsOptionsGeneral Uncheck "Ignore Other Applications"

If no joy with that................

Close Excel first and On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) 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.


Gord Dibben MS Excel MVP

On Mon, 1 Dec 2008 14:39:01 -0800, Teamlevy
wrote:

When I click on a file in windows explorer, it opens that file in a new
instance of excel. I know that it is supposed to open up in the same instance
of excel. How do I get new files that I click on in windows explorer to open
up in the currently running instance of excel by default like it should be?

I don't know if this has anything to do with it, but when I look at the
shortcut to excel in C:\Documents and Settings\All Users\Start
Menu\Programs\Microsoft Office and click the advanced properties, the "run in
separate memory space" is checked and grayed out so I can't change it.

Thanks for any help,
Randy




  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default run a single instance of excel

Of course they say it is an excel issue. Is there anything else I can try?
I'd really like to have only one instance of excel open by default.

Thanks,
Randy

"Gord Dibben" wrote:

I have had no experience running XP in parallels on a Mac

Might have something to do with the problem.

The unregserver won't show it is doing anything.

The regserver coomand normally takes a while.........several
minutes.......to complete


Gord

On Mon, 1 Dec 2008 16:15:02 -0800, Teamlevy
wrote:

I tried everything mentioned below and it did not change anything. When I run
"1) StartRun "excel.exe /unregserver"(no quotes)OK. " it doesn't seem to do
anything, but when I run "2) StartRun "excel.exe /regserver"(no quotes)OK."
windows installer pops up and acts like it is doing something. I tried
rebooting after running 1) & 2) above, but that didn't help either.

I don't know if this matters, but I am running windows XP in Parallels on a
Mac.


"Gord Dibben" wrote:

Try the usual fix for this.

ToolsOptionsGeneral Uncheck "Ignore Other Applications"

If no joy with that................

Close Excel first and On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) 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.


Gord Dibben MS Excel MVP

On Mon, 1 Dec 2008 14:39:01 -0800, Teamlevy
wrote:

When I click on a file in windows explorer, it opens that file in a new
instance of excel. I know that it is supposed to open up in the same instance
of excel. How do I get new files that I click on in windows explorer to open
up in the currently running instance of excel by default like it should be?

I don't know if this has anything to do with it, but when I look at the
shortcut to excel in C:\Documents and Settings\All Users\Start
Menu\Programs\Microsoft Office and click the advanced properties, the "run in
separate memory space" is checked and grayed out so I can't change it.

Thanks for any help,
Randy






  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default run a single instance of excel

If "they" say it is an Excel problem perhaps "they" should resolve it.

The steps I gave will most always get you one instance of Excel.

You could try these manual steps..............

Go to StartSettingsControl PanelFolder OptionsFile Types

If using WinXP OS you would scroll down to .XLS then "Advanced"OpenEdit.

In Command line the path should be similar to this....

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE10\EXCEL.EXE" /e

You must have the double quotes and the <space/e prevents a new blank book
from opening.

Below have "use DDE" checked and this in the DDE message box....[open("%1")]

Application should read "Excel"(no quotes)

Again...........if no joy, I'm out of ideas.


Gord


On Wed, 3 Dec 2008 11:31:29 -0800, Teamlevy
wrote:

Of course they say it is an excel issue. Is there anything else I can try?
I'd really like to have only one instance of excel open by default.

Thanks,
Randy

"Gord Dibben" wrote:

I have had no experience running XP in parallels on a Mac

Might have something to do with the problem.

The unregserver won't show it is doing anything.

The regserver coomand normally takes a while.........several
minutes.......to complete


Gord

On Mon, 1 Dec 2008 16:15:02 -0800, Teamlevy
wrote:

I tried everything mentioned below and it did not change anything. When I run
"1) StartRun "excel.exe /unregserver"(no quotes)OK. " it doesn't seem to do
anything, but when I run "2) StartRun "excel.exe /regserver"(no quotes)OK."
windows installer pops up and acts like it is doing something. I tried
rebooting after running 1) & 2) above, but that didn't help either.

I don't know if this matters, but I am running windows XP in Parallels on a
Mac.


"Gord Dibben" wrote:

Try the usual fix for this.

ToolsOptionsGeneral Uncheck "Ignore Other Applications"

If no joy with that................

Close Excel first and On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) 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.


Gord Dibben MS Excel MVP

On Mon, 1 Dec 2008 14:39:01 -0800, Teamlevy
wrote:

When I click on a file in windows explorer, it opens that file in a new
instance of excel. I know that it is supposed to open up in the same instance
of excel. How do I get new files that I click on in windows explorer to open
up in the currently running instance of excel by default like it should be?

I don't know if this has anything to do with it, but when I look at the
shortcut to excel in C:\Documents and Settings\All Users\Start
Menu\Programs\Microsoft Office and click the advanced properties, the "run in
separate memory space" is checked and grayed out so I can't change it.

Thanks for any help,
Randy





  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default run a single instance of excel

Thanks! that seems to have worked!

It is wierd, though, because when I went to Folder Options: File Types in
control panel and change the file type associated with .xls files to excel,
under €œdetails for €˜XLS extension, it says, €œYou have customized files with
extension €˜XLS. To restore these files to their default type
(xls_auto_file), click Restore.€ When I do click Restore, re-associate xls
files with excel and then click on Advanced, it then has no actions. I added
"open" as an action and followed your instructions. That worked, but when I
go to another windows machine it shows other "actions." Do I need to add all
the other actions that are missing or should I be ok with just the "open"
action?

Thanks again,
Randy

"Gord Dibben" wrote:

If "they" say it is an Excel problem perhaps "they" should resolve it.

The steps I gave will most always get you one instance of Excel.

You could try these manual steps..............

Go to StartSettingsControl PanelFolder OptionsFile Types

If using WinXP OS you would scroll down to .XLS then "Advanced"OpenEdit.

In Command line the path should be similar to this....

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE10\EXCEL.EXE" /e

You must have the double quotes and the <space/e prevents a new blank book
from opening.

Below have "use DDE" checked and this in the DDE message box....[open("%1")]

Application should read "Excel"(no quotes)

Again...........if no joy, I'm out of ideas.


Gord


On Wed, 3 Dec 2008 11:31:29 -0800, Teamlevy
wrote:

Of course they say it is an excel issue. Is there anything else I can try?
I'd really like to have only one instance of excel open by default.

Thanks,
Randy

"Gord Dibben" wrote:

I have had no experience running XP in parallels on a Mac

Might have something to do with the problem.

The unregserver won't show it is doing anything.

The regserver coomand normally takes a while.........several
minutes.......to complete


Gord

On Mon, 1 Dec 2008 16:15:02 -0800, Teamlevy
wrote:

I tried everything mentioned below and it did not change anything. When I run
"1) StartRun "excel.exe /unregserver"(no quotes)OK. " it doesn't seem to do
anything, but when I run "2) StartRun "excel.exe /regserver"(no quotes)OK."
windows installer pops up and acts like it is doing something. I tried
rebooting after running 1) & 2) above, but that didn't help either.

I don't know if this matters, but I am running windows XP in Parallels on a
Mac.


"Gord Dibben" wrote:

Try the usual fix for this.

ToolsOptionsGeneral Uncheck "Ignore Other Applications"

If no joy with that................

Close Excel first and On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) 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.


Gord Dibben MS Excel MVP

On Mon, 1 Dec 2008 14:39:01 -0800, Teamlevy
wrote:

When I click on a file in windows explorer, it opens that file in a new
instance of excel. I know that it is supposed to open up in the same instance
of excel. How do I get new files that I click on in windows explorer to open
up in the currently running instance of excel by default like it should be?

I don't know if this has anything to do with it, but when I look at the
shortcut to excel in C:\Documents and Settings\All Users\Start
Menu\Programs\Microsoft Office and click the advanced properties, the "run in
separate memory space" is checked and grayed out so I can't change it.

Thanks for any help,
Randy






  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default run a single instance of excel

I forgot to mention that after the fix, the File type still says,
"xls_auto_file" and not "Microsoft Excel Workbook" like it does on the other
machine I checked.

"Teamlevy" wrote:

Thanks! that seems to have worked!

It is wierd, though, because when I went to Folder Options: File Types in
control panel and change the file type associated with .xls files to excel,
under €œdetails for €˜XLS extension, it says, €œYou have customized files with
extension €˜XLS. To restore these files to their default type
(xls_auto_file), click Restore.€ When I do click Restore, re-associate xls
files with excel and then click on Advanced, it then has no actions. I added
"open" as an action and followed your instructions. That worked, but when I
go to another windows machine it shows other "actions." Do I need to add all
the other actions that are missing or should I be ok with just the "open"
action?

Thanks again,
Randy

"Gord Dibben" wrote:

If "they" say it is an Excel problem perhaps "they" should resolve it.

The steps I gave will most always get you one instance of Excel.

You could try these manual steps..............

Go to StartSettingsControl PanelFolder OptionsFile Types

If using WinXP OS you would scroll down to .XLS then "Advanced"OpenEdit.

In Command line the path should be similar to this....

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE10\EXCEL.EXE" /e

You must have the double quotes and the <space/e prevents a new blank book
from opening.

Below have "use DDE" checked and this in the DDE message box....[open("%1")]

Application should read "Excel"(no quotes)

Again...........if no joy, I'm out of ideas.


Gord


On Wed, 3 Dec 2008 11:31:29 -0800, Teamlevy
wrote:

Of course they say it is an excel issue. Is there anything else I can try?
I'd really like to have only one instance of excel open by default.

Thanks,
Randy

"Gord Dibben" wrote:

I have had no experience running XP in parallels on a Mac

Might have something to do with the problem.

The unregserver won't show it is doing anything.

The regserver coomand normally takes a while.........several
minutes.......to complete


Gord

On Mon, 1 Dec 2008 16:15:02 -0800, Teamlevy
wrote:

I tried everything mentioned below and it did not change anything. When I run
"1) StartRun "excel.exe /unregserver"(no quotes)OK. " it doesn't seem to do
anything, but when I run "2) StartRun "excel.exe /regserver"(no quotes)OK."
windows installer pops up and acts like it is doing something. I tried
rebooting after running 1) & 2) above, but that didn't help either.

I don't know if this matters, but I am running windows XP in Parallels on a
Mac.


"Gord Dibben" wrote:

Try the usual fix for this.

ToolsOptionsGeneral Uncheck "Ignore Other Applications"

If no joy with that................

Close Excel first and On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) 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.


Gord Dibben MS Excel MVP

On Mon, 1 Dec 2008 14:39:01 -0800, Teamlevy
wrote:

When I click on a file in windows explorer, it opens that file in a new
instance of excel. I know that it is supposed to open up in the same instance
of excel. How do I get new files that I click on in windows explorer to open
up in the currently running instance of excel by default like it should be?

I don't know if this has anything to do with it, but when I look at the
shortcut to excel in C:\Documents and Settings\All Users\Start
Menu\Programs\Microsoft Office and click the advanced properties, the "run in
separate memory space" is checked and grayed out so I can't change it.

Thanks for any help,
Randy






  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default run a single instance of excel

I have never seen that message about customized files.

What version of Excel are you running?

I don't use 2007 so can't speak to that.

It could be due to the running of WinXP on a Mac.............but that's only
a guess.

As far as the other actions like new or print, you should also change them.

If the regserver command worked that would all be taken care of, but you
said it did not work so manual intervention would seem to be the way to go.


Gord


On Thu, 4 Dec 2008 06:55:00 -0800, Teamlevy
wrote:

Thanks! that seems to have worked!

It is wierd, though, because when I went to Folder Options: File Types in
control panel and change the file type associated with .xls files to excel,
under “details for ‘XLS’ extension, it says, “You have customized files with
extension ‘XLS’. To restore these files to their default type
(xls_auto_file), click Restore.” When I do click Restore, re-associate xls
files with excel and then click on Advanced, it then has no actions. I added
"open" as an action and followed your instructions. That worked, but when I
go to another windows machine it shows other "actions." Do I need to add all
the other actions that are missing or should I be ok with just the "open"
action?

Thanks again,
Randy

"Gord Dibben" wrote:

If "they" say it is an Excel problem perhaps "they" should resolve it.

The steps I gave will most always get you one instance of Excel.

You could try these manual steps..............

Go to StartSettingsControl PanelFolder OptionsFile Types

If using WinXP OS you would scroll down to .XLS then "Advanced"OpenEdit.

In Command line the path should be similar to this....

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE10\EXCEL.EXE" /e

You must have the double quotes and the <space/e prevents a new blank book
from opening.

Below have "use DDE" checked and this in the DDE message box....[open("%1")]

Application should read "Excel"(no quotes)

Again...........if no joy, I'm out of ideas.


Gord


On Wed, 3 Dec 2008 11:31:29 -0800, Teamlevy
wrote:

Of course they say it is an excel issue. Is there anything else I can try?
I'd really like to have only one instance of excel open by default.

Thanks,
Randy

"Gord Dibben" wrote:

I have had no experience running XP in parallels on a Mac

Might have something to do with the problem.

The unregserver won't show it is doing anything.

The regserver coomand normally takes a while.........several
minutes.......to complete


Gord

On Mon, 1 Dec 2008 16:15:02 -0800, Teamlevy
wrote:

I tried everything mentioned below and it did not change anything. When I run
"1) StartRun "excel.exe /unregserver"(no quotes)OK. " it doesn't seem to do
anything, but when I run "2) StartRun "excel.exe /regserver"(no quotes)OK."
windows installer pops up and acts like it is doing something. I tried
rebooting after running 1) & 2) above, but that didn't help either.

I don't know if this matters, but I am running windows XP in Parallels on a
Mac.


"Gord Dibben" wrote:

Try the usual fix for this.

ToolsOptionsGeneral Uncheck "Ignore Other Applications"

If no joy with that................

Close Excel first and On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) 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.


Gord Dibben MS Excel MVP

On Mon, 1 Dec 2008 14:39:01 -0800, Teamlevy
wrote:

When I click on a file in windows explorer, it opens that file in a new
instance of excel. I know that it is supposed to open up in the same instance
of excel. How do I get new files that I click on in windows explorer to open
up in the currently running instance of excel by default like it should be?

I don't know if this has anything to do with it, but when I look at the
shortcut to excel in C:\Documents and Settings\All Users\Start
Menu\Programs\Microsoft Office and click the advanced properties, the "run in
separate memory space" is checked and grayed out so I can't change it.

Thanks for any help,
Randy







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
opening a new instance of Excel gb4 Setting up and Configuration of Excel 0 April 10th 08 04:48 PM
Excel instance won't quit [email protected] Excel Discussion (Misc queries) 0 September 6th 06 06:57 PM
keep Excel from opening 2nd instance widman Excel Discussion (Misc queries) 0 April 30th 06 01:35 PM
Return Single Instance of Numeric Values from a Column Sam via OfficeKB.com Excel Worksheet Functions 4 August 26th 05 03:10 AM
Excel instance not shut down Macca Excel Worksheet Functions 0 December 13th 04 03:55 PM


All times are GMT +1. The time now is 01:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright Š2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"