excel
45052 TopicsSharepoint Save Nightmare
My organization uses Sharepoint sites for excel file storage. These files are using Co-Authoring and autosave is enabled. Whenever I am making changes to a file, I check it out, ensuring nobody else is in it, and check it back in and ensure the save and sync process completes without error. Myself and other individuals have been noticing recently that even when checking out files, there are still merge conflicts. My understanding is that if you check out, check in, and properly allow the file to save and sync, there should never be a merge conflict. This is becoming incredibly frustrating, and frankly, unacceptable as these files are relied upon by the organization to run the entire business. Losing critical data due to sharepoint server issues is not acceptable. Has anybody else run into issues with files not saving data, even when you're properly using all the features?8Views0likes0CommentsDate Formatting Won't Change
I have an excel column that includes dates currently formatted as MM/DD/YYYY. I want it formatted as YYYY/MM/DD. When I go to format cells and change the date format, nothing changes. If I try to change the cells to any other type of cell - general, text, number, time, whatever - nothing changes. Please help.Solved1.2MViews2likes88CommentsWhat's the simplest way to make a genuinely random name selection system using Microsoft tools?
For example, suppose I have a list of participants in Excel and want to randomly select one winner without manually choosing from the list. Would you use RAND/RANDBETWEEN in Excel, Power Automate, or another Microsoft 365 approach? I'm also interested in preventing the same person from being selected twice when several winners are needed. I'd appreciate an approach that's easy for someone without much Excel or Power Automate experience to understand.38Views0likes1CommentWord and Excel stuck in Read and Print mode only
I have M365 Family Plan and one of my devices can't use Word or Excel. App tells me they are in Read and Print mode only. I have attempted multiple times to get support to resolve this via chat sessions, but they are unable to help. They have escalated this to Tier 3 Support and still no help. They recommended I go here for support. Here are some of the details. Case Number: 7108165505 (current one) Microsoft 365 Family subscription Word and Excel opening in Read Only / Print mode on one Windows 11 desktop Error when accessing the subscription management page Previous escalation to Tier 2 and Tier 3 Case marked as Resolved despite the issue remaining unresolved Note that extensive troubleshooting has already been completed and that you believe the issue may be related to subscription validation or account provisioning rather than the local Office installation.111Views0likes2CommentsFormatting phone numbers
Hi, When I download data from either the back end of our telephony system or our CRM, the telephone numbers come out like this. My excel doesn't show me any options when looking at special formatting nor can I work out how to create a custom setting. So, who can please help me with what I need to do so that it reads as a correct format i.e. the 1st one should read as 01892521841? I'm looking to do this so that I can run some analysis between the different data sets. 1892521841 4.41E+11 4.41E+11 1323842119 4.42E+11 4.41E+11 1273483119 4.43E+11 4.41E+11 4.42E+11 1342811777 4.42E+11Solved72KViews2likes6CommentsAutoSave disabled when opening SharePoint-synced files from Finder after macOS Tahoe 26.6 update
Files stored in SharePoint Online and synchronized locally through OneDrive are opened as local documents when launched from Finder. Office applications display "Saved to my Mac" and AutoSave is turned off by default. However, opening the exact same files through Word/Excel > Open > Sites, or via SharePoint "Open in Desktop App", correctly identifies them as cloud documents. In that scenario, AutoSave is enabled and collaboration/version history features work as expected. Troubleshooting already performed: OneDrive reset and re-linked SharePoint library re-synced Signed out and back into both Office and OneDrive Removed Microsoft credentials from macOS Keychain and re-authenticated Recreated local OneDrive sync relationships Verified OneDrive File Provider extensions are enabled Verified Office applications and OneDrive are fully up to date Tested with newly created files and existing files Tested "Always Keep on This Device" with no change in behavior The issue appears to be specific to the Finder-to-Office launch path after upgrading to macOS Tahoe 26.6. Before upgrading to macOS Tahoe 26.6, opening the same SharePoint-synchronized files directly from Finder correctly preserved cloud document identity and AutoSave was enabled as expected. I discussed this issue in detail with Apple Support, but they quickly dismissed it, saying that the problem is not on Apple's side and that I should contact Microsoft instead.1.9KViews10likes18Comments