merge and center in excel not doing anything

Guarantee we will be told to move the files off sharepoint and go back to maintaining the files on the network drive and send emails back and forth and run into issues of people not sending the last file, etc.Īnything that can be done? Already tried on my computer the clearing out of cache and temp files on browser At that point they are given the option to 'Save a Copy' or 'Discard my Changes'.Ī- close the file with the X and select 'close file'ī- immediately reopen the file, watch the 'saving' move to 'saved' and close the file without making any changesĢ - if the file goes from 'saving' to 'saved' you can close the file normally with the X and do nothing else However, if the initial user does not immediately reopen the file and someone else opens the file (and they DO see the changes - this was tested) before the initial user has the chance to open/save, and the 2nd user then makes changes and saves, when the initial user opens, they will get an error saying they were not able to upload because they are unable to merge changes made by the other user. Seems if the initial user goes immediately back in, the local file then uploads and saves and if the initial user then exits the file with no other changes, all is good. We'll retry uploading them the next time you open this file.' Then they are given the chance to 'Close File' or 'Cancel' and cancel simply makes them wait and I've seen it not change at all.

On those times it is stuck, they click the X and the warning msg comes up 'We've saved your changes locally, but we can't upload your changes to the server right now.

Have a sharepoint in testing mode and when some testers and even myself open a file (we are set to where it automatically opens in excel and not the web version), make changes and click on the save icon, there are times where it gets stuck in 'Saving' and sometimes it goes to 'Saved'.

Merge and center in excel not doing anything