Unable to Insert Worksheets or Change Tab Names
 

I worked on a workbook yesterday and added a sheet to it. One of my
colleagues came in today she said one of her workbooks would not allow her to
modify the tab names of the worksheet or allow her to add a worksheet. I
opened up the file from the server and checked permissions, etc and saw that
these functions she mentioned were greyed out. I could not get them to work
but when I opened a different workbook of hers in another folder it worked as
normal.

Now the strange thing is, I just opened the workbook stored in my folder (on
the server) and now I can't modify tab names or add a worksheet!!! It's as if
my worksheet got infected. I am afraid to open any other workbooks. Any
suggestions. I can edit cells and same those edits, I just can't modify the
tab name or insert sheets or delete sheets. And how did this get transfered
to my workbook. I have discovered that several more workbooks in her folder
(on our server) are behaving the same.

Unable to Insert Worksheets or Change Tab Names
 

Sounds to me like the workbook is protected. In XL select Tools - Protection
- Unprotect Workbook. You may need a password if one has been added. If no
one knows the password reply back as we can help you to crack it...
--
HTH...

Jim Thomlinson


"koper" wrote:

I worked on a workbook yesterday and added a sheet to it. One of my
colleagues came in today she said one of her workbooks would not allow her to
modify the tab names of the worksheet or allow her to add a worksheet. I
opened up the file from the server and checked permissions, etc and saw that
these functions she mentioned were greyed out. I could not get them to work
but when I opened a different workbook of hers in another folder it worked as
normal.

Now the strange thing is, I just opened the workbook stored in my folder (on
the server) and now I can't modify tab names or add a worksheet!!! It's as if
my worksheet got infected. I am afraid to open any other workbooks. Any
suggestions. I can edit cells and same those edits, I just can't modify the
tab name or insert sheets or delete sheets. And how did this get transfered
to my workbook. I have discovered that several more workbooks in her folder
(on our server) are behaving the same.

Sounds to me like the workbook is protected.
 

Hi,

When i click Unprotect Workbook its asking for password and but i don't have password. Please help me?

Regards
Bhanu

On Thursday, August 14, 2008 1:01 PM kope wrote:

I worked on a workbook yesterday and added a sheet to it. One of my
colleagues came in today she said one of her workbooks would not allow her to
modify the tab names of the worksheet or allow her to add a worksheet. I
opened up the file from the server and checked permissions, etc and saw that
these functions she mentioned were greyed out. I could not get them to work
but when I opened a different workbook of hers in another folder it worked as
normal.

Now the strange thing is, I just opened the workbook stored in my folder (on
the server) and now I can't modify tab names or add a worksheet!!! It's as if
my worksheet got infected. I am afraid to open any other workbooks. Any
suggestions. I can edit cells and same those edits, I just can't modify the
tab name or insert sheets or delete sheets. And how did this get transfered
to my workbook. I have discovered that several more workbooks in her folder
(on our server) are behaving the same.


On Thursday, August 14, 2008 1:18 PM James_Thomlinso wrote:

Sounds to me like the workbook is protected. In XL select Tools - Protection
- Unprotect Workbook. You may need a password if one has been added. If no
one knows the password reply back as we can help you to crack it...
--
HTH...

Jim Thomlinson


"koper" wrote:


Submitted via EggHeadCafe
SQL Server Table Valued Parameters / Types - Multiple Row Inserts
http://www.eggheadcafe.com/tutorials...w-inserts.aspx

Sounds to me like the workbook is protected.
 

http://www.mcgimpsey.com/excel/removepwords.html


Gord Dibben MS Excel MVP


On Wed, 02 Mar 2011 07:10:14 GMT, bhanu praveen wrote:

Hi,

When i click Unprotect Workbook its asking for password and but i don't have password. Please help me?

Regards
Bhanu

On Thursday, August 14, 2008 1:01 PM kope wrote:

I worked on a workbook yesterday and added a sheet to it. One of my
colleagues came in today she said one of her workbooks would not allow her to
modify the tab names of the worksheet or allow her to add a worksheet. I
opened up the file from the server and checked permissions, etc and saw that
these functions she mentioned were greyed out. I could not get them to work
but when I opened a different workbook of hers in another folder it worked as
normal.

Now the strange thing is, I just opened the workbook stored in my folder (on
the server) and now I can't modify tab names or add a worksheet!!! It's as if
my worksheet got infected. I am afraid to open any other workbooks. Any
suggestions. I can edit cells and same those edits, I just can't modify the
tab name or insert sheets or delete sheets. And how did this get transfered
to my workbook. I have discovered that several more workbooks in her folder
(on our server) are behaving the same.


On Thursday, August 14, 2008 1:18 PM James_Thomlinso wrote:

Sounds to me like the workbook is protected. In XL select Tools - Protection
- Unprotect Workbook. You may need a password if one has been added. If no
one knows the password reply back as we can help you to crack it...
--
HTH...

Jim Thomlinson


"koper" wrote:


Submitted via EggHeadCafe
SQL Server Table Valued Parameters / Types - Multiple Row Inserts
http://www.eggheadcafe.com/tutorials...w-inserts.aspx

Unable to Insert Worksheets or Change Tab Names
 

I am in the same situation in Excel 2010, how can I cure problem?

On Thursday, August 14, 2008 1:01 PM kope wrote:

I worked on a workbook yesterday and added a sheet to it. One of my
colleagues came in today she said one of her workbooks would not allow her to
modify the tab names of the worksheet or allow her to add a worksheet. I
opened up the file from the server and checked permissions, etc and saw that
these functions she mentioned were greyed out. I could not get them to work
but when I opened a different workbook of hers in another folder it worked as
normal.

Now the strange thing is, I just opened the workbook stored in my folder (on
the server) and now I can't modify tab names or add a worksheet!!! It's as if
my worksheet got infected. I am afraid to open any other workbooks. Any
suggestions. I can edit cells and same those edits, I just can't modify the
tab name or insert sheets or delete sheets. And how did this get transfered
to my workbook. I have discovered that several more workbooks in her folder
(on our server) are behaving the same.


On Thursday, August 14, 2008 1:18 PM James_Thomlinso wrote:

Sounds to me like the workbook is protected. In XL select Tools - Protection
- Unprotect Workbook. You may need a password if one has been added. If no
one knows the password reply back as we can help you to crack it...
--
HTH...

Jim Thomlinson


"koper" wrote:


On Wednesday, March 02, 2011 2:10 AM bhanu praveen wrote:

Hi,



When i click Unprotect Workbook its asking for password and but i don't have password. Please help me?



Regards

Bhanu

Unable to Insert Worksheets or Change Tab Names
 

Which problem?

You don't know if the workbook is protected? It is but you can't
remember the password?


Gord Dibben Microsoft Excel MVP


On Sun, 21 Aug 2011 04:27:52 GMT, Earl Pagel
wrote:

I am in the same situation in Excel 2010, how can I cure problem?

On Thursday, August 14, 2008 1:01 PM kope wrote:

I worked on a workbook yesterday and added a sheet to it. One of my
colleagues came in today she said one of her workbooks would not allow her to
modify the tab names of the worksheet or allow her to add a worksheet. I
opened up the file from the server and checked permissions, etc and saw that
these functions she mentioned were greyed out. I could not get them to work
but when I opened a different workbook of hers in another folder it worked as
normal.

Now the strange thing is, I just opened the workbook stored in my folder (on
the server) and now I can't modify tab names or add a worksheet!!! It's as if
my worksheet got infected. I am afraid to open any other workbooks. Any
suggestions. I can edit cells and same those edits, I just can't modify the
tab name or insert sheets or delete sheets. And how did this get transfered
to my workbook. I have discovered that several more workbooks in her folder
(on our server) are behaving the same.


On Thursday, August 14, 2008 1:18 PM James_Thomlinso wrote:

Sounds to me like the workbook is protected. In XL select Tools - Protection
- Unprotect Workbook. You may need a password if one has been added. If no
one knows the password reply back as we can help you to crack it...
--
HTH...

Jim Thomlinson


"koper" wrote:


On Wednesday, March 02, 2011 2:10 AM bhanu praveen wrote:

Hi,



When i click Unprotect Workbook its asking for password and but i don't have password. Please help me?



Regards

Bhanu