MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Files get corrupted very often!


Posted by Santosh Malve on March 19, 2001 11:09 PM

i'm experiencing lot of problems with ms-excel 2000
1. excel files gets corrupted very often.
2. while opening a file message " Unable to read ..." is displayed.
3. sometimes it shows "file cannot be accessed, the file may be read only. or you may be trying to access it from a read only location.or the server the document is stored may not be responding . ( this message appears when trying to access file stored on a novell server 4.11. i've tried reinstalling client32 but didn't helped)

please guide me regd this.

thank you

Santosh Malve


Posted by Dave Hawley on March 19, 2001 11:44 PM


Hi Santosh

Office 2000 now has a "Detect and Repair" option on their CD. Insert and run the Office 2000 CD and you will see this option.

You could also have a read of these MS articles to see if any apply:

http://search.support.microsoft.com/kb/psssearch.asp?SPR=xlw2K&T=B&KT=ALL&T1=7d&LQ=file+cannot+be+accessed&PQ=PastQuery&S=F&A=T&DU=C&FR=0&D=xlvba2k%2Bor%2Bxlgeneralkb%2Bor%2Bxl2000kb%2Bor%2BVBA2000%2Bor%2BOffDev%2Bor%2Bof20&LPR=%22excel+2000%22&LNG=ENG&VR=http%3A%2F%2Fsupport.microsoft.com%2Fsupport%3Bhttp%3A%2F%2Fsupport.microsoft.com%2Fservicedesks%2Fwebcasts%3Bhttp%3A%2F%2Fsupport.microsoft.com%2Fhighlights&CAT=Support&VRL=ENG&SA=GN&Go.x=25&Go.y=23


Last but not least, with Excel closed, go to Start>Run and type in:
Excel /regedit
Then click OK. Notice the space after the switch. This will force Excel to re-register itself.

For a full list of switches go here:

http://support.microsoft.com/support/kb/articles/Q211/4/81.ASP?LN=EN-US&SD=gn&FR=0&qry=startup%20switches&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=XLW2K


Good luck
Dave


OzGrid Business Applications