+ Reply to Thread
Results 1 to 5 of 5

Excel not saving in .xlsx format

  1. #1
    Registered User
    Join Date
    08-01-2018
    Location
    England
    MS-Off Ver
    2016
    Posts
    4

    Excel not saving in .xlsx format

    I have multiple users who are unable to save in the latest .xlsx format for Excel 2016. When saving to .xls 97-2003 it will save but with compatibility issues due to the macros.

    It's affecting users locally on their desktops and also on the network drive. For some it's only one specific file. They can be using Win 10 or 7 with Office 2016 32bit. The files they use range from 100KB to 10MB as they use macros and all sorts.

    Tried setting all Excel sheets to 100%, all files have the same permissions as any network file should and the location being saved doesn't matter, it will still crash. Users from IT with and without full network access have tried and can save.

    I have checked the event log viewer but couldn't decode any data.

    We think it's a Microsoft update but haven't been able to pull enough data from those affected to cross reference them. The only thing we know so far is that all the PCs are on one building site out of multiple locations. We believe this is due to the way the updates have been pushed to our network. The issue seems to occur a few days after Windows updates are downloaded.

    Thank you very much.
    Attached Images Attached Images

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 2209 64-bit
    Posts
    21,449

    Re: Excel not saving in .xlsx format

    What happens when they try to save a file to the default format? Does this happen for existing files, or new files, or both?
    Jeff
    | | |?| |?| |?| |?| | |:| | |?| |?|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    08-01-2018
    Location
    England
    MS-Off Ver
    2016
    Posts
    4

    Re: Excel not saving in .xlsx format

    For some users it's only ever one file. This file can be old with lots of data and maybe macros, maybe originally created in an older format. One file however is very new and only a few months old. The files were fine at one point then the next day they developed their issues. This makes me think an update was done during the night but as to which one I cannot tell.

    I'm trying to speak to more users to see if the crash happened after the updates were applied.

  4. #4
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 2209 64-bit
    Posts
    21,449

    Re: Excel not saving in .xlsx format

    Quote Originally Posted by Agent47_red View Post
    One file however is very new and only a few months old
    That is not "new." I mean the user opens Excel and creates a new file, then tries to save it.

  5. #5
    Registered User
    Join Date
    08-01-2018
    Location
    England
    MS-Off Ver
    2016
    Posts
    4

    Re: Excel not saving in .xlsx format

    Sorry. I haven't been able to get hold of the users to fully confirm the scope.
    They can save new files in Excel and to other existing ones. In many cases it's only one existing file that's the issue.
    They work in different departments but might share files.

+ 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. [SOLVED] saving from .xlsm to .xlsx
    By k1dr0ck in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-27-2018, 01:14 AM
  2. Replies: 1
    Last Post: 06-29-2017, 12:37 PM
  3. [SOLVED] with this macro I can't insert the file format xlsx, only xls but I need format xlsx
    By torti111 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-28-2016, 04:45 AM
  4. Saving text format from .xlsx to CSV problem
    By inincubus in forum Excel General
    Replies: 3
    Last Post: 03-29-2014, 01:36 PM
  5. Replies: 1
    Last Post: 10-27-2013, 04:37 PM
  6. Replies: 2
    Last Post: 10-27-2013, 02:49 PM
  7. Help with formula conversion of XLSX to 2003 format Excel
    By asanthadenz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-19-2013, 12:10 AM

Tags for this Thread

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