We're loosing a Shared Excel Spreadsheet every 5 days

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have shared an excel spreadsheet with multiple workbooks. It is in a file
on a share server. We have upwards of ten users in the spreadsheet at any
time updating information. The symptoms is that one user will get the
following message: 'Your changes could not be saved to 'Renewal Tracking
Chart.xls', but were saved to a temporary document named 18D7A350. Close the
existing document, then open the temporary document and save it under a new
name.' When we select OK, we're thrown out of the shared spreadsheet and any
other user then notices that the [Shared] designation is removed from their
screen and they get a message that the document cannot be saved and are
thrown out of it too. When we try to reneame the temp doc, we can't. We're
loosing our changes on a regular basis. IT is restoring the previous backed
up copy but cannot shed any light on why this is happening
 
Hi Excel Carol,

You need to move to an Excel frontend with a shared database backend (or
rewrite as a database application).

Excel sharing is not really designed to handle ten simultaneous users.

regards
Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com
 
Back
Top