Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 145
Default How to change default Open/Files of Type to "Microsoft Excel Files

Hello,

We are running Excel 2002 and I have been asked by a user how to change an
option for opening files.

When this person selects to open files in Excel the default "Files of type"
option is set to "All Microsoft Excel Files" - they would prefer that this
default setting is set to "Microsoft Excel Files". They swear that this was
an option before and has changed and I can not find out to change this.

If someone knows how to do this that would be great and I can get this one
of the list! :-)

Thanks so much in advance.
Tammy
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default How to change default Open/Files of Type to "Microsoft Excel Files

I don't remember being able to set this option on earlier versions and I don't
see a way to alter my version 2003.

Hopefully someone like Jim Rech will post a registry hack.


Gord Dibben MS Excel MVP

On Mon, 14 Jan 2008 14:05:01 -0800, Tammy
wrote:

Hello,

We are running Excel 2002 and I have been asked by a user how to change an
option for opening files.

When this person selects to open files in Excel the default "Files of type"
option is set to "All Microsoft Excel Files" - they would prefer that this
default setting is set to "Microsoft Excel Files". They swear that this was
an option before and has changed and I can not find out to change this.

If someone knows how to do this that would be great and I can get this one
of the list! :-)

Thanks so much in advance.
Tammy


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,091
Default How to change default Open/Files of Type to "Microsoft Excel Files

In Excel 2007, I can choose "Excel Files" as opposed to "All Excel Files"
and that setting will remain for the current Excel session. However, the
default of "All Excel Files" is set when Excel is re-opened. I know of no
way of changing this in Excel.

Tyro

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
I don't remember being able to set this option on earlier versions and I
don't
see a way to alter my version 2003.

Hopefully someone like Jim Rech will post a registry hack.


Gord Dibben MS Excel MVP

On Mon, 14 Jan 2008 14:05:01 -0800, Tammy

wrote:

Hello,

We are running Excel 2002 and I have been asked by a user how to change an
option for opening files.

When this person selects to open files in Excel the default "Files of
type"
option is set to "All Microsoft Excel Files" - they would prefer that this
default setting is set to "Microsoft Excel Files". They swear that this
was
an option before and has changed and I can not find out to change this.

If someone knows how to do this that would be great and I can get this one
of the list! :-)

Thanks so much in advance.
Tammy




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i change the default location of my picture files in Excel Rosie D Excel Discussion (Misc queries) 2 June 4th 06 11:43 AM
On opening Excel, 4 non ".xls" files open that I cannot delete Twoheat Excel Discussion (Misc queries) 2 March 6th 06 03:36 PM
How do I change default user name for all Excel Files? miriamfox Excel Discussion (Misc queries) 1 October 17th 05 07:16 PM
How do I change file/open/"files of type" to default to "all file. How do I changefiles of type default Excel Discussion (Misc queries) 1 April 19th 05 10:45 PM
how would i change default user name all excel files learner Excel Discussion (Misc queries) 1 November 29th 04 11:12 PM


All times are GMT +1. The time now is 07:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"