Results 1 to 5 of 5

Unable to save file (Well... Sometimes)

Threaded View

  1. #1
    Registered User
    Join Date
    04-08-2016
    Location
    KY
    MS-Off Ver
    MS 365 Enterprise Monthly Update Channel
    Posts
    10

    Unable to save file (Well... Sometimes)

    I have a workbook that is saved as binary .xlsb that we (three people) use on a daily basis. Starting around January of this year, about once a week after one of us would open it and select save, we?d receive an error message stating the file is corrupt and can?t be saved.
    We managed to find a work-around, if one of us that did not receive the error message open, save the workbook and then close it. Then the person who received the error before can now save the workbook without any issues. Then there aren?t any issues again until usually about a week later.
    Over the past two weeks this work-around has been less effective. For instance, this week all three of us were unsuccessful at saving the file.
    But for example, if I reached out to someone else (not one of us three) and requested them to open and save the file. Then we are able to save the file again as well.
    Even stranger, today I had someone outside our group open and save it. I went in and still could not save it. Then, I asked a different person outside our group to open and save it and then I was able to do the same again, as well as the rest of my team.

    Unsuccessful Solutions Tried:
    Opened Excel in Safe Mode and did a file repair.
    I ensured the three of us had the latest Office updates.
    Tried to save the file to my local drive.
    Opened Excel changed calculations to manual and then opened the workbook.
    Tried changing the suffix from xlsb to xlsm (since it does contain macros).
    Posed the question on MS Office Tech Community a month ago but never received a response. (I deleted the post today to prevent cross-posting)
    One thing I did notice is when this occurs I am unable to view any of the macros in the workbook. When I select VBA and double click on any of the macros nothing happens. When I select Reference, Tools nothing as well.
    I have researched the heck out of this and have not been able to find a solution.

    I can't share the workbook because it has sensitive info and it would take me forever to remove all of it. Plus if removing it fixed the issue I would not find the error.

    There has never been a corrupt Excel file I have not been able to open or fix. While this one we are able to still find a way to utilize it, I am concerned that we might not be able to one day. This file would take way too long to rebuild. I do not believe this file is corrupt but can?t figure out what may be causing the issue.
    Last edited by Bluetube; 07-19-2023 at 11:51 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Unable to save as xlsx file
    By Absalon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-23-2017, 08:02 AM
  2. [SOLVED] error 1004 - unable to save file
    By rickmeister in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-08-2017, 07:16 AM
  3. Unable to save or repair a file
    By michele120 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-21-2015, 09:19 PM
  4. Unable to export/save as xml file
    By david90 in forum Excel General
    Replies: 0
    Last Post: 08-10-2013, 08:15 PM
  5. Unable to save CSV file without decimal places
    By gregp85 in forum Excel General
    Replies: 1
    Last Post: 07-04-2008, 05:10 AM
  6. [SOLVED] why am I unable to save a Excel file on a network drive%3f
    By ken in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-17-2005, 10:06 PM
  7. Replies: 4
    Last Post: 03-05-2005, 04:06 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