Page 1 of 2 12 LastLast
Results 1 to 15 of 30
  1. #1
    3 Star Lounger
    Join Date
    Jan 2011
    Posts
    284
    Thanks
    33
    Thanked 2 Times in 2 Posts

    Excel 2016 - does not save!

    Hi there

    I have just encountered a first for me.... Excel 2016 (Office365 Business) will not save files any longer. When working on an excel file I get this message when saving:
    "Your changes could not be saved...because of a sharing violation. Please close the file and reopen it"

    When you do this all your changes are lost. It appears that Excel creates a new temp file with a random filename and no extension A04345DF for example. This should be renamed to the filename you've just saved, and then the old xlsx file should be deleted. This is as per the article on MS website "how excel saves a file"

    This is driving me nuts - there is no sharing on the folder or any other access from anyone else.

    I had this on my laptop and went through removing and re-installing Office365. Now I have tried on a different machine, and it worked but now this one has the same problem........... I am now re-installing my laptop - Windows 10 + all apps and then data restore to be done - its gonna be days!

    Please help!!! I have a major deadline looming, and can't save files.

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi

    is it just the File>Save not working??
    ..can you do a File-SaveAs????
    ..can you save the file to external storage??

    zeddy

  3. #3
    3 Star Lounger
    Join Date
    Jan 2011
    Posts
    284
    Thanks
    33
    Thanked 2 Times in 2 Posts
    I have tried this on two separate machines - its a spreadsheet with loads of data that has taken over a week to gather from around 2000 pages of various documents. It appears to be the same problem wherever I save it, and using SAVE or SAVE AS is the same issue.

    Is this an Excel issue, Windows 10 Issue, or just this spreadsheet? I have no idea what the cause is, because I have worked using the same environment for a couple of years without any issues. Now this crops up just before I need to finalise a report......

    I don't think its a file issue, because it happens with others, too (on different machines)

    Unfortunately I can't share the file, as its confidential info....

  4. #4
    3 Star Lounger
    Join Date
    Jan 2011
    Posts
    284
    Thanks
    33
    Thanked 2 Times in 2 Posts
    I've been searching the forum, and found this thread which has the same problem:
    http://windowssecrets.com/forums/sho...n-t-re-open-it

    The "solution" was to try a difference drive, but this time, I am using a completely different machine! same problem.

  5. #5
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi

    Is the file located on a local network drive??
    Is the file in a sharepoint location??
    Is the file in a 'cloud' location??

    zeddy

  6. #6
    3 Star Lounger
    Join Date
    Jan 2011
    Posts
    284
    Thanks
    33
    Thanked 2 Times in 2 Posts
    Hi Zeddy

    Yes - I use a Private Cloud system to keep things "safe" - its called AeroFS. It works across the local network, and I suppose this is a "watched folder" type of application.

    The same file saves fine if I copy it to a folder on the desktop and outside of the AeroFS folders. This has only just started to happen.... I've used this for years now without a problem - why has this suddenly started to happen, I wonder?

    For info - the same thing happens, even if I turn off the AeroFS syncing......

  7. #7
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi

    How big is the file?? Is it 'timing out' on your network???
    I use .xlsb file format to significantly reduce file size and reduce network traffic.
    What is the original source of the file??
    Is it an old .xls file that has been updated???

    zeddy

  8. #8
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    12,519
    Thanks
    152
    Thanked 1,398 Times in 1,221 Posts
    I would definitely suspect AeroFS, judging from the error message you get. Have you tried the Save As option to a non AeroFS monitored folder?
    Rui
    -------
    R4

  9. #9
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts
    It sounds to me that file size may be an issue here.
    If it is not in xlsb format, try using a local copy, then saving it in xlsb format.
    Then try seeing if it will save to your cloud system.

    zeddy
    Last edited by zeddy; 2016-04-05 at 07:31.

  10. #10
    3 Star Lounger
    Join Date
    Jan 2011
    Posts
    284
    Thanks
    33
    Thanked 2 Times in 2 Posts
    The file size is small - 170kb! It doesn't make sense to me that it would cause a timeout problem. I get the same error if I turn off the syncing, so I don't think that's the problem.

    The file format is .xlsx = 170kb
    In file format .xlsb = 130kb = not much difference.

    I have other files (my Timesheets file for example) that has a link to another excel file, and is around 1.7Mb and the linked file is only 25kb and now that I have gone to check they also suffer from the same problem!! It must be something to do with the AeroFS client installed on my machine.

    I don't have this problem with any Word docs, or other files.... strange!

  11. #11
    3 Star Lounger
    Join Date
    Jan 2011
    Posts
    284
    Thanks
    33
    Thanked 2 Times in 2 Posts
    Here's a really strange issue: I have other excel files that I have opened and edited around the same time as these. These open and save perfectly OK, whilst others don't - now I'm completely confused!!

    They are in different folders, but still under AeroFS..... so it's not AeroFS either.........

  12. #12
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts
    its a spreadsheet with loads of data that has taken over a week to gather from around 2000 pages of various documents
    ..yes, 170kb shouldn't be a problem at all! (I was thinking the file might've been ~40MB)

    Check to see if the file you are trying to save has any unusual 'links'. like referring to a phantom drive location, or a network location that has been recently changed or deleted.
    I once had a problem with someone's Excel file performing very sluggishly - turned out there was a link in the file that referred to a server which was located in another country.

    zeddy

  13. #13
    3 Star Lounger
    Join Date
    Jan 2011
    Posts
    284
    Thanks
    33
    Thanked 2 Times in 2 Posts
    I have been thinking that it might be the path/filename length - but that's not it either! The files that I have had a problem with are both long and short.... and the file that saves has a path length in between....!!!

    Path lengths that don't work: 115 characters & 54 characters
    Path length that works: 102 characters

  14. #14
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    12,519
    Thanks
    152
    Thanked 1,398 Times in 1,221 Posts
    Quote Originally Posted by Photorer View Post
    Here's a really strange issue: I have other excel files that I have opened and edited around the same time as these. These open and save perfectly OK, whilst others don't - now I'm completely confused!!

    They are in different folders, but still under AeroFS..... so it's not AeroFS either.........
    I am sorry to insist, but you have done nothing to prove it's not AeroFS and something with the specific files that do not save. The fact that other files open properly just means that AeroFS doesn't affect the other files. The error message is telling and it seems to me that you are choosing to ignore it.
    Rui
    -------
    R4

  15. #15
    3 Star Lounger
    Join Date
    Jan 2011
    Posts
    284
    Thanks
    33
    Thanked 2 Times in 2 Posts
    Thanks Zeddy

    The timesheet & joblist files link to each other, so that might be the problem there. Never had this as an issue before, though.
    The other one that has a problem has lots of internal lookups etc. but no external links! I checked that too!

    The one that just saves has no links - perhaps that's the issue?

Page 1 of 2 12 LastLast

Posting Permissions

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