If I have two workbooks open in Excel and try and open a third from Windows
Explorer I return to the session of Excel but the file does not open. If I
close all files the same thing continues to happen.

The only way to open more files is by using the File =gt; Open command (not as
convenient as Explorer) or starting a new session of Excel.

I have 'Windows in Taskbar' unchecked in Options because I find it
irritating with multiple files open.

FYI I have Windows XP Professional SP-2 version 5.1 amp; Excel 2002.

Any ideas?

--
R Ormerod

Hi

Try toggling Tools/Options/General/Ignore Other Applications.

Andy.

quot;R Ormerodquot; gt; wrote in message
...
gt; If I have two workbooks open in Excel and try and open a third from
gt; Windows
gt; Explorer I return to the session of Excel but the file does not open. If I
gt; close all files the same thing continues to happen.
gt;
gt; The only way to open more files is by using the File =gt; Open command (not
gt; as
gt; convenient as Explorer) or starting a new session of Excel.
gt;
gt; I have 'Windows in Taskbar' unchecked in Options because I find it
gt; irritating with multiple files open.
gt;
gt; FYI I have Windows XP Professional SP-2 version 5.1 amp; Excel 2002.
gt;
gt; Any ideas?
gt;
gt; --
gt; R Ormerod
Sometimes one of these works when you're having trouble with double clicking on
the file in windows explorer:

ToolsOptionsGeneralIgnore other applications (uncheck it)

--- or ---

Close Excel and
Windows Start ButtonRun
excel /unregserver
then
Windows Start ButtonRun
excel /regserver

The /unregserver amp; /regserver stuff resets the windows registry to excel's
factory defaults.

R Ormerod wrote:
gt;
gt; If I have two workbooks open in Excel and try and open a third from Windows
gt; Explorer I return to the session of Excel but the file does not open. If I
gt; close all files the same thing continues to happen.
gt;
gt; The only way to open more files is by using the File =gt; Open command (not as
gt; convenient as Explorer) or starting a new session of Excel.
gt;
gt; I have 'Windows in Taskbar' unchecked in Options because I find it
gt; irritating with multiple files open.
gt;
gt; FYI I have Windows XP Professional SP-2 version 5.1 amp; Excel 2002.
gt;
gt; Any ideas?
gt;
gt; --
gt; R Ormerod

--

Dave Peterson

文章標籤
全站熱搜