Discussion Locked

Microsoft Word or Excel 2000

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am aa administrator of a document server where all the users store MS Word, Excel , Powerpoint and other files in this server for sharing purpose.The problem begins when some of the users try and open some of the files either saved by the same user or different users. before the file can be open, a pop-up message will appear as follows:

"Microsoft Word or Excel
This file is not in a recognizable format
...."

After you click "OK", the word file can be open but all the wordings appear as square boxes. In the case of Excel, the file is open but all the cells become "Blank"

My concern is whether the files are attacked by viruses? Where do the virus reside? Server or individual local PC? At the moment, the server and all the PCs are protected by "Trend-Micro" antivirus (Online update".

Hope to get assistance and views from IT experts, please.

Thanks

5 replies

by rewrite

This problem can occur if a user opens an xls file in word (which can open spreadsheets and display the data in a table) and then saved the file with the xls extension again. The data will not be readable by either program. You can try to read the file by opening word and choosing recover text from any file, saving it as a text file and then importing the text back into excel.

Another problem may be using different versions of the office applications back and forth on the same files.

Post back with more info.

Cheers.

RW

by kiamkhai

Dear Sir

Thanks for your quick response. To answer your query whether the users open Excel file in Word and versa, I can assure you that all the word files are open using MS Word 2000 and similar for the case of Excel 2000. For your information, my organisation is using the same version of MS Office product as well as the operating system.

2. We have about 150 staff sharing the same server and at the moment about 20 staff are facing this problem. The problem started with one person and in about 10 days, nearly 20 persons are affected by this problem.

Thanks

Regards
Tee Kiam Khai

by rewrite

Having everyone on the same version makes things easier. Has the latest service pack (I believe it's sp3 for office 2k) been installed on all pc's? As to viruses, they could reside either on the server or user pc's. Each system should have an updated anti-virus app (are all the pc's using the same anti-virus program) which should catch any virus related issue when opening files. Here's a link for Office 2000 updates:

http://office.microsoft.com/en-us/officeupdate/CD010225771033.aspx

A couple of questions:

-For a user that is having this problem does it occur for every document/spreadsheet they open or only certain ones?

-are there any similarities for the users having this problem such as pc brand, os, network rights, installed applications versus users who do not have this problem?

-does document corruption occur when it is only accessed by the same user or when a user opens a document/spreadsheet created by a different user.

We've got some investigating to do.

Cheers.

RW

by kiamkhai

Dear Sir

Thanks so much and wishing you "Merry Christmas and a Happy New Year"

Yes all the user's PCs are installed with the latest SP3. We are using the same anti-virus for the user's PC/laptop and servers, i.e. Trend- Micro. Below are the answers pertaining to your queires:

1. Not all the documents or spreadsheets. It happens to certain documents or spreadsheets but at different times. It can happen to both the new and old documents. What I mean here is the documents can be the old documents and save in the server two weeks ago. That documents have been updated many times but when the same user try and open it again (last week), then she encounter this problem. It can happens to the same document which is created on the same day.

2. The user can be using the same or different PC or laptop's brand. Most of the them are having the same network or access right to that folder.It's difficult to say when the next user is going to have this problem.

3. The document that is corrupted can belongs to the same user who is the creater and editor or it can be open by another user from the same section ( sharing purpose).

For your information, we have called in the vendor and scan the server last Friday and no virus has been found. We will continue checking the affected users's PC/laptops.

Thanks

Regards
Tee Kiam Khai

by rewrite

OK. Since you have ruled out viruses the next major cause of document corruption is bad media or network connections. Perform a disk check of the drive(s) holding the shared documents directory. You will also want to verify that there is not a user with a failing network card, cable or connection. Can you tell from the users who are having this problem if there is a common denominator like all being on the same switch/router/network segment? Start with the common denominator and work your way out. If you are keeping logs of file access you might want to check them for user access prior to file corruption.

Cheers.

RW

This discussion is closed to new replies.