Disabled Properties menu option

**Dooldeniya** · 04-09-2009, 11:37 AM

Hi all - I'm using excel 2003 and received a file that has the properties (file/Properties) menu option grayed out. I need to access the properties menu to identify file information. Any help would be appreciated.

Thanks,
Chanaka

**dominicb** · 04-09-2009, 11:55 AM

Good afternoon Dooldeniya

Originally Posted by Dooldeniya

I'm using excel 2003 and received a file that has the properties (file/Properties) menu option grayed out. I need to access the properties menu to identify file information.

Does the file have any macros?
If so have you tried opening it and disabling the macros?
Does this happen on any other workbooks you open?

DominicB

**Dooldeniya** · 04-09-2009, 12:36 PM

It doesn't have any macros and all other excel workbooks have the properties option enabled.

**dominicb** · 04-09-2009, 12:49 PM

Hi Dooldeniya

Originally Posted by Dooldeniya

It doesn't have any macros and all other excel workbooks have the properties option enabled.

OK. Would you be able to delete all the information in it and post the empty workbook so someone can take a look at it.
**Remember to take a copy of it first**

DominicB

**shg** · 04-09-2009, 12:59 PM

Unprotect the workbook.

**Dooldeniya** · 04-09-2009, 04:22 PM

Shg - Unprotecting the Workbook solved the problem. I tried to edit the topic to solved but couldn't figure it out. Can one of the moderators please add the solved tag.