网赌被黑怎么办 有办法挽救吗？
（wx:RYG622）（QQ：157764444）（飞机@lmg567）先出款，后收费! I have a macro that I've written to "reformat" some data in Excel (not font types and colors and such, but how the data is laid out in the spreadsheet). I found a macro that records how long it takes a macro to run, and that macro consistently runs for about 30 seconds. The problem is that the reason I'm reformatting the data is to import into Access, and I don't want my users to have to have intimate knowledge of Access or Excel to reformat the data and import it into the Access database. Thus, I've created a form with a button that allows the user to select a file from a dialog box, and then the macro runs on that file. Ad for some reason, when done this way, the macro takes upwards of 6 minutes. I don't know if it would be helpful to post the code of the macro here, or if there's some generic advice that will help. I just can't imagine why this increase in run-time is happening.Microsoft Places Analytics - Missing data
Hi! I'm looking to hear if anyone has succesfully configured Microsoft Places Analytics according to the guidelines here: Microsoft Places Analytics - Microsoft Places | Microsoft Learn I've reached out to Microsoft Support several months ago regarding this but the case has not progressed at all unfortunately when it comes to actually reaching a solution. I'm struggling to get enough data to show even though the following is OK: All buildings have analytics enabled The name of the building matches the attribute "Office Location" in Entra ID. A mail-enabled security group is used for assigning permissions to Places Analytics (as-per the requirements). All users of the above group have Teams Premium I'm mostly focusing on the building analytics here since that one is most interesting for us. Example of charts with missing or incomplete data: The above one shows nothing even though it should be fetched from the work location in conjuction with the leader's organisation data. In the above chart it's succesfully mapping the headcount of the number of people that have set their work plan with a chosen building, however it's completely ignoring the "remote" parts. Also ignoring the people that have no work plan set but do have the same Office location as the building name - which it should fetch from according to the "?" button: It's even more clear further down in the same "?": In my case it's ONLY showing the ones with a work plan set and with the actual building in question set. It's the same type of issue for most of the data but I believe that solving it on one end will solve the rest. So I'm really hoping there's someone else out there that has succesfully configured Places Analytics and might shed some light on what my configuration might be missing. Thanks!
Microsoft 365 Apps Admin Center - Inventory Error
We're running into issues trying to access Inventory in the 365 Apps Admin Center (https://config.office.com/). When trying to swap a specific group of devices to a different update channel (Current to Monthly Enterprise), we go into the Apps Admin Center, select inventory and receive a generic error: There was a problem showing the security update status information. Please refresh the page or try again later. 00000000-0000-0000-0000-000000000000 This has been happening for 3 days now. Was working fine prior to that (and were able to flip a few devices earlier in the week). Anyone else experiencing the same/similar issues? Multiple 365 Admin's within our organization are getting the same error, so it's not isolated to 1 person/1 account.Microsoft 365 Apps Admin Center - Inventory Errors Out
Been running into issues the last few days as I try to swap a handful of devices to a different update channel. I'm able to browse to the Microsoft 365 Apps Admin Center (https://config.office.com/), however when I go to Inventory it throws a generic error (it's been happening for 3 days now): There was a problem showing the security update status information. Please refresh the page or try again later. 00000000-0000-0000-0000-000000000000 This was working earlier this week (Tuesday 5/13/25) but as of Wednesday it was "broken". Checking to see if other folks are running into this or if we're just the lucky ducks. Several of us within the organization have run into the same error so it's not isolated to any one individual.Adding data ONLY when two cells match across sheets...
Hi all, Apologies: this is complicated... I'm working across x2 sheets in an Excel book. On sheet 2, I have my export page, where I paste the uploaded data for it to fill in sheet 1. On sheet 1, I have the historical data which I need to add to weekly. Sheet 2: Export Page including current formula (based on a working formula on another sheet we use. I need both forename and surname to match on the next page, and automatically paste columns C and D if/when/where they do, then tell me where any names have been missed (new students, etc.) so I can add them to the doc. So if A2 and B2 were on A6 and B6 on sheet 1, that is where the data (C2 and D2) would be pasted, to ensure that the student retains their own points balances. Sheet 1: Overview Page - I intend on the above columns C and D then being put into columns J and K on this page. I'll then just copy and paste the data across into the correct week following analysis, ready for the formula to re-populate those cells with the coming week's data. I switched forename and surname around for readability but can return if that makes it easier (for GDPR purposes, I have removed all names). The formula there had green "Yes"s through the page when I used the original data. When I have gone to update today, everything is a red "No", as you can see, so I clearly don't have the right formulas!! Appreciate your help, as I've been working on this for a couple of weeks now and just can't figure it out!! The formula on the other sheet that I was trying to work from was: =IF(COUNTIF(Table1[@[Name and tutor]],A2)=1,"Y","N")Visual and dax level optimization that causes report slowdown
Hi, I have this visual as attached, that has lot of visual level filters applied it has a dax measure called data completeness as below Data Completeness = var _total = COUNT('Calendar'[Date])*COUNT(Points[DBName-Point_Id]) var _result = [Count of Exisitng Days]/_total return _result It references a dax called Count of Exisitng Days as below Count of Exisitng Days = Var dates = SUMMARIZE(Data, Data[DBName-Point_Id], Data[Date]) Var Ext_dates = COUNTROWS(dates) return Ext_dates Now, the problem I have here is the performance of this visual is causing report to slow down. Please let me know how to optimize the dax and further steps to increase the performance PFA file here PR-419 - Data Coverage - Copy.pbix Thanks in advance! SergeiBaklan
Conditional Formatting - Need Formula Help
Hi, I am putting together a report for my supervisor regarding our tenant and vendors insurance requirement compliance status. He wants me to pull the data from the website monthly and highlight all of the non-compliant vendors so that the property managers can clearly see who they need to reach out to. I know I could do this by using data filters, but I think conditional formatting might be a little quicker if it's possible. I've attached a picture here of what I am working with but without our company specific information. Is there a rule formula I could use basically saying that if a cell in column C says vendors, and the cell in column D of that same row says Non-Compliant, then all 4 cells in the row will be highlighted when I format that way? Thank you to anyone who can help!
Microsoft 365 & Windows 365 Outage - 2 Weeks
Our company's Microsoft 365 (including email) and Windows 365 licenses have been completely disabled for two weeks. This is severely impacting our business: clients can't email us, we can't send emails, and access to critical data on our virtual desktops is lost. We've contacted Microsoft multiple times with no resolution. This prolonged outage is causing significant operational paralysis and forcing data recreation. We urgently need assistance in understanding the cause and a swift resolution to restore our services. We have tried reactivating, and have attempted getting through a Microsoft partner, but nothing has helped. Any advice on escalating this critical issue would be greatly appreciated.
