Go Back  DVD Talk Forum > General Discussions > Tech Talk
Reload this Page >

error message between win2k and excel 97

Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

error message between win2k and excel 97

Old 10-05-01, 02:05 PM
  #1  
DVD Talk God
Thread Starter
 
twikoff's Avatar
 
Join Date: Feb 2000
Location: Right Behind You!!!
Posts: 79,497
Likes: 0
Received 0 Likes on 0 Posts
error message between win2k and excel 97

ok.. Im looking around in microsofts knowledge base, and havent seen any good info on this yet.. so I thought I would post in here and see if any of the other support people had run into this issue before


on a win2k machine.. when a user tries to open an excel file (office 97) (off the network or from the local drive.. and without excel already being open).. the user gets an error saying the file is already open (by that user) and they click ok and can go in with read only access..
the odd thing, is once excel is open, they can open any file, without the message.. if they open excel first, then open the file, it comes up fine.. but anytime they user opens excel by clicking a file (doesnt matter which excel file they try).. it always gives that message..

at first, I was going to blow it off and figure that user had done something to cause it, and figure they would just have to click ok and work around it... but now I have another user getting the exact same problem, and her system was setup just a week ago, so its not likely that she already did something to cause the problem.

anyone ever seen this before?
Old 10-05-01, 02:12 PM
  #2  
DVD Talk God
Thread Starter
 
twikoff's Avatar
 
Join Date: Feb 2000
Location: Right Behind You!!!
Posts: 79,497
Likes: 0
Received 0 Likes on 0 Posts
ok.. here is the exact message:


A document with the name 'blahblahblah.xls' is already open. You cannot open two documents with the same name, even if the documents are in different folders.
To open the second document, either close the document thats currently open, or rename one of the documents.
but this is on a system that was just booted up and didnt already have any files open.. something to do with the caching system?
Old 10-05-01, 04:53 PM
  #3  
X
Administrator
 
X's Avatar
 
Join Date: Oct 1987
Location: AA-
Posts: 10,763
Likes: 0
Received 4 Likes on 3 Posts
I seem to recall seeing the same thing. Never bothered to fix it though, probably told them to upgrade or something.

Of course you've done the SR-2 on Office, right?
Old 10-05-01, 06:53 PM
  #4  
DVD Talk Legend
 
Join Date: Jan 2000
Posts: 16,173
Likes: 0
Received 0 Likes on 0 Posts
Originally posted by X
I seem to recall seeing the same thing.
so have I, but hmmmmm how to fix it is another question.


I know I solved it at one point, but honestly can not remember.
Old 10-06-01, 02:48 AM
  #5  
DVD Talk God
Thread Starter
 
twikoff's Avatar
 
Join Date: Feb 2000
Location: Right Behind You!!!
Posts: 79,497
Likes: 0
Received 0 Likes on 0 Posts
i only halfassed looked for the answer to this earlier, because Ive been really really busy taking care of all the computers from the big layoffs a few weeks back..

but yes.. they already had service pack 2.. so I went to 2b.. still the same thing

Im thinking it has to have something to do with win2k permissions.. but it doesnt make alot of sense, because I set the users up as admins on the machines.. (spell check wont work in office unless you are either an admin, or make some registry tweaks)
Old 10-06-01, 02:30 PM
  #6  
X
Administrator
 
X's Avatar
 
Join Date: Oct 1987
Location: AA-
Posts: 10,763
Likes: 0
Received 4 Likes on 3 Posts
Found this in MSDN. I don't know if this is exactly it, the OS versions are way old.

XL97: Error Opening File from Address Bar in Microsoft Internet Explorer
ID: Q184159
--------------------------------------------------------------------------------
The information in this article applies to:
Microsoft Excel 97 for Windows
Microsoft Internet Explorer versions 3.0, 4.0 for Windows 3.1
Microsoft Internet Explorer versions 3.0, 4.0 for Windows 95
--------------------------------------------------------------------------------
SYMPTOMS
In Microsoft Internet Explorer 4.0, when you click the Address bar arrow and select a Microsoft Excel 97 workbook, you may receive the following error message:

A document with the name '<file name.xls>' is already open. You cannot open two documents with the same name, even if the documents are in different folders. To open the second document, either close the document that's currently open, or rename one of the documents.
When you click OK, you receive the following error message:
Internet Explorer cannot open the Internet site <file name.xls>.
Server execution failed
In Microsoft Internet Explorer 3.0, when you click the Address bar arrow and select a Microsoft Excel workbook, you may receive the following error message:
Reference Is Not Valid.

CAUSE
This problem occurs if all of the following conditions are true:

You open an Excel workbook that contains hyperlinks in Internet Explorer.

-and-

You click a hyperlink in the Excel workbook that jumps to a named location in the same workbook.

-and-

After you follow the hyperlink to a named location in the workbook, you click the same workbook name in the Address bar list.

NOTE: The error message may also occur when you open an Excel workbook in Internet Explorer and then attempt to open the same workbook again by selecting the same workbook name from the Address bar list.

STATUS
This behavior is by design of Microsoft Excel 97 for Windows.

MORE INFORMATION
In Excel, you can use a hyperlink to jump to an object, file, page, or other destination, such as a named location or a specific cell range. When you follow a hyperlink to a named location or to a specific cell range in the same workbook, Excel performs a Goto command and selects the location in the same workbook. If the workbook is open in Internet Explorer, and if you follow the hyperlink, there is no way to go back to the previous location in the same workbook. When you click the back button in Internet Explorer, you go to the previous Uniform Resource Locator (URL). If you select the workbook in the Address bar list, Internet Explorer attempts to open another copy of the same workbook and produces the error message in this article. The Excel Web toolbar allows you to go to the previous location in the same workbook, but the Web toolbar cannot be displayed inside of Internet Explorer.

Additional query words: XL97

Keywords : kberrmsg kbdta
Version : WINDOWS:3.0,4.0
Platform : WINDOWS
Issue type : kbprb
Old 10-06-01, 03:59 PM
  #7  
DVD Talk God
Thread Starter
 
twikoff's Avatar
 
Join Date: Feb 2000
Location: Right Behind You!!!
Posts: 79,497
Likes: 0
Received 0 Likes on 0 Posts
yea... that was the only article i could find in the ms knowledge base also.. but it didnt apply to this situation

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Thread Tools
Search this Thread

Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service - Do Not Sell My Personal Information

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.