Unwanted format changes on Excel worksheet in SharePoint
Hello - I've been working successfully with an Excel worksheet (.XLSX extension) that is published to SharePoint and has multiple Users viewing/updating data on this worksheet every day. Today, columns on this worksheet keep reverting back to varying widths (some way too wide and others way too narrow) despite going into the worksheet, re-formatting the column widths and saving the document. Other worksheets in the same workbook so far do not exhibit this behavior and are maintaining the desired column formatting (i.e., proper widths). I cannot figure out what is causing this unwanted formatting to happen and it has not happened before. I'm guessing this is an Excel issue, but might the SharePoint component be a factor as well? What are the potential causes of this, and what can I do to make the desired formatting remain and not revert back to the unwanted formatting? Thank you!MSO Files being randomly renamed while open on desktop
Not sure if anyone is facing this issue - but I have been facing this for 2 months now and it is really really frustating..! While working on Excel, Word or Powerpoint - a lot of times (very frequent now) the filename of the open file (on which we are working) suddenly gets saved as a random number (e.g. 12456.xlsx). If we aren't alert - if you close this file - "You lose the original file from the original location". Gone - absolutely disappears. I tried to do some research on the issue and found - Closing Excel App and reopening will give you the randomly named file in 'recent' list - however you can't open it. Checked the hidden folders and found same name file in '.temp.upload' folder, but without any .extension Renamed this file to .xslx and I got all my data back. However - if you do not rcover your file on same day there is a chance that you lose this file forever. I understand now by some online surfing that this is a Onedrive Sync issue. However, my broadband is super - checked the data throughput for the instance and it was continuous highspeed without any drops. This has become so frustrating now that I am thinking of moving out of MSO. It is very stressful and distracting now to be continuously alert and check the filename every few seconds. Does anyone else face this issue? Are there any solutions for this problem?
Sheet View Issues with Excel Web Browser
Hi, I have created a Excel document for my department to use, I tried Excel App but due to the size of the Spreadsheet it kept freezing, as a result I switched it to use Excel through Web Browser. The sheet no longer freezes which is good. I do have another issue though.....I wanted multiple users to be able to access, edit the sheet at the same time so I did some research and Sheet View seemed to be the way forward. I created a Sheet view for each employee to use so when you go to View, Sheet View and click on the relevant person their work is updated, saved etc and this shouldn't affect others view. This is working in terms of people editing. The main issue now though is that despite following advice sometimes when someone changes a filter on their own sheet view it seems to change others view. My understanding was you can hide, filter etc within your own Sheet view but this doesn't seem to be the case.......PLEASE HELP!!!! My excel and computer Skills aren't excellent to please any simple advise would be great.
Online Excel Version - Print Row Repeat/Print Titles
How do you set up the print row repeat or print titles option in the online version of Excel. I don't see these options available under Page Layout. Is there another location that this option is located or is this not available in the online version?ASAP utilities in power automate cloud flow
I have one server machine that installed ASAP Utilities for Excel. I want to eliminate individual server logins and allow users to run only 5 specific ASAP Excel plugin functions automatically, just by dropping an Excel file into a common server folder, so the backend processes it and returns the result—saving time. Will Office 365 excel with power automate cloud flow help? Thanks for you answers for my clarifications.
