Multiple users updating excel spreadsheet

Rated 4.30/5 based on 659 customer reviews

they can reopen the Excel file say every 5 minutes to grasp the latest version.

Karen described a problem in which a shared workbook, stored on a company network, periodically loses all the data it previously contained.

If this is not possible, consider turning on Track Changes in Excel (an option available when you share the workbook) so that a change history is maintained.

This allows you to see who last changed a workbook.

This is a problem if R/W user opens it for a day without save and close. All other read-only users still have no notification of updated version. For user need read only, use VBA of a new workbook to reopen the excel file to get content. use web virtual directory to set to the directory of the excel file.

This is a problem that they still get an old version.

any suggestion to help me I think this amounts to a non-problem.

multiple users updating excel spreadsheet-33

This leads to the first suggestion: don't share the workbook.As a result, the only user who can modify the file is the one who has it open in Read-Write mode -- that user doesn't need to be notified when the file has changed, because that user MADE the changes. This is a problem if R/W user opens it for a day without save and close. All other read-only users still have no notification of updated version. For user need read only, use VBA of a new workbook to reopen the excel file to get content. use web virtual directory to set to the directory of the excel file. As you stated, you have a couple of alternatives: 1.On the other hand, no other user can make changes to the file. This is a problem that they still get an old version. Add VBA code to the workbook to attempt to save and close the workbook every few minutes, so that no one user keeps it open all day, or 2.On the other hand, no other user can make changes to the file. You are correct that, while any user has the file open for editing, the other users can only get a snapshot that reflects the state of the file AT THE BEGINNING OF THE CURRENT EDITING SESSION.the CAN however, get a notice when the file is available to edit (Excel will monitor the file, and when the original user saves AND CLOSES the file, Excel will notify a user who has the file open read-only that the file is now available for editing. That's about the best you can expect in a file-oriented environment like Excel.

Leave a Reply