sharing file corrupts it

[TeressaJP]

We have an Excel file that 20+ Users update daily. Every time we share the workbook, it corrupts the file within days.

We are using Excel 2010. We go to Review tab, Share Workbook, and check the Allow Changes box.

Suggestions/Feedback is appreciated.

 

[TeressaJP]

We have an Excel file that 20+ Users update daily. Every time we share the workbook, it corrupts the file within days.

We are using Excel 2010. We go to Review tab, Share Workbook, and check the Allow Changes box.

All Users have Excel 2010.

Suggestions/Feedback is appreciated.

We are still having this issue if anyone has any feedback.

 

[auto.pilot]

Something similar happened last month and was related to some users with Windows 7 and others with a different version. In order to fix the problem, it was necessary to un-install security update KB 255073, then rebuild network paths.

Before doing anything, you may wish to search for a hotfix. In our particular case, the problem related to network paths that were 'expanded' within each cell that referenced other workbooks on our network. ie: =companyserver.filename.whatever changed to =companyserver.companyserver.filename.whatever

Start by looking at cell formulas that reference other closed workbooks on your network.

best of luck, it was not fun.

jim