default file locations Excel 2007

M

Machin8409

How can I change the default file location for inserting pictures? It
currently goes to My Pictures, which I do not want. The Excel Options
button/Advanced does not have the option to change this, like Word does.
 
R

Robert Flanagan

A simple cure is to right click in the white space in the open dialog for
the pictures default folder and select New, Shortcut. Select as the target
of the shortcut your desired folder. Name the shortcut AAA something so it
is on top. One advantage is you can add multiple shortcuts. And this
approach works in any file open/selection dialog.

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook linking to non default browser Edge 0
Merging from an Excel file with graphics 1
Default local file location - folder redirection slowness 0
Set as Default Template not working 0
Embed the same Excel multiple times 0
Auto Populate One Pages from spreadsheet 0
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Confusion over where user templates are stored in Word 1

Top