PDA

View Full Version : Excel Property Window While Saving



r_know
07-29-2013, 11:03 AM
Dear All,

How I can rid from the Property Window when saving excel file first time?

10340

Reg,
RL

SamT
07-29-2013, 11:19 AM
Display the Properties dialog box when saving workbooks (http://office.microsoft.com/en-us/excel-help/display-the-properties-dialog-box-when-saving-workbooks-HP005198650.aspx)



To help organize your workbooks so that you can find them easily later, you can set file properties for the active workbook. If you want to be reminded to set file properties for every workbook you create, you can have Microsoft Excel display the Properties dialog box when you save a workbook for the first time.

For more information about file properties and their purpose, click About file properties in the See Also section of this topic.



On the Tools menu, click Options, and then click the General tab.
Select the Prompt for workbook properties check box.


Note The Properties dialog box will be displayed after you click Save in the Save As dialog box whenever you save a file for the first time, or when you click Save As on the File menu to save the file with another name.

Kenneth Hobs
07-29-2013, 11:49 AM
What version of Excel? That is not normal. There may be an option that is forcing the display for Custom Properties most likely. Read about that in: http://www.addintools.com/documents/excel/where-is-document-properties/where-is-document-properties.html#2010

r_know
07-30-2013, 04:41 AM
I am using excel 2010.

I am seeing above guidelines...

r_know
07-30-2013, 11:41 PM
I cant find a solution in given guideline due to excel 2010version!

Kenneth Hobs
07-31-2013, 05:39 AM
Have you looked at File > Info > Properties? Properties is on the far right of the backstage view.

r_know
07-31-2013, 10:00 AM
Yes, I saw that but do not find the way that does not prompt me when saving workbook.