Excel Spreadsheet Corruption

E

Elias Bell

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top