Error opening Excel file from Internet Explorer

dr_drews

New Member
Joined
Dec 18, 2004
Messages
16
Hi,

I have seen a few similar questions/answers but they seem to be from people who are experiencing the problem themselves and have fixed by writing a Macro and, I assume, saving it in their personal workbook.

I have an Excel file that needs to be viewed by many people around the company, so have put a link on the intranet. Unfortunately, if someone opens the file, closes it and tries to reopen it an error occurs:

...xls is already open. Reopening will cause any changes you made to be discarded. Do you want to reopen ...xls?

I figured that this must be a case of Internet Explorer not closing the Excel file properly. This must be the case as changing your personal windows settings (to open excel files with Excel) seems to fix the problem.

Unfortunately, this isn't good enough as it would mean changing the settings on everyones computer!

Does anyone know of a way to stop this error message from popping up?
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

JeffK627

Active Member
Joined
Jun 22, 2005
Messages
313
If they're opening it in a browser, then I assume they aren't actually supposed to make changes. You could set Application.DisplayAlerts = False, which should suppress the error message - of course, that will suppress all error messages generated by that Excel file, and if the error is coming from IE it won't suppress it at all.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,534
Messages
5,572,743
Members
412,482
Latest member
arooshrana2
Top