Useful Hacks, Reviews, Tips and Tricks of anything under the moon and the sun.

Change the default file location in MS Excel

No comments
This morning, we finished consolidating all our Team's documents in one shared folder. Our boss instructed us to set our MS excel to point the common shared folder so that every time we open a document the default file location will be the team folder.

To change the default file location in MS Excel, do the following steps:

1. Go to Tools Menu then click Options.
2. From the Options dialog box, click the General tab.
3. At the bottom, look for "Default file location" text box.

Change the default file location in MS Excel

4. Replace it with the new default folder.
5. Click OK to save changes.

No comments :

Post a Comment