Active Network Forums New User  |  Login  |  Any forum problems? E-mail us
Back to Forums > "Windows 2000"
Post a Reply
<- Previous Thread  |  Next Thread ->

The time is 10:17:30 PM

Excel 97 on Windows 2000   Post Reply
  User Icon Amigaoasis

Frequent Poster (172 Posts)
Frequent Poster (172 Posts)

3/6/2003 8:05:10 AM


Hi,

Recently we upgraded a number of workstations to Windows 2000 sp3 but as we are quite happy with office 97 chose not to upgrade this.

However on 1 or 2 workstations we have had undesired results in particular with Excel 97 (although im sure Word is also effected cant confirm at the moment)

All of our users have their own shared workspace on the Servers (nt4 sp6a) which only they have full access to but they also report the problem with files stored on the local drive as well.

Basically they get messages reporting the file is open or in use when its most definatley not, in some cases the system reports the same user as having the file open.

They definatley dont have the file still open as I have tested on a system after rebooting. They get either

Document with the name ‘blah 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.

or

The file is being modified by user "username"

Does anyone have any ideas as to what might be causing these problems?

----------------------------------------------
AmigaOasis
Jolt TFC Head Admin http://www.tfc.jolt.co.uk
195.149.21.33:27015 Badlands 24/7
195.149.21.33:27025 2fort 24/7
195.149.21.33:27035 2fort 24/7
195.149.21.33:27045 Well 24/7
195.149.21.33:27105 All Maps Voting On
195.149.21.42:27065 56k Classic Maps
Post Reply
  User Icon kdailey

Newbie (1 Posts)
Newbie (1 Posts)

9/24/2004 12:28:04 PM


I had this same problem. After much searching on the internet, I found little information. I do not recall where I saw the info but read something about reinstalling office 97 after installing windows 2000 sp3.
I inserted the office 97 cd
Ran setup
Clicked on "reinstall office 97"
Setup reinstalled without many questions.

Problem solved.
Post Reply
  User Icon RAClifton

Newbie (1 Posts)
Newbie (1 Posts)

1/16/2005 6:46:05 AM


    QUOTE:
    Originally Posted by kdailey:
    I had this same problem. After much searching on the internet, I found little information. I do not recall where I saw the info but read something about reinstalling office 97 after installing windows 2000 sp3.
    I inserted the office 97 cd
    Ran setup
    Clicked on "reinstall office 97"
    Setup reinstalled without many questions.

    Problem solved.

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 fromhttp://www.officekb.com/Uwe/Forum.aspx/excel/8692/Error-message-when-Excel-97-file-is-opened

Regards

Richard A Clifton
Kestrel Programming Ltd
Post Reply
  User Icon fegan

Newbie (1 Posts)
Newbie (1 Posts)

11/22/2005 4:48:08 PM


I had the same problem under a clean install of Windows 2000 Pro, followed by SP4 and various security updates. When I installed Office 97 I would get the same 'file is already open' messages. The solution I found was a registry fix...


For Excel, navigate to the
"My Computer\HKEY_CL@ssES_ROOT\Excel.Sheet.8\shell\Open\command" key.

The default entry should end with ...\excel.exe %1" and the fix is to remove the %1


For Word, navigate to the
"My Computer\HKEY_CL@ssES_ROOT\Word.Document.8\shell\Open\command" key.

The solution is nearly identical to that for Excel. On our machine the entry ended with ...\winword.exe" /n and I removed the /n to fix the problem.

----------------------------------------------
Forrest Egan
www.DigitalAstro.com
Post Reply

Copyright © 1997-2010 Active Network, Inc. All Rights Reserved. Terms of Use. Privacy Policy.
roofing contractors, flat roofing companies, rubber roofing, fascias and soffits, roofing specialists, roofing kent, database software, personal training, promotional gifts, advertise on google, Whiplash Compensation, wooden gates,
Accidents at Work, epc courses,