B
brbakrider
I have been unable to rename workbook sheets. Please advise
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Fred Smith
What have you tried, and what error message did you get? What happens when
you rename in Explorer?
Regards,
Fred.
you rename in Explorer?
Regards,
Fred.
B
brbakrider
Fred Smith said:What have you tried, and what error message did you get? What happens when
you rename in Explorer?
Regards,
Fred.
Do you have excel 2007? There does not seem to be an option to rename sheet tabs. I do not use explorer, why would it matter?
D
Dave Peterson
Try rightclicking on the sheet tab. You should see a popup menu that includes
an option for renaming.
an option for renaming.
B
brbakrider
Yes Dave I have. That works on another workbook. I don't know why theDave Peterson said:Try rightclicking on the sheet tab. You should see a popup menu that includes
an option for renaming.
option is unavailable in this workbook, when I right click on the sheet name
tabs.
R
Ron Rosenfeld
Yes Dave I have. That works on another workbook. I don't know why the
option is unavailable in this workbook, when I right click on the sheet name
tabs.
Might have saved some time if you had communicated this initially.
When you say the "option is unavailable" do you mean it is not there? or that
it is grayed out.
If it is grayed out, protection is one thing that can cause that. Go to the
Review ribbon and see if the workbook is protected. If it is, the option will
read Unprotect workbook. If it is not, it will read Protect workbook.
--ron