Excel "file is already open"

[John McFadden]

Whenever I open a '.xls' workbook from outside Excel
(such as from Windows Explorer), Excel indicates that the
file is already open - although, once I click OK, I seem
to be able to work with the file normally. The same file
will open fine from within Excel. I am using Excel 97 on
an XP-Home machine.

Can you explain why I may be getting this message, and
how I might correct for it?

 

[Dave Peterson]

The FAQ at Debra Dalgleish's site might give the solution:

http://www.contextures.com/xlfaqApp.html#AlreadyOpen

 

[Tom Ogilvy]

with excel open, go to tools=>Options=>General and make sure Ignore Other
Applications is not checked.

if that doesn't help with the opening, close excel, go to the windows start
menu and select run (it is in the right column of choices at the bottom on
my version of win -xp)

enter

Excel.Exe /regserver

and click OK.

This will reset Excel's registry settings.


Regards,
Tom Ogilvy

 

[John McFadden]

-----Original Message-----
The FAQ at Debra Dalgleish's site might give the solution:

http://www.contextures.com/xlfaqApp.html#AlreadyOpen



--

Dave Peterson
(e-mail address removed)
.

Thanks, Dave,
The FAQ info worked like a charm.

John

 

[John McFadden]

-----Original Message-----
with excel open, go to tools=>Options=>General and make sure Ignore Other
Applications is not checked.

if that doesn't help with the opening, close excel, go to the windows start
menu and select run (it is in the right column of choices at the bottom on
my version of win -xp)

enter

Excel.Exe /regserver

and click OK.

This will reset Excel's registry settings.


Regards,
Tom Ogilvy





.

Thanks, Tom,

EXCEL /REGSERVER did the trick.

John

 

[Kri' sis]

Hi,

The information from that link from Debra Dalgleish was immediately helpful. I was having the exact same problem as John when using Excel 97 on an XP home computer. Thank you, PCReview, for keeping this post/thread readable to the public for the past 5+ years.

-Kri' sis

 

[dannyb242]

with excel open, go to tools=>Options=>General and make sure Ignore Other
Applications is not checked.

if that doesn't help with the opening, close excel, go to the windows start
menu and select run (it is in the right column of choices at the bottom on
my version of win -xp)

enter

Excel.Exe /regserver

and click OK.

This will reset Excel's registry settings.


Regards,
Tom Ogilvy


John McFadden <[email protected]> wrote in message
news:[email protected]...
> Whenever I open a '.xls' workbook from outside Excel
> (such as from Windows Explorer), Excel indicates that the
> file is already open - although, once I click OK, I seem
> to be able to work with the file normally. The same file
> will open fine from within Excel. I am using Excel 97 on
> an XP-Home machine.
>
> Can you explain why I may be getting this message, and
> how I might correct for it?

resetting Excel registry worked for me, thanks

enter

Excel.Exe /regserver

and click OK.