Filename.xls [Group]
 

I have opened a file that is on a remote server and it shows [Group] next to
the file name when opened. I'm actually trying to unprotect a sheet in the
workbook and it won't unprotect. Can someone explain what the [Group]
designation means and what I can and can not do with a file that I only have
read access to.

Thanks in advance,
Barb Reinhardt

Filename.xls [Group]
 

Hi

The 'Group' means that two or more sheets have been grouped and any changes
you make to one will be made to the other/s.
To ungroup, right click on a sheet tab and left click on Ungroup Sheets.
If the worksheet has been protected, yo may not get this option, however.
You'll need to get the password.

Andy.

"Barb Reinhardt" wrote in message
...
I have opened a file that is on a remote server and it shows [Group] next
to
the file name when opened. I'm actually trying to unprotect a sheet in
the
workbook and it won't unprotect. Can someone explain what the [Group]
designation means and what I can and can not do with a file that I only
have
read access to.

Thanks in advance,
Barb Reinhardt

Filename.xls [Group]
 

[Group] means 1 worksheet are selected at the same time. Right-click a sheet
tab and select Ungroup sheets
Bob Umlas
Excel MVP

"Barb Reinhardt" wrote:

I have opened a file that is on a remote server and it shows [Group] next to
the file name when opened. I'm actually trying to unprotect a sheet in the
workbook and it won't unprotect. Can someone explain what the [Group]
designation means and what I can and can not do with a file that I only have
read access to.

Thanks in advance,
Barb Reinhardt