Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,101
Default Opening multiple XLS files

From windows explorer, when I open an XLS file, it opens a new instance of
Excel. I'd like ot have it so all the XLS files I open are in the same
instance of Excel. This used to work this way but I just got a new laptop
and an upgrade to Office 2003. How do I change Excel to get this behavior?

Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 29
Default Opening multiple XLS files

Tools, Options, View tab - Windows in Taskbar. ??

"Mike" wrote:

From windows explorer, when I open an XLS file, it opens a new instance of
Excel. I'd like ot have it so all the XLS files I open are in the same
instance of Excel. This used to work this way but I just got a new laptop
and an upgrade to Office 2003. How do I change Excel to get this behavior?

Thanks!

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Opening multiple XLS files

Sometimes one of these works when you're having trouble with double clicking on
the file in windows explorer:

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets some of the windows registry to
excel's factory defaults.

Mike wrote:

From windows explorer, when I open an XLS file, it opens a new instance of
Excel. I'd like ot have it so all the XLS files I open are in the same
instance of Excel. This used to work this way but I just got a new laptop
and an upgrade to Office 2003. How do I change Excel to get this behavior?

Thanks!


--

Dave Peterson
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,101
Default Opening multiple XLS files

Had that alredy. I think in the folder options there is a /e that causes a
new instance of excel to open, I remove that and they all opn in the same
window. However now when I open a file, it tells me it is already open. :-(
It shouldn't be this hard to do basic funstions that once worked.

"Dave Peterson" wrote:

Sometimes one of these works when you're having trouble with double clicking on
the file in windows explorer:

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets some of the windows registry to
excel's factory defaults.

Mike wrote:

From windows explorer, when I open an XLS file, it opens a new instance of
Excel. I'd like ot have it so all the XLS files I open are in the same
instance of Excel. This used to work this way but I just got a new laptop
and an upgrade to Office 2003. How do I change Excel to get this behavior?

Thanks!


--

Dave Peterson

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Opening multiple XLS files

The /e just tells Excel not to open the default Book1 or show the splash
screen.

Does not open a new instance of Excel.

Try Dave's suggestions again.

Should do the job.


Gord Dibben MS Excel MVP

On Thu, 19 Jun 2008 06:43:06 -0700, Mike wrote:

I think in the folder options there is a /e that causes a
new instance of excel to open,




  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Opening multiple XLS files

I can't open xls file using my documents. massage states: can't find file,
check info and try again. File will open if I open Excel first and then it
will open my file.

"Mike" wrote:

From windows explorer, when I open an XLS file, it opens a new instance of
Excel. I'd like ot have it so all the XLS files I open are in the same
instance of Excel. This used to work this way but I just got a new laptop
and an upgrade to Office 2003. How do I change Excel to get this behavior?

Thanks!

  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Opening multiple XLS files

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 Thu, 19 Jun 2008 11:25:02 -0700, Paul Caldarone
wrote:

I can't open xls file using my documents. massage states: can't find file,
check info and try again. File will open if I open Excel first and then it
will open my file.

"Mike" wrote:

From windows explorer, when I open an XLS file, it opens a new instance of
Excel. I'd like ot have it so all the XLS files I open are in the same
instance of Excel. This used to work this way but I just got a new laptop
and an upgrade to Office 2003. How do I change Excel to get this behavior?

Thanks!


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 multiple files into one workbook, but multiple worksheets.... Andy Excel Discussion (Misc queries) 0 January 24th 07 06:34 PM
opening multiple .txt files from multiple folders Corben Excel Discussion (Misc queries) 3 March 16th 06 12:43 AM
Opening multiple files separately pjyelton Excel Discussion (Misc queries) 5 August 27th 05 01:29 PM
How can I view files chronologically when opening multiple files Stevilsize Excel Discussion (Misc queries) 3 July 26th 05 12:49 AM
Opening multiple files Subhro Mukherjee via OfficeKB.com Links and Linking in Excel 1 June 22nd 05 11:43 PM


All times are GMT +1. The time now is 03:21 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"