redemption in a blog

Heh, wierd. I just noticed that the problem is non-existent on MS Word though. By the way, this comment edit box gives a js error everytime you type a character into it in IE 6 *ducks for cover*

Posted by: senkwe on February 23, 2004 4pm

Thanks for pointing that out (the comments textarea JavaScript error). I’d forgotten to remove some old code I was trying out for an automatic comment preview box. Didn’t quite work out and thought it wasn’t worth the trouble anyway. Or maybe just a combination of sour grapes and a hurt ego.

Fixed it.

Posted by: Cheah Chu Yeow on February 23, 2004 5pm

I have noticed this as well and I think it may have to do with Excel trying to keep track of all of the ’sheets’ that you are using at that time and keeping them from being overwritten. As far as I can tell it takes the name of the file and only uses it as a reference (for where to save, etc.) while using the actual file name only for the editing. That is the only thing that makes sense to me… It is an annoying and stupid problem though.

Posted by: Stephan Segraves on February 23, 2004 11pm

I wonder if Open Office has the same problem? I’m doing my best to de-Microsoft my life these days, and you’ve just given me another reason to do so.

Posted by: Elderbear on February 26, 2004 3pm

well, all softwares have their own problems. without microsoft office, open office won’t have improved as much till today… in term of usability and interface

everyone is learning from everyone.

maybe that’s one of the problem they shd have fixed it, but maybe there are really some reason for that.

yah… hurt ego, that might be a reason for ppl who held themselves highly, Bill Gates & co.?

Posted by: fruittree on March 20, 2004 3pm

I have received the same error but i have only one file open! Recently upgraded the OS from t 4 to 2000 pro. Any sugestions on fixing this?

Posted by: Michael on April 1, 2004 5am

Michael: That’s strange. I really have no idea. Perhaps you could re-install MS Office?

Posted by: Cheah Chu Yeow on April 2, 2004 9pm

You can’t open files with the same name in Excel. You have to change the name of one of them. If you get the error that 2 files are open and you only have one file open, your macro’s are pointing to the file that has the macro’s you want to use. Fix that by updating the macro’s on your current file and remove the referrence to the original or other file. Example your macro says “U:\time!macro1″ delete “U:\time!” and your macro will work fine.

Posted by: Jesse on April 4, 2004 3am

I fixed it as follows.

1) First, I made sure nothing was corrupted in Office by reinstalling it from the CD (although, the re-install said that it could not install something related to html. This did not affect me, though)

2) I noticed that I only had this problem with one worksheet, in particular, that had many worksheets within it (ie. I did not get this error message if I created a new worksheet, and then tried to open it).

3) So, I created a new worksheet, and migrated worksheets from my original, one by one, to the new worksheet (saving, opening, and closing both worksheets after I made a change), until I found a worksheet that caused the problem (ie. I could now open my original without the error, after I moved one of the worksheets out, and the othe worksheet had the error).

4) So, now the problem worksheet was in a different, separate worksheet.

5) I created a blank worksheet within my original.

6) I transferred the data back (copy and pasted) from the one causing the problem, to the original.

7) I think that is what fixed it, but I also noticed that under Insert / Name / Define, many of my Go To macros pointed to outdated range definitions, and referenced other worksheets, so I also deleted all of those also. The probably wouldn’t have been a cause of the problem, though, as they only do something when you click on them. I deleted them anyway, though, because they were sloppy and inaccurate.

8) Conclusion: When you go to Tools / Macros / Macros - I find that the problem worksheet does not have any macros in it. I think the problem has to do with the part of the error message that says a problem could result from the use of templates - which means copying and pasting a worksheet, on which to do updates, which I did.

Posted by: Bill Gates on December 11, 2004 2am

This solution worked for me:

>>>>
Try the usual fix(es) for this problem.

Tools>Options>General uncheck “Ignore other Applications”
Exit Excel and try again

If this doesn’t work try to re-register Excel

Close Excel first and
On the Windows Taskbar

1) Start>Run “excel.exe /unregserver”(no quotes)>OK.
2) Start>Run “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 Start>Run “C:\yourpath\excel.exe /regserver”(no quotes)>OK.

Gord Dibben Excel MVP
< <<<<

Extract from http://www.officekb.com/Uwe/Forum.aspx/excel/8692/Error-message-when-Excel-97-file-is-opened

Repair the file association for Microsoft Excel files.

Click Start, Run, and enter excel /regserver
Insert the Microsoft Office installation media if prompted to do so.
Applies to
Microsoft Office (any version)

Posted by: Barry on May 23, 2006 3am

Good call Richard that worked for me, did the Click Start, Run, and enter excel /regserver, I open an excel file reassociated it and no more errors.

Thanx,
Dave

Posted by: Dave on May 26, 2006 12am

Not only error for excel but also present everywhere, to impossible to open the same name document at the same time. If you are trying to open then you are doing confused to pc. Because if you give wrong input then it will give wrong output.

Thank you

Damon Thomas

Posted by: Corrupt Excel Repair on August 17, 2007 1pm

You can not open two the same name excels files even if both files are different folder where as two word files can open at the same time. I think this may be the condition of the coding of excel program.

Thank you
Damon Thomas

Posted by: Excel Fix on September 8, 2007 3pm

Love Excel, but never knew such a simple thing does not have a workaround yet.

However, I see how references across two different files can create problems for Excel if the filenames are the same. Requiring unique names surely is a fix, but not a good fix.

Posted by: MS Excel Trainee on September 14, 2007 7am