dddeardorff
New Member
- Joined
- Apr 1, 2002
- Messages
- 4
I have had this problem for a couple of years now and can't find anything at Microsoft site to help.
I have an excel file that I store in a network folder that is read-only to everyone but me (and a few administrators). So when the users access the directory and open the file, it comes up as read-only and they save it to another filename in another directory.
Randomly, they will open the file and it will be corrupted. It is a password protected workbook with password protected worksheets (and a password protected VBA project). Entire rows will be moved and offset to the right by 5 or 6 cells. It usually occurs at the same row but not always. Have not been able to establish a pattern. Have saved quite a few examples. It used to only happen on one sheet in the workbook but now I am seeing it more frequently on other sheets. Occasionally they will receive a message that says 'error data may be lost' and then the next time they open, they get the corruption.
We are using Excel 97 sr2 on WinNT machines. The files used to contain links to other workbooks but I removed in hopes that the links were causing the ref errors. But I am still getting them even after removing the links. (I created a macro to couple and paste special the values from the other workbook.)
So I know I rambled but I was just throwing out any info that I thought might help in resolving this problem. Is it an Excel problem? A Windows NT problem?
Anything would be greatly appreciated. Thank you!
I have an excel file that I store in a network folder that is read-only to everyone but me (and a few administrators). So when the users access the directory and open the file, it comes up as read-only and they save it to another filename in another directory.
Randomly, they will open the file and it will be corrupted. It is a password protected workbook with password protected worksheets (and a password protected VBA project). Entire rows will be moved and offset to the right by 5 or 6 cells. It usually occurs at the same row but not always. Have not been able to establish a pattern. Have saved quite a few examples. It used to only happen on one sheet in the workbook but now I am seeing it more frequently on other sheets. Occasionally they will receive a message that says 'error data may be lost' and then the next time they open, they get the corruption.
We are using Excel 97 sr2 on WinNT machines. The files used to contain links to other workbooks but I removed in hopes that the links were causing the ref errors. But I am still getting them even after removing the links. (I created a macro to couple and paste special the values from the other workbook.)
So I know I rambled but I was just throwing out any info that I thought might help in resolving this problem. Is it an Excel problem? A Windows NT problem?
Anything would be greatly appreciated. Thank you!