Compatible Mode for 97/2003 doc in 2007
 

We have an Excel 97/2003 workbook that we pulled up in Excel 2007; but we
noticed that with all the protections turned off there were some things that
we could not do, for example, renaming a worksheet. Anyone have any ideas
why that might happen? What can I do to fix it?

Compatible Mode for 97/2003 doc in 2007
 

When you attempt to re-name a worksheet what happens?

Error message or??

Is the workbook protected under ReviewProtect Workbook?


Gord Dibben MS Excel MVP

On Fri, 9 Apr 2010 07:54:01 -0700, Renee
wrote:

We have an Excel 97/2003 workbook that we pulled up in Excel 2007; but we
noticed that with all the protections turned off there were some things that
we could not do, for example, renaming a worksheet. Anyone have any ideas
why that might happen? What can I do to fix it?

Compatible Mode for 97/2003 doc in 2007
 

When she right clicks the tab for the worksheet the function to rename a
worksheet is grayed out.

The workbook was not protected as I watched her take the protection off.
And I watched her as she tried to rename the worksheet after removing the
protection. I also want to mention, which I didn't before, that she enabled
the options button after opening the workbook.

"Gord Dibben" wrote:

When you attempt to re-name a worksheet what happens?

Error message or??

Is the workbook protected under ReviewProtect Workbook?


Gord Dibben MS Excel MVP

On Fri, 9 Apr 2010 07:54:01 -0700, Renee
wrote:

We have an Excel 97/2003 workbook that we pulled up in Excel 2007; but we
noticed that with all the protections turned off there were some things that
we could not do, for example, renaming a worksheet. Anyone have any ideas
why that might happen? What can I do to fix it?

.

Compatible Mode for 97/2003 doc in 2007
 

Enabled which "options button"?

Still sounds like workbook protection but you say you saw her remove it so
I'm out of ideas.


Gord


On Fri, 9 Apr 2010 09:15:01 -0700, Renee
wrote:

When she right clicks the tab for the worksheet the function to rename a
worksheet is grayed out.

The workbook was not protected as I watched her take the protection off.
And I watched her as she tried to rename the worksheet after removing the
protection. I also want to mention, which I didn't before, that she enabled
the options button after opening the workbook.

"Gord Dibben" wrote:

When you attempt to re-name a worksheet what happens?

Error message or??

Is the workbook protected under ReviewProtect Workbook?


Gord Dibben MS Excel MVP

On Fri, 9 Apr 2010 07:54:01 -0700, Renee
wrote:

We have an Excel 97/2003 workbook that we pulled up in Excel 2007; but we
noticed that with all the protections turned off there were some things that
we could not do, for example, renaming a worksheet. Anyone have any ideas
why that might happen? What can I do to fix it?

.

Compatible Mode for 97/2003 doc in 2007
 

It's the "options" button below the ribbon that appears when you open a
document. It disables any macros in a document until you enable it.

"Gord Dibben" wrote:

Enabled which "options button"?

Still sounds like workbook protection but you say you saw her remove it so
I'm out of ideas.


Gord


On Fri, 9 Apr 2010 09:15:01 -0700, Renee
wrote:

When she right clicks the tab for the worksheet the function to rename a
worksheet is grayed out.

The workbook was not protected as I watched her take the protection off.
And I watched her as she tried to rename the worksheet after removing the
protection. I also want to mention, which I didn't before, that she enabled
the options button after opening the workbook.

"Gord Dibben" wrote:

When you attempt to re-name a worksheet what happens?

Error message or??

Is the workbook protected under ReviewProtect Workbook?


Gord Dibben MS Excel MVP

On Fri, 9 Apr 2010 07:54:01 -0700, Renee
wrote:

We have an Excel 97/2003 workbook that we pulled up in Excel 2007; but we
noticed that with all the protections turned off there were some things that
we could not do, for example, renaming a worksheet. Anyone have any ideas
why that might happen? What can I do to fix it?

.


.

Compatible Mode for 97/2003 doc in 2007
 

This issue has now been resolved. Apparently, the workbook was protected.
Once we unprotected the workbook, then everything was accessible. Thank you
for your help, Gord!

"Renee" wrote:

It's the "options" button below the ribbon that appears when you open a
document. It disables any macros in a document until you enable it.

"Gord Dibben" wrote:

Enabled which "options button"?

Still sounds like workbook protection but you say you saw her remove it so
I'm out of ideas.


Gord


On Fri, 9 Apr 2010 09:15:01 -0700, Renee
wrote:

When she right clicks the tab for the worksheet the function to rename a
worksheet is grayed out.

The workbook was not protected as I watched her take the protection off.
And I watched her as she tried to rename the worksheet after removing the
protection. I also want to mention, which I didn't before, that she enabled
the options button after opening the workbook.

"Gord Dibben" wrote:

When you attempt to re-name a worksheet what happens?

Error message or??

Is the workbook protected under ReviewProtect Workbook?


Gord Dibben MS Excel MVP

On Fri, 9 Apr 2010 07:54:01 -0700, Renee
wrote:

We have an Excel 97/2003 workbook that we pulled up in Excel 2007; but we
noticed that with all the protections turned off there were some things that
we could not do, for example, renaming a worksheet. Anyone have any ideas
why that might happen? What can I do to fix it?

.


.

Compatible Mode for 97/2003 doc in 2007
 

Good to hear.

Gord

On Mon, 12 Apr 2010 14:34:01 -0700, Renee
wrote:

This issue has now been resolved. Apparently, the workbook was protected.
Once we unprotected the workbook, then everything was accessible. Thank you
for your help, Gord!

"Renee" wrote:

It's the "options" button below the ribbon that appears when you open a
document. It disables any macros in a document until you enable it.

"Gord Dibben" wrote:

Enabled which "options button"?

Still sounds like workbook protection but you say you saw her remove it so
I'm out of ideas.


Gord


On Fri, 9 Apr 2010 09:15:01 -0700, Renee
wrote:

When she right clicks the tab for the worksheet the function to rename a
worksheet is grayed out.

The workbook was not protected as I watched her take the protection off.
And I watched her as she tried to rename the worksheet after removing the
protection. I also want to mention, which I didn't before, that she enabled
the options button after opening the workbook.

"Gord Dibben" wrote:

When you attempt to re-name a worksheet what happens?

Error message or??

Is the workbook protected under ReviewProtect Workbook?


Gord Dibben MS Excel MVP

On Fri, 9 Apr 2010 07:54:01 -0700, Renee
wrote:

We have an Excel 97/2003 workbook that we pulled up in Excel 2007; but we
noticed that with all the protections turned off there were some things that
we could not do, for example, renaming a worksheet. Anyone have any ideas
why that might happen? What can I do to fix it?

.


.