I've been having problem at work for around 6 months that I wrote off as user error and now I don't think so. It acts as a virus but virus scans are good. We have .xls files that are created by copy/paste from other files with some manual entry. We ran Excel 97 with all fixes and patches and now run Excel 2003. Problem occurred with both programs. We tried it on another machine not networked running excel XP and same problem. No macros, no links, just BASIC files created from many many other sources to use for mail merge. Saving works fine. But upon closing and reopening, cells have moved within their rows, Some cells are blank when they weren't before. No garbage. One co-worker mentioned that there was, at one time, the macro enable/disable box upon opening but not now and not with all files. When I discovered that, I checked the macro bosx and there weren't any macros. I have tried saving as .txt with tab delimited and then opening back into excel and saving as .xls but problem persists. What to do?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
excel cells moving and losing data upon opening and closing 1
- Thread starter HelenBN
- Start date
-
1
- Thread starter
- #2
Did find the problem: Norton Anti-Virus 2004. (Symantec addressed this problem in Feb. 2005.) It scans Office products upon save (with it's own plug-in) and corrupts the save. Had the choice of just unchecking that plug-in option but I also had networking woes that pointed to Symantec. Had to uninstall All Symantec software. Symantec also has a help with 2 downloadable utilities to clean up the uninstall and hand registry change guidance. Hand deletion of still other folders and files that are left behind. Also ran a Micrsoft downloadable utility to look for yet more leftovers, but there didn't seem to be any. Quite a mess. All excel files were ruined. And a bad taste left in my mouth for Norton products that won't go away. ![[sad]](/data/assets/smilies/sad.gif "[sad] [sad]")
- Status
Similar threads
- Locked
- Question