Microsoft 365 and Office

Hello,below is Microsoft official solution for Running/Cumulative sum.=SUM(B$2:B2)I am a tad concerned about the overall performance when large data comes to play.Do we know the Time Complexity factor of this implementation?Is it O(n) /i.e. linear/, or much worse?--Put another:How many additions does this implementation execute for 3 items in order to calculate the result?Please do NOT waste too much of your valuable time if you do not know the answer.

For last 3 years you are taking money out of my credit card which i have not authorised and im not aware of setti g anything up please can you share more details before i report it to the bank.

This applies to Outlook. What does this error message mean: "Internal MAPI error. An invalid parameter was passed to a MAPI function." I received the error message when I was transferring emails over from an SSD

Hi,I need to create a document template from scratch with all new formatting. Is there a best practise on the order or a list of what should be set before the template is being used?The list of formatting I can think of are:- file options - embedded font / image size and quality- Customized Font installation / Font color- paragraph settings - indents / spacing / tabs / breaks- create different styles for different content (heading #, body text, table content, etc)- default header / footer settings- table of content headings and styles- Margins - Top, Bottom, Left and Right- Page size / orien

I searched for information and found that Microsoft's official documentation states'Some customers who have rights to more recent versions of Office LTSC suites might want to continue using prior versions of those suites. This is permitted for Office LTSC under desktop application licenses and is known as a “downgrade right.” Customers may downgrade to earlier versions of the Office software products, but only to the same edition of software product for which their device is licensed. That is, a customer may not downgrade from Office LTSC Standard 2024 to Office Professional Plus 2019. ',

Hi,In one worksheet Excel is doing something strange. It is a simple sheet with just three columns of entries. When I sort by Column A alphabetically (A - Z), it does so for the first 100 or so rows but then starts again. Some entries start with numbers, but within both blocks (i.e., the first 100 or so and t

We are developing a custom PCF (PowerApps Component Framework) control to display reports in our model-driven app. However, while running the command to add references using pac pcf add-reference, we are encountering the following error: Sorry, the app encountered a non recoverable error and will need to terminate. The exception details have been captured and will be forwarded to the development team, if telemetry has been enabled. Session Id: fgdfg6dd-afdg6-4ddfgf-dfgbb-421e74dfgf84a, Exception Type: System.Xml.XmlException

Hi,Just recently had this problem where my sticky notes are not showing on OneNote. I had both account and its on sync, but its not showing at all.* Moved from Community Center

Can I exclude one keyword (keyword is current SharePoint site name) on the DLP policy execution of the current SharePoint site and run DLP for all other SharePoint sites dynamically. For example, if one of the SharePoint site names is 'test' then keyword will be 'test'. So DLP policy should exclude test keyword for test site and check for that keyword and lock the documents on other SharePoint sites and vice versa. Is it feasible?

I would like to pay for my Office 365 Subscription on a monthly base instead of annually? How can I get back to that payment method?

[Inquiry About Temporarily Suspending a Microsoft 365 License (Annual Subscription)]Dear Microsoft Support,I hope this message finds you well.We currently have an annual Microsoft 365 subscription for our organization, and we would like to inquire whether it is possible to temporarily suspend or deactivate a user license without cancelling the entire subscription.We understand that the annual plan is prepaid for the year, but we are wondering if there are any options available for pausing or reassigning licenses during periods of non-use, in a way that might impact billing or allow us to manag

trying to click buy now, Microsoft 365 family. the next screen when choosing payment the screen flickers then shows "something went wrong on out side"

Excel and Word keep displaying a banner when I open a file "BACKUP THIS DOCUMENT - Access this file anywhere with OneDrive included in your subscription"I have a backup system I use that I like and I don't need OneDrive to backup my files. How do I get OneDrive/Office 365/Windows to stop giving me this prompt?I click the "X" or Schedule Backup Later to make the banner go away, but it just comes back a little while later. I've opened up the OneDrive app from the system tray and unselected everything from the OneDrive backup, but none of this helps and the prompt keeps coming back.How do I get t

My “zoom slider” has stuck at 45%. How do I fix this?

Hello,I'm reaching out regarding ongoing SharePoint access issues for a user whose account was previously deleted and later recreated.The user's original account was deleted. A few months later, a new account was created for the same user using the same User Principal Name (UPN). We encountered issues sharing a SharePoint folder with this user. We utilized the "Site User ID Mismatch" diagnostic tool as outlined in the following Microsoft documentation: https://learn.microsoft.com/en-us/sharepoint/troubleshoot/sharing-and-permissions/fix-site-user-id-mismatch.The diagnostic resolved the issue f

During September 2025, we will remove support for Basic auth with the Client Submission (SMTP AUTH) endpoints:smtp.office365.com smtp-legacy.office365.com Once Basic auth is permanently disabled, any clients or apps connecting using Basic auth with Client Submission (SMTP AUTH) will receive this response:550 5.7.30 Basic authentication is not supported for Client Submission.What do I need to do if I can use OAuth with Client Submission (SMTP AUTH)?If your client supports OAuth, follow these steps:Authenticate an IMAP, POP or SMTP connection using OAuthBecause of the above reasons, I have

Hi,We need help to make Publisher as Verified for an entra app. Situation is:1. We have an tenant say - *** Email address is removed for privacy ***. We work for an org - pqr.com3. We have created an Application which needs MS graph api permissions to read and write mails in entra.microsoft.com. 4. We have created an addin which uses this App in step 3. However on grant permission screen the application is shown as unverified. 5. How can we make this as verified. Kindly provide detailed steps.Regards,Kanhaiya

Hi Everyone,All the sharepoint site in my org dont have global navigation button when i check in settings is there any other way we can enable global navigation for home site

Hello,I found this thread form 2019 and have the same issue... why is this happening and what can we do, as it is obviously now 6 years later and the release should have already happened.thank you!https://answers.microsoft.com/en-us/msoffice/forum/all/document-library-approval-status-column-blank-not/2bea9ab0-ca92-46dc-b0f3-5f757d496b80?page=4

hi, I am creating a sharepoint and in order to make some changes, I need to use scripts, but this requires admin access, which I currently do not have. I would like to know how I can switch to an admin account for SharePoint.