We are a weekly newspaper. We use Excel for subsription and advertising info. My subscription editor is not trained in Excel and so she started copying and pasting info on her spreadsheet that evidently sent Excel in a tizzy. Basically, Excel is changing subscription dates from their original date (which differs every seven days, because of weekly publication) to list numerically, and does this beginning at random rows until the list runs out of dates.
So, for example: our spreadsheets list customer names, addresses, phones numbers, when their subscription ends, postal codes, etc. scrolling down, clumps will list 8/12/09 ...... 9/2/09 ...... 9/23/09 ...... then starting at 10/6/09, the dates will follow right after one another with 10/7/09, 10/8/09, 10/9/09, 10/10/09, 10/11/09, etc. Now, what's happening, is this is messing up when subscriptions end because it's completely changing the date so they list numerically, no matter what the date originally said.My circulation manager went in a few weeks ago, went back through ALL customer subscription files and changes the dates again. Saved the file and reopened it right back and everything was changed again. We could not find a previous file, and we checked the time from when the file was saved and it clearly stated a few seconds before opening the file back up.
Last week, during distribution, she got on her computer only to find the files she was working on gone. Off the computer. my editor looked in the trash, in the "open recent" selection in Excel, the editor searched it, looked in the documents folder — everything. The file did not crash, so there was no system restore to look into. Used/cleaned disk utility and that didn't help.
We have an external server, but evidently she just worked off her desktop. She did have a flash drive inserted, however I don't have access to that right now.