Excel Spreadsheet Corruption
We have a macro driven workbook that is stored on a
network share drive and the attributes of this workbook are read-only. When the user opens the workbook we have several macros that force the user to save (save as) the workbook to a client directory based on a file name that they provide. Functionally, everything works perfectly BUT every two or three days we experience corruption of the read-only workbook (not the local copy). I've read several articles on the net that state that the potention for corruption is greater for workbooks stored on a share with multiple users accessing at the same time. I understand that the potential for corruption might be high if the client systems where hanging during the access of the workbook BUT we have a controlled number of people testing this application and they tell us that everything is working perfectly. Does anyone know why we would be experiencing corruption? Virus Protection Software? Backup Software? Any responses would be greatly appreciated! |
All times are GMT +1. The time now is 11:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com