About Excel 2007

[Dnyan]

Hi,

Earlier I use Excel 2003 and, mostly I used favorites tab after pressing Crtl+O to open the Favorites file from Excel.

But in Excel 2007 there is no option to select Favorites tab to open any Favorites file.

If I want to know How to add this Favorites Tab in Excel 2007.

Regards
Dnyan

 

[RoryA]

Browse to the Favourites folde, then right-click the MyPlaces section of the open dialog and choose to add it.

 

[Dnyan]

Hi,

Thanks for help, but I don't understand how to add this.
I have different drives like U:drive, S:drive & C:drive and from that I previously added all files in Favourite menu option.

Please tell me the steps to add this Favourites Folder.

Regards
Dnyan

 

[RoryA]

Your Favourites folder location varies from operating system to perating system, but on XP mine is at:
C:\documents and settings\username\Favorites

so you need to open the File-Open dialog, open that Favorites folder, then right-click the Places bar on the left of the dialog and choose Add 'Favorites'

 

[Dnyan]

Hi,

But I am using different share file which is on share drive on different folder and I can't save that file in my favourite option becuase other employee also using that files.

Regards
Dnyan

 

[RoryA]

I have no idea what you mean, I'm afraid.

 

[Dnyan]

Hi,

Share files are sametime using by another users it was on Share Drive like S:Drive & U:Drive. I can not move that files anywhere in other folder or other Drives. and that files I wants to add in Favourite tab for shortcut to open the files, but that favourite tab is not available in Excel 2007. It is available on only Excel 2003.

Regards
Dnyan

 

[RoryA]

I've just told you how to add the Favorites folder to your Open dialog, so I don't know what else you want.