Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? . |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? . . |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? . . |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 how to create charts compatible with 2003? | Charts and Charting in Excel | |||
Help! Excel 2007 and Excel 2003 are not compatible? | Excel Discussion (Misc queries) | |||
How to save Excel 2007 compatible with excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 being backward compatible | Excel Discussion (Misc queries) | |||
How compatible is Excel 2003 with previous versions | Excel Discussion (Misc queries) |