Help with SharePoint connection issues
Hello, Quite suddenly, and now frequently, our spreadsheets on SharePoint are having difficulty saving. This was only a rare occurrence previously, but now happens to us regularly. It is so bad that we will have to stop using SharePoint if we can't figure out why it is doing this. Can anyone provide some advice as to what could be going on? We get errors saying we can't connect to the server and that it could be our internet connection. I highly doubt it's our internet connection as it is happening on many different connections all of which don't have problems connecting to other things. Do we have too much saved on our SharePoint perhaps?
Mac - Outlook : Attaching files, showing Date Added, not Date Modified!
Dear Techcommunity.Microsoft, Had to get a new MacBook Pro (OS Monterey 12.2.1), and up-to-date Microsoft. When I go to attach a file (in Outlook for Mac version 16.59), it shows the files with "Date Added" rather than "Date Modified". I don't care 'when' I created them, I just want to know I am attaching the correct one, I.E. the one I probably had just finished working on. In Finder, the files DO show "Date Modified". I'm sure it's probably something simple - but I have no idea. Please be gentle, e.g. 1, 2, 3 type instructions - I'm no techie! Do hope someone can help. Best wishes, Pippa60
Viva Engage praise functionality
Is there any way to add praise badges directly in a Viva community? I am wanting to add praise relating to our company values, so I would ideally like to add custom badges for team members to select when praising someone. I am aware that in teams you can add a badge with praise, however, I can't see if you can customise these badges and also use them directly in Viva communities Thanks in advance
Forwarding email if the aimed adress doesnt exist?
Hi, I have setted my own domain in Entra. Is it possible to forward emails, which are sended to a none existing adress of my domain to a existing one? For example, an email send to ajnsfvfxdcb@mydomain (doesnt exist) should be forwarded to email_grabber@mydomain (does exist). Is it possible to handle this? Maybe there is another way to work around? Greetz, TomekOpening PDF documents in Adobe Reader as default when in SharePoint
I'm after some advise please... I'm aware you can open the Microsoft applications (Word, Excel etc) in App by default in SharePoint, but is there a way you can set PDFs to open in Adobe Reader as default? We have a user who has accessibility requirements and need be able to use the read out aloud function in Adobe Reader on these documents.Issue with Listing Tasks from Planner Premium in Power Automate
Hello, I have created both Standard Planner and Planner Premium. When using Power Automate to list tasks, it only retrieves tasks from Standard Planner but not from Planner Premium. I tried using the Microsoft Graph API /planner/plans/{planId}/tasks, but it does not return tasks from Planner Premium. I also checked app permissions in Azure AD and tested the API in Postman and Power Automate, but it still does not work. These methods have been either too complex or have not given any results. Is there any alternative way to list tasks from Planner Premium? Any advice would be greatly appreciated. Thanks
Office Online Server | WinServer 2022 = Unhealthy
Hello, I have to install on new server windows (2022 .net 4.8) Office Online Server but after installation and farm setup the status is unhealthy (i added certificate to IIS and it is reachable from sharepoint front server): Office Online Server (KB5002627) ver 16.0.10416.20047 OfficeWebAppsMachine | Format-List * MasterMachineName : X-OOS01 MachineName : X-OOS01 Roles : {All} HealthStatus : Unhealthy Farm Setup: PS C:\Windows\system32> Get-OfficeWebAppsFarm | fl FarmOU : InternalURL : https://oos.mydomain.local/ ExternalURL : https://oos.mydomain.local/ AllowHTTP : True AllowOutboundHttp : False SSLOffloaded : True CertificateName : MY COMMENT: << HERE I DONT HAVE IT BUT IN ANOTHERS FARMS Office Server work with the same config; cert is in IIS >> S2SCertificateName : EditingEnabled : True LogLocation : C:\ProgramData\Microsoft\OfficeWebApps\Data\Logs\ULS LogRetentionInDays : 7 LogVerbosity : Proxy : CacheLocation : C:\ProgramData\Microsoft\OfficeWebApps\Working\d MaxMemoryCacheSizeInMB : 75 DocumentInfoCacheSize : 5000 CacheSizeInGB : 15 ClipartEnabled : False OnlinePictureEnabled : False OnlineVideoEnabled : False MorphEnabled : True TranslationEnabled : False MaxTranslationCharacterCount : 125000 TranslationServiceAppId : TranslationServiceAddress : RenderingLocalCacheLocation : C:\ProgramData\Microsoft\OfficeWebApps\Working\waccache RecycleActiveProcessCount : 5 AllowCEIP : False OfficeAddinEnabled : False ExcelRequestDurationMax : 300 ExcelSessionTimeout : 450 ExcelWorkbookSizeMax : 30 ExcelPrivateBytesMax : -1 ExcelConnectionLifetime : 1800 ExcelExternalDataCacheLifetime : 300 ExcelAllowExternalData : True ExcelUseEffectiveUserName : False ExcelWarnOnDataRefresh : True ExcelUdfsAllowed : False ExcelMemoryCacheThreshold : 85 ExcelUnusedObjectAgeMax : -1 ExcelCachingUnusedFiles : True ExcelAbortOnRefreshOnOpenFail : True ExcelEnableCrossForestKerberosAuthentication : False ExcelAutomaticVolatileFunctionCacheLifeTime : 300 ExcelConcurrentDataRequestsPerSessionMax : 5 ExcelDefaultWorkbookCalcMode : File ExcelRestExternalDataEnabled : True ExcelChartAndImageSizeMax : 1 OpenFromUrlEnabled : False OpenFromUncEnabled : True OpenFromUrlIntranetIpEnabled : True OpenFromUrlThrottlingEnabled : True PicturePasteDisabled : True RemovePersonalInformationFromLogs : False AllowHttpSecureStoreConnections : False Machines : {X-OOS01} I found in OOO uls logs problem with watchdog agent, could someone help me with that? 2025-02-28 14:22:15.93 AgentManagerWatchdog.exe (0x1DF8) 0x2620 Hosted Services Infrastructure Service Manager Watchdog afk5i Medium Setting Machine health to Unhealthy since there were no reports for this watchdog - DocumentSessionServiceWatchdog 15fb996f-6bcd-4abc-848e-77f99db96606 2025-02-28 14:22:15.93 AgentManagerWatchdog.exe (0x1DF8) 0x2620 Hosted Services Infrastructure Service Manager Watchdog afk5i Medium Setting Machine health to Unhealthy since there were no reports for this watchdog - WebWordEditorSaveServiceWatchdog 15fb996f-6bcd-4abc-848e-77f99db96606 2025-02-28 14:22:15.93 AgentManagerWatchdog.exe (0x1DF8) 0x2620 Hosted Services Infrastructure Service Manager Watchdog afk5i Medium Setting Machine health to Unhealthy since there were no reports for this watchdog - BroadcastServicesWatchdog_App 15fb996f-6bcd-4abc-848e-77f99db96606 2025-02-28 14:22:15.93 AgentManagerWatchdog.exe (0x1DF8) 0x2620 Hosted Services Infrastructure Service Manager Watchdog afk5i Medium Setting Machine health to Unhealthy since there were no reports for this watchdog - BroadcastServicesWatchdog_Wfe 15fb996f-6bcd-4abc-848e-77f99db96606 2025-02-28 14:22:15.93 AgentManagerWatchdog.exe (0x1DF8) 0x2620 Hosted Services Infrastructure Service Manager Watchdog afk5i Medium Setting Machine health to Unhealthy since there were no reports for this watchdog - DiskCacheWatchdog 15fb996f-6bcd-4abc-848e-77f99db96606 2025-02-28 14:22:15.93 AgentManagerWatchdog.exe (0x1DF8) 0x2620 Hosted Services Infrastructure Service Manager Watchdog afk5i Medium Setting Machine health to Unhealthy since there were no reports for this watchdog - ExcelServicesEcsWatchdog 15fb996f-6bcd-4abc-848e-77f99db96606 2025-02-28 14:22:15.93 AgentManagerWatchdog.exe (0x1DF8) 0x2620 Hosted Services Infrastructure Service Manager Watchdog afk5i Medium Setting Machine health to Unhealthy since there were no reports for this watchdog - ExcelServicesWfeWatchdog 15fb996f-6bcd-4abc-848e-77f99db96606 2025-02-28 14:22:15.93 AgentManagerWatchdog.exe (0x1DF8) 0x2620 Hosted Services Infrastructure Service Manager Watchdog afk5i Medium Setting Machine health to Unhealthy since there were no reports for this watchdog - FarmStateManagerWatchdog 15fb996f-6bcd-4abc-848e-77f99db96606 2025-02-28 14:22:15.93 AgentManagerWatchdog.exe (0x1DF8) 0x2620 Hosted Services Infrastructure Service Manager Watchdog afk5i Medium Setting Machine health to Unhealthy since there were no reports for this watchdog - HostingServiceWatchdog 15fb996f-6bcd-4abc-848e-77f99db96606 2025-02-28 14:22:15.93 AgentManagerWatchdog.exe (0x1DF8) 0x2620 Hosted Services Infrastructure Service Manager Watchdog afk5i Medium Setting Machine health to Unhealthy since there were no reports for this watchdog - ImagingWatchdog 15fb996f-6bcd-4abc-848e-77f99db96606 2025-02-28 14:22:15.93 AgentManagerWatchdog.exe (0x1DF8) 0x2620 Hosted Services Infrastructure Service Manager Watchdog afk5i Medium Setting Machine health to Unhealthy since there were no reports for this watchdog - PowerPointEditingServicesWatchdog_App 15fb996f-6bcd-4abc-848e-77f99db96606 2025-02-28 14:22:15.93 AgentManagerWatchdog.exe (0x1DF8) 0x2620 Hosted Services Infrastructure Service Manager Watchdog afk5i Medium Setting Machine health to Unhealthy since there were no reports for this watchdog - PowerPointViewingServicesWatchdog_App 15fb996f-6bcd-4abc-848e-77f99db96606 2025-02-28 14:22:15.93 AgentManagerWatchdog.exe (0x1DF8) 0x2620 Hosted Services Infrastructure Service Manager Watchdog afk5i Medium Setting Machine health to Unhealthy since there were no reports for this watchdog - PowerPointViewingServicesWatchdog_Web 15fb996f-6bcd-4abc-848e-77f99db96606 2025-02-28 14:22:15.93 AgentManagerWatchdog.exe (0x1DF8) 0x2620 Hosted Services Infrastructure Service Manager Watchdog afk5i Medium Setting Machine health to Unhealthy since there were no reports for this watchdog - ProofingWatchdog 15fb996f-6bcd-4abc-848e-77f99db96606 2025-02-28 14:22:15.93 AgentManagerWatchdog.exe (0x1DF8) 0x2620 Hosted Services Infrastructure Service Manager Watchdog afk5i Medium Setting Machine health to Unhealthy since there were no reports for this watchdog - Rtc2Watchdog 15fb996f-6bcd-4abc-848e-77f99db96606 2025-02-28 14:22:15.93 AgentManagerWatchdog.exe (0x1DF8) 0x2620 Hosted Services Infrastructure Service Manager Watchdog ailr1 Medium Health status for UlsControllerWatchdog, Category = 10001, Status Properties: UlsControllerWatchdog(10001): Health: Okay, Last Update: 02/28/2025 14:22:09, Previous Health = , Last Transition Time: 02/28/2025 14:22:09, Last persistent health: Okay, Last persistent update: 01/01/0001 00:00:00, Last Message = "HealthReportingAdapter received 1 report(s) from UlsControllerWatchdog successfully." 15fb996f-6bcd-4abc-848e-77f99db96606 2025-02-28 14:22:15.93 AgentManagerWatchdog.exe (0x1DF8) 0x2620 Hosted Services Infrastructure Service Manager Watchdog afk5i Medium Setting Machine health to Unhealthy since there were no reports for this watchdog - UlsFileWriterWatchdog 15fb996f-6bcd-4abc-848e-77f99db96606 2025-02-28 14:22:15.93 AgentManagerWatchdog.exe (0x1DF8) 0x2620 Hosted Services Infrastructure Service Manager Watchdog afk5i Medium Setting Machine health to Unhealthy since there were no reports for this watchdog - WebOneNoteWatchdog 15fb996f-6bcd-4abc-848e-77f99db96606 2025-02-28 14:22:15.93 AgentManagerWatchdog.exe (0x1DF8) 0x2620 Hosted Services Infrastructure Service Manager Watchdog afk5i Medium Setting Machine health to Unhealthy since there were no reports for this watchdog - WebWordEditorWatchdog 15fb996f-6bcd-4abc-848e-77f99db96606 2025-02-28 14:22:15.93 AgentManagerWatchdog.exe (0x1DF8) 0x2620 Hosted Services Infrastructure Service Manager Watchdog ailr1 Medium Health status for WordDocumentSessionServiceWatchdog, Category = 10001, Status Properties: WordDocumentSessionServiceWatchdog(10001): Health: Okay, Last Update: 02/28/2025 14:22:09, Previous Health = , Last Transition Time: 02/28/2025 14:22:09, Last persistent health: Okay, Last persistent update: 01/01/0001 00:00:00, Last Message = "HealthReportingAdapter received 2 report(s) from WordDocumentSessionServiceWatchdog successfully." 15fb996f-6bcd-4abc-848e-77f99db96606 2025-02-28 14:22:15.93 AgentManagerWatchdog.exe (0x1DF8) 0x2620 Hosted Services Infrastructure Service Manager Watchdog afk5i Medium Setting Machine health to Unhealthy since there were no reports for this watchdog - WordViewerWfeWatchdog 15fb996f-6bcd-4abc-848e-77f99db96606 2025-02-28 14:22:15.93 AgentManagerWatchdog.exe (0x1DF8) 0x2620 Hosted Services Infrastructure Service Manager Watchdog afk5i Medium Setting Machine health to Unhealthy since there were no reports for this watchdog - WordViewerAppManagerWatchdog 15fb996f-6bcd-4abc-848e-77f99db96606 2025-02-28 14:22:15.93 AgentManagerWatchdog.exe (0x1DF8) 0x2620 Hosted Services Infrastructure Service Manager Watchdog ag9ct Medium Because WordDocumentSessionService is unhealthy, the machine is unhealthy. 15fb996f-6bcd-4abc-848e-77f99db96606 2025-02-28 14:22:15.93 AgentManagerWatchdog.exe (0x1DF8) 0x2620 Hosted Services Infrastructure Service Manager Watchdog ag9ct Medium Because Imaging is unhealthy, the machine is unhealthy. 15fb996f-6bcd-4abc-848e-77f99db96606 2025-02-28 14:22:15.93 AgentManagerWatchdog.exe (0x1DF8) 0x2620 Hosted Services Infrastructure Service Manager Watchdog ag9ct Medium Because UlsFileWriter is unhealthy, the machine is unhealthy. 15fb996f-6bcd-4abc-848e-77f99db96606
not pulling all numbers
So I've managed to get my formula working, I'm using =SUMPRODUCT(SUMIF(Monday!A17:A40,H19,Monday!E17:E40)+SUMIF(Tuesday!A17:A38,H19,Tuesday!E17:E38)+SUMIF(Wednesday!A17:A41,H19,Wednesday!E17:E41)+SUMIF(Thursday!A17:A33,H19,Thursday!E17:E33)) but for some reason, it's not pulling all the numbers (E17:E40) that correspond with the names (A17:A40). what am I doing wrong?Issue with listing tasks from planner premium in power automate
Hello, I have created both standard planner and premium planner. When using power automate to list tasks, it only retrieves tasks from standard planner but not from planner premium. I try using the MS Graph API, but it doesn't return tasks from planner premium. I also checked app permission in Azure AD and tested the API in postmen, but it does not work. And these method have been either too complex or have not given any results. Is there any alternative way ? Please give me some advice. ThanksIssue with Listing Tasks from Planner Premium in Power Automate
I have created both Standard Planner and Planner Premium. When using Power Automate to list tasks, it only retrieves tasks from Standard Planner but not from Planner Premium. I tried using the Microsoft Graph API /planner/plans/{planId}/tasks, but it does not return tasks from Planner Premium. I also checked app permissions in Azure AD and tested the API in Postman and Power Automate, but it still does not work. These methods have been either too complex or have not given any results. Is there any alternative way to list tasks from Planner Premium? Any advice would be greatly appreciated. Thank you