Skip to main content

TIP - 53 : Set your default local location for saving excel file - Options


Set your default local location for saving excel file – Options

Many of the people will save the excel files, but they forgot where the file was saved. When they want to retrieve it is difficult for them.

To avoid that kind of difficulties, below is trick you use from excel

Step 1: Please click on File menu, then click on Options

Step 2: From the dialogue box “Excel Options”, go to save section then click on the check box “Save to computer by default”

And we can change the path of the folder if required from “Default local file location”.

Comments

Popular posts from this blog

Report Publishing via Pivot Table in different sheets

Report Publishing via Pivot Table in different sheets This feature is mostly helpful to publish the data in sheet wise Step 1: Create pivot table with Report filter , go to analysis tab or Options tab from "PivotTable options" Step 2: Click on options drop down Step 3: Then click on  “Show report filter pages” Now we can see the new excel sheet tabs names along with data, published based on the report filtered data.