Changing the file types displayed

[andysharps]

Hi,

Can anybody help me with the following.

In Excel 2007 on Windows 7 if you click on the office button & then open, the window opens, the file types drop down in the bottom right hand corner is set to ‘all excel files’ & in the list of files in the main window only Excel files are displayed.

If you start typing a file name in the file name field at the bottom, all types of files that match the file name are displayed, you can see .docs are listed with .xls , Is it possible to change this so only excel files are displayed in Excel & only Word files in Word?


I have attached a screen shot in case the above is not very clear.


Thanks for any help.


Andy

 

[tw33k]

Try deleting normal.dot: c:\%username%\AppData\Roaming\Microsoft\Templates

 

[Capt.Jack Sparrow]

Hello Andysharps Welcome to SF !!

I guess it some kind of known issue. I just tested it in my Excel it was happening the same. Anyway i'll do some research on it.

Hope this helps,
Captain

 

[tw33k]

If I open Word, I only see word docs. If I open Excel, I only see Excel sheets. Delete normal.dot



see...no spreadsheets etc

 

[Capt.Jack Sparrow]

Hello Tw33k,

Can I know why we are deleting Normal.dot ?? Because if i understand correctly Normal.dot is Word reference and for Excel we don't have one, it saves the Macros Internally. But Yes we can create one under C:\Program Files\Microsoft Office\Office\XLSTART\ so it will open whatever customized one we created there upon start.

Hope this helps,
Captain

 

[andysharps]

OK, I'm on site later today I will try that & post my findings.

 

[andysharps]

I tried deleting normal.dot but unfortunately it didn't make any difference.

tw33k, the problem isn't just displaying the documents when you go 'open' & a list of documents is displayed, at that point only word or excel files are displayed.

It is when you start typing a file name in the 'file name' field then the list of documents in the main window changes from just word docs in word or just excel docs in excel to a mixture of document types that match the name being typed.

Hope that's' clear.

Andy