Excel saves as [Group]

**mrgeek2u** · 05-30-2007, 12:12 PM

This has happened a few times to us - A spreadsheet saved on a common drive (not shared or protected) suddenly and for no apparent reason saves with the suffix [Group] whereupon no one can use the Autofilters or add anything to any of the cells. I have never heard of this issue in the 10 years I have been using Excel and no one here knows either.
Last time this happened, we had to copy all the cells to a new file, wreaking havoc on the others shortcut keys.
I dont know if this is related but I also have been having a strangish problem, when I open a new Excel window, it says personal.xls is locked for editing by ''. I have been hitting cancel and resuming my work.

**VBA Noob** · 05-30-2007, 01:25 PM

Prehaps all the sheets are selected. See link for info

http://www.bettersolutions.com/excel...I814111912.htm

VBA Noob

**mrgeek2u** · 05-30-2007, 01:49 PM

That is interesting - I have a macro that uses CTRL SHIFT E to execute. I tried to group the sheet a few different ways and CTR SHIFT while another sheet was selected seemed to make this happen (never used it before). Also when individual sheets were selected, the problem righted itself.

I think this solved it - thanks for the help.