+ Reply to Thread
Results 1 to 2 of 2

In v-10 changed from .xls to .xlsx Do I need to save Personal.xls as Personal.xlsx ?

  1. #1
    Registered User
    Join Date
    07-10-2005
    Location
    Atlanta
    Posts
    20

    In v-10 changed from .xls to .xlsx Do I need to save Personal.xls as Personal.xlsx ?

    I have Excel 2010. For the first few years, I set my default save as Excel 97-2003 (*.xls)
    I now want to start saving all Excel workbooks as .xlsx. I've already made the change in File / Options / General / Save
    Do I have to do anything in particular to Personal.xls, such as saving it as Personal.xlsx ?
    Please advise. The more detail, the better.
    Thanks

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: In v-10 changed from .xls to .xlsx Do I need to save Personal.xls as Personal.xlsx

    You don't have to change PERSONAL.XLS to get it to load, just because you changed the default save format. However, note that the file name from Excel 2007 forward is PERSONAL.XLSB. I do believe that PERSONAL.XLS will load if it's in the XLSTART folder, which I did by accident once.

    This is very easy to confirm. Open Excel, then View, Unhide and see if PERSONAL.XLS is shown in the hidden workbook list. If so you're all set.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 07-17-2013, 04:58 AM
  2. Merge Data from different .xlsx files & different sheet to a new .xlsx
    By QcSylvanio in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-03-2012, 01:11 PM
  3. Replies: 6
    Last Post: 08-28-2012, 03:51 AM
  4. How to add the columns data of several xlsx files of a folder in another xlsx file
    By ravikumar00008 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-25-2012, 04:29 AM
  5. Using Personal.xlsx for Data Validation Lists
    By DJBittner in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-25-2011, 04:29 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1