Changing the file types displayed


  1. Posts : 3
    XP
       #1

    Changing the file types displayed


    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

    Attached Thumbnails Attached Thumbnails Changing the file types displayed-office-2007.jpg  
      My Computer


  2. Posts : 3,028
    Windows 7 Ultimate (x64) SP1
       #2

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


  3. Posts : 4,772
    Windows 7 Ultimate - 64-bit | Windows 8 Pro - 64-bit
       #3

    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
      My Computer


  4. Posts : 3,028
    Windows 7 Ultimate (x64) SP1
       #4

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

    Changing the file types displayed-word.png

    see...no spreadsheets etc
      My Computer


  5. Posts : 4,772
    Windows 7 Ultimate - 64-bit | Windows 8 Pro - 64-bit
       #5

    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
      My Computer


  6. Posts : 3
    XP
    Thread Starter
       #6

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


  7. Posts : 3
    XP
    Thread Starter
       #7

    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
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 16:15.
Find Us