Interview Question in Sharepoint Documents
Question :: Excel workbook becoming unshared when edited by others |
| I'm currently trying to manage a large spreadsheet that gets sent out to a team of people every day by a uploading/downloading via a Sharepoint site. Each person modifies a different section of the document, then uploads their copies. Since the document started out as one Shared Workbook, and I turned "protect shared workbook" on, I can merge most of the users' workbooks back into one. For some reason, two users always return their spreadsheets with Sharing and Track Changes turned off (in spite of it being 'protected'). They swear they aren't messing with the spreadsheet except to add data to their assigned cells, and they've tried emailing the files back instead of using the Sharepoint. Could their computer or version of Excel somehow be disabling Shared Workbooks? I'm using Excel 2003, but if they had an old version, could this be deleting the change history/unsharing the workbook when they open the file? Thanks in advance! |
|
|
|
Loading ...