Your browser isn't supported
It looks like you're using an old web browser. To get the most out of the site and to ensure guides display correctly, we suggest upgrading your browser now. Download the latest:

Welcome to the MSE Forums

We're home to a fantastic community of MoneySavers but anyone can post. Please exercise caution & report spam, illegal, offensive or libellous posts/messages: click "report" or email forumteam@. Skimlinks & other affiliated links are turned on

Search
  • FIRST POST
    • libra10
    • By libra10 17th Jul 17, 2:43 PM
    • 9,579Posts
    • 166,490Thanks
    libra10
    Excel problem XLSX files
    • #1
    • 17th Jul 17, 2:43 PM
    Excel problem XLSX files 17th Jul 17 at 2:43 PM
    I have recently reinstalled Windows 10 and Office 2007, and find that a couple of backed up XLSX files refuse to be saved.


    Never had a problem saving Excel files before and not sure how the problem occurred. The files will open in Office 2007, but unable to save and edit as necessary.


    Have looked on the net but become confused, and wondered whether anyone could suggest something straightforward that would help.


    Thank you
Page 1
    • DoaM
    • By DoaM 17th Jul 17, 3:21 PM
    • 3,214 Posts
    • 3,250 Thanks
    DoaM
    • #2
    • 17th Jul 17, 3:21 PM
    • #2
    • 17th Jul 17, 3:21 PM
    Is the path for the files in the Trusted Locations?
    Diary of a madman
    Walk the line again today
    Entries of confusion
    Dear diary, I'm here to stay
    • poppellerant
    • By poppellerant 17th Jul 17, 3:24 PM
    • 989 Posts
    • 507 Thanks
    poppellerant
    • #3
    • 17th Jul 17, 3:24 PM
    • #3
    • 17th Jul 17, 3:24 PM
    Might be easier, if you can, to copy and paste the contents into a new Excel document and saving a new copy. Obviously test this version works and functions properly before getting rid of the problematic version.
    • libra10
    • By libra10 17th Jul 17, 3:45 PM
    • 9,579 Posts
    • 166,490 Thanks
    libra10
    • #4
    • 17th Jul 17, 3:45 PM
    • #4
    • 17th Jul 17, 3:45 PM
    Thanks for replies.


    DoaM - not sure what you mean about trusted locations.


    poppellerant - will see whether I can do this now.
    • libra10
    • By libra10 17th Jul 17, 4:02 PM
    • 9,579 Posts
    • 166,490 Thanks
    libra10
    • #5
    • 17th Jul 17, 4:02 PM
    • #5
    • 17th Jul 17, 4:02 PM
    I copied and pasted text to a new workbook, and saved as 'Excel workbook'. But unfortunately I have the same problem as before.


    Not sure whether it's any help, but the icon for the saved XLSX file shows the internet explorer 'e' symbol.


    Would appreciate any further suggestions.
    • Le_Kirk
    • By Le_Kirk 17th Jul 17, 5:30 PM
    • 2,078 Posts
    • 1,057 Thanks
    Le_Kirk
    • #6
    • 17th Jul 17, 5:30 PM
    • #6
    • 17th Jul 17, 5:30 PM
    Where are you trying to save the files to? Is it a location on your PC or the cloud?
    • libra10
    • By libra10 17th Jul 17, 5:34 PM
    • 9,579 Posts
    • 166,490 Thanks
    libra10
    • #7
    • 17th Jul 17, 5:34 PM
    • #7
    • 17th Jul 17, 5:34 PM
    Le_Kirk I'm trying to save into an Excel worksheet which I keep in a folder on laptop desktop.
    • Le_Kirk
    • By Le_Kirk 17th Jul 17, 6:50 PM
    • 2,078 Posts
    • 1,057 Thanks
    Le_Kirk
    • #8
    • 17th Jul 17, 6:50 PM
    • #8
    • 17th Jul 17, 6:50 PM
    What do you mean "trying to save into an Excel worksheet?" You can only Save to a location, i.e. a folder on your PC/laptop/USB stick or to the cloud. With Excel open, click on File and open Options, click on Trust Centre and open Trust Centre Settings. Then click on File Block Settings. There you can see all the different versions of Excel that you can decide if you want to allow them to be opened and saved. See if you have a spurious radio button active or you could click restore defaults.
    • libra10
    • By libra10 17th Jul 17, 7:06 PM
    • 9,579 Posts
    • 166,490 Thanks
    libra10
    • #9
    • 17th Jul 17, 7:06 PM
    • #9
    • 17th Jul 17, 7:06 PM
    I'm trying to save into a folder on my laptop desktop, something I've done 100s of times with no problems. Until now!


    I did as you suggested - opened Excel, clicked File, Open, but there are no Trust Centre or Trust Centre Settings, just general programmes and files on my PC.


    Any further suggestions?
    • lammy82
    • By lammy82 17th Jul 17, 7:42 PM
    • 224 Posts
    • 214 Thanks
    lammy82
    You say that you can't save the file, but that the saved file has got the internet explorer 'e' symbol.

    What exactly happens when you try to save the file? How do you know it's not saving? What if you select Save As... and choose a different filename?
    • libra10
    • By libra10 17th Jul 17, 7:57 PM
    • 9,579 Posts
    • 166,490 Thanks
    libra10
    Thanks for replying.

    Am using iPad at present, when back on laptop will try and post an image of file.

    When I try to save file, something opens and closes again quickly. Underneath there seems to be another file. Will try and post image later as difficult to explain.

    Have tried saving, re-naming, etc but nothing seems to work.

    Thanks for your help, much appreciated.
    • libra10
    • By libra10 17th Jul 17, 8:20 PM
    • 9,579 Posts
    • 166,490 Thanks
    libra10
    This is a picture of how file appears when opened.


    The e (internet explorer) icon at left, is how the file is displayed on desktop.


    • lammy82
    • By lammy82 17th Jul 17, 8:42 PM
    • 224 Posts
    • 214 Thanks
    lammy82
    The file is opening via Internet Explorer instead of directly to Excel. Excel then treats the file as an internet download, maybe.

    Can you right-click on the file and select "Open With...", then choose Excel from the dialog box (you might have to click 'More apps' to find it), and also select the tick-box which says "Always use this app".

    That should open the file directly into Excel - see if it makes a difference.
    • libra10
    • By libra10 17th Jul 17, 9:01 PM
    • 9,579 Posts
    • 166,490 Thanks
    libra10
    Hi lammy, thanks for your help.

    Had already tried that, however Excel isn't given as an option. I chose programmes, Excel, but screen says file name not valid.
    • Jivesinger
    • By Jivesinger 17th Jul 17, 9:09 PM
    • 1,197 Posts
    • 719 Thanks
    Jivesinger
    Try renaming to .xml, then try opening it from Excel (ie not double-clicking the file).
    • libra10
    • By libra10 18th Jul 17, 7:43 AM
    • 9,579 Posts
    • 166,490 Thanks
    libra10
    Thanks for replying.


    I can open the file in Excel, but not directly from saved backup.


    Like you say, if I go to Excel, choose the file, the worksheet seems alright.


    However, this works differently to two other Excel files which I saved at the same time. The other backup files have the file extension .xsl compared to the extension on problem files, which is .xlsx


    It seems that somehow the .xlsx files have become corrupted, and I wondered whether I could somehow change them to .xsl files, which work fine.


    Thank you
    • DoaM
    • By DoaM 18th Jul 17, 8:30 AM
    • 3,214 Posts
    • 3,250 Thanks
    DoaM
    You mean .xls not .xsl ... .xls is the "old" (97-2003) Excel file format.

    My wife has the odd Excel file that won't open properly in Excel when double-clicking them, but opens fine if opened from within Excel.
    Diary of a madman
    Walk the line again today
    Entries of confusion
    Dear diary, I'm here to stay
    • Le_Kirk
    • By Le_Kirk 18th Jul 17, 9:40 AM
    • 2,078 Posts
    • 1,057 Thanks
    Le_Kirk
    I did as you suggested - opened Excel, clicked File, Open, but there are no Trust Centre or Trust Centre Settings, just general programmes and files on my PC.
    Originally posted by libra10
    Not File, Open. Click on File, then run down the list to the bottom and click on Options, then follow my previous instructions.
    • libra10
    • By libra10 18th Jul 17, 10:31 AM
    • 9,579 Posts
    • 166,490 Thanks
    libra10
    You mean .xls not .xsl ... .xls is the "old" (97-2003) Excel file format.

    My wife has the odd Excel file that won't open properly in Excel when double-clicking them, but opens fine if opened from within Excel.
    Originally posted by DoaM


    You're right, apologies. The files which work alright are -
    Microsoft Office Excel 97-2003 Worksheet (.xls)
    • libra10
    • By libra10 18th Jul 17, 10:44 AM
    • 9,579 Posts
    • 166,490 Thanks
    libra10
    Not File, Open. Click on File, then run down the list to the bottom and click on Options, then follow my previous instructions.
    Originally posted by Le_Kirk

    Have found Trusted Locations, which gives a list of paths or user locations. Unfortunately there is no option 'file block settings. or choice to restore defaults.
Welcome to our new Forum!

Our aim is to save you money quickly and easily. We hope you like it!

Forum Team Contact us

Live Stats

3,360Posts Today

8,075Users online

Martin's Twitter