Link to home
Start Free TrialLog in
Avatar of syssolut
syssolutFlag for United States of America

asked on

Certain Excel spreadsheets will randomly drop lines

I have a office that has a server with 6 computers accessing the files off the server.  They are having an issue with rows that are being dropped at random off two of their many Excel spreadsheets.   The spreadsheets are in the Public folder so all users can access.  The two particular excel spreadsheets were at one point Shared, but then they removed sharing so only one person can make changes at that particular time.   But before these two spreadsheets were shared, this random loss of lines would happen.

Example:  One person would be doing billing from one  of the spreadsheets in question and one of the other people wondered how come a certain customer was not billed.  The first person would look at the spreadsheet and the customer that was listed for many months, the whole row containing their information was gone.  They would have to go back to one of the backups and retrieve all the information in that row for that customer.   No one is getting in and deleting these rows, they are just every once in a while disappearing.  

Any ideas?  They are using Excel 2010
ASKER CERTIFIED SOLUTION
Avatar of Adiel de Freitas
Adiel de Freitas
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of syssolut

ASKER

There were no hidden columns, time was same on all computers.   I did have them create a new file and copy all columns and rows from old and paste into new file.   Waiting for results.
They created a new file 3-4 weeks ago and copied the data from the old file to the new file.   Since using the new file database, they have not had one instance of this issue.   Thanks for the suggestion, it has seemed to solve this issue.