A workbook I have created for coordinating work efforts has begun crashing on me. The workbook is stored on a network. Everyone is the local area can make changes and save properly. There are two people who make changes offsite. When they save their changes the file becomes unstable. Each time you try to open after they have made their changes Excel crashes. This at one time was a shared workbook, but due to this error I removed the sharing aspect.
The only thing I've noticed is that after they save the file says [Group] in the header. I have found that this means multiple sheets have been selected. The only thing I can possibly guess at is that I have a hidden worksheet which somehow they are selecting when they save. Though I have written a macro to select the one worksheet we should all be modifying.
Anyway if anyone has any details on how the [Group] would appear in the titlebar of the file and why that would get Excel to crash I would appreciate it. So far I am painstaking able to recover my data, but only by opening the file through Word and then copying over to Excel. Very manual.
The only thing I've noticed is that after they save the file says [Group] in the header. I have found that this means multiple sheets have been selected. The only thing I can possibly guess at is that I have a hidden worksheet which somehow they are selecting when they save. Though I have written a macro to select the one worksheet we should all be modifying.
Anyway if anyone has any details on how the [Group] would appear in the titlebar of the file and why that would get Excel to crash I would appreciate it. So far I am painstaking able to recover my data, but only by opening the file through Word and then copying over to Excel. Very manual.
