MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Opening Excel Worksheets

Posted by Sharon on November 01, 2001 3:33 PM

I just created an excel template for our school report cards. I have run into two problems. As I entered each student's name, I did a Save As and saved as that student. I end up with about 12 students per floppy disk. Most seem to work fine, but 1 out of 10 times, we get a messages when we try to open a student's card that says, "This file is not accessible. It may be read-only or from a read only location. It may be on a server that cannot be accessed." That is not the case. All were created and saved in identical manner so why one works and another will not is a mystery to me. I have tried opening on a number of different computers, including the original, but that does not make a difference. One teacher had entered grades and could not open it a second time to add further info. She had not changed computers. If I delete the file and create a new one, that works fine. But we need to get back into individual report cards several times and this is a major problem. No, the disks are not write protected. These are disk where all but one or two files will not open. I have tried all the usual trouble shooting. I have used excel spreadsheets for several years and have never had this problem before. As I said, all were created and saved in the same manner. I cannot find any commonality among the ones that will not open. I have 25 teachers with about 24 students each and as you can imagine, this can be quite a problem. Thank you for any help.

Posted by Joe Was on November 02, 2001 4:56 AM

I have had this prob. as well. The problem was corrected when I deactivated the MS disk cache. MS knows it has a problem with this utility and recently built a new version of the utility and put it on its update site. The new version has more problems than the old version!

When you access a file when the cache is updating you will get the problem you outlined. MS Disk check and Defrag will not even work with the new cache! I solved the problem by deactivating the MS Disk Cache.

This is how to do it:
Sys tools
Sys Config utility
uncheck Disk_Cache (it may have a different name)

The system will work slower, but you will have less problems. You will need to re-boot. JSW