replacement for favorites command in Excel 2007

[KV]

In excel 2003 there was available web toolbar with favorites command. That
allowed quickly to find files. For some reason web toolbar is not available
in excel 2007. Is there any alternative for the favorites command or is this
possibility of saving files locations just disappeared?

 

[Jan Karel Pieterse]

Hi Kv,

In excel 2003 there was available web toolbar with favorites command. That
allowed quickly to find files. For some reason web toolbar is not available
in excel 2007. Is there any alternative for the favorites command or is this
possibility of saving files locations just disappeared?

Rightclick your QAT and select Customise QAT.
Then in the category "Commands not in the ribbon" select "Document Location"
and add it to your QAT. Is that the one you're after?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[מיכ×ל (מיקי) ×בידן]

You need to add it to the Quick Access Toolbar:
Press the "Office" Button > 'Excel options' > Customize' > 'All Commands' >
'Document Location' > 'Add>>' > OK
Micky

 

[KV]

I don't think so. "Document Location" only shows the location of currently
open document. I'd like to save the file locations like I can save www
addresses under Favorites in Internet Explorer. I have a lot of files in
different folders and I can't remember the locations of all of them.

 

[Jan Karel Pieterse]

Hi Kv,

I don't think so. "Document Location" only shows the location of currently
open document. I'd like to save the file locations like I can save www
addresses under Favorites in Internet Explorer. I have a lot of files in
different folders and I can't remember the locations of all of them.

Did you try? it gives you a dropdown list which shows a history of opened
files.

NB: did you know you can pin files on the the recently used files list so they
stay put?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

 

[Bob I]

Navigate to your Favorites folder in the Open File Dialog, and Add it to
the "Left Pane".