Planning to Migrate OST Files to Microsoft 365 - Need Some Guidance Before I Start
Hey folks, I have a task coming up where I need to migrate OST files into Office 365 mailboxes. A few of the OST files I'm dealing with are orphaned or corrupted which is making me a bit nervous about the whole process. A couple of things I'm unsure about: How to handle OST files that are no longer linked to an active profile Whether corrupted OST files can still be migrated to Office 365 without major data loss Best way to verify data integrity after migration Haven't started yet and want to make sure I'm going in the right direction before I begin. Has anyone migrated corrupted or orphaned OST files to Office 365? What approach worked best for you?
Retrieve all Teams transcripts a bot has attended to using Graph API
Hi there, I've been struggling for a lot of time trying to get this done. Has anyone been able to achieve something like this ? I wanted to : 1- Get all the meetings and transcripts of the tenant 2- Filter on those where the bot was attending 3- Get the transcripts when available. 4- Add rules to restrict the bot's access Right now I am stuck with the OAuth : The application 'bot-transcript' asked for scope 'OnlineMeetings.Read.All' that doesn't exist on the resource '00000003-0000-0000-c000-000000000000'. But this permission was added, and really seems to exist. Right ? Thanks in advance for any kind of help you could give me.
Microsoft 365 Apps SHOULD NOT overwrite Office 2019/2021 one-time retail installs
I want to raise a serious concern about Microsoft 365 Apps being imposed over existing Office 2019/2021 installations that were activated with legitimate one-time installation retail keys. In our case, these are not Microsoft 365 subscriptions and they are not licenses we can simply deactivate and reactivate freely. They are one-time installation retail keys. Once the product has been installed and activated, removing Office and reinstalling it later can make the original key unusable or trigger “already used” activation problems. That is precisely why the current behavior is so damaging. We have PCs with legitimate Office 2019/2021 installations. These machines did not request a migration to Microsoft 365 Apps. However, after internet connection, Office update activity, or Microsoft account interaction, Office appears to silently update, convert, or replace the existing retail installation with the Microsoft 365 Apps version. This is not a minor inconvenience. It creates a serious licensing and operational problem: -A valid one-time Office 2019/2021 installation is replaced by Microsoft 365 Apps without clear, explicit consent. -The original retail installation is no longer cleanly usable. -Fixing the issue requires uninstalling Office, removing Click-to-Run/licensing/account leftovers, and reinstalling the previous Office 2019/2021 version. -But because these keys are one-time installation keys, that reinstall process can render the original key unusable or create activation failures. -In practice, a forced Microsoft 365 conversion can destroy the value of a legitimate one-time Office license. From a user’s perspective, this looks less like a normal software update and more like an exploitative commercial strategy: using Microsoft’s control over Office updates, account sign-ins, Click-to-Run, and activation systems to push already-paid retail users toward Microsoft 365 subscriptions. Even if Microsoft does not intend that result, the practical effect is that users who already paid for Office 2019/2021 can lose practical access to their licensed product and are then nudged toward paying again through a subscription. This should not happen. A perpetual or one-time installation Office license and Microsoft 365 Apps are different products with different licensing models. Microsoft should not silently replace or convert one into the other because a Microsoft 365 account exists on the PC, because the user signs into Office, because OneDrive is present, or because Office updates are enabled. At minimum, Microsoft should provide: -A clear opt-in confirmation before replacing, converting, upgrading, or rebranding Office 2019/2021 retail installations as Microsoft 365 Apps. -A supported way to block Microsoft 365 Apps from taking over one-time installation Office versions. -A clean removal tool that fully removes Microsoft 365 Apps, Click-to-Run leftovers, licensing remnants, and account-based activation conflicts. -A reliable way to restore the original Office 2019/2021 retail installation without invalidating or losing the original one-time key. -Clear separation between Windows account sign-in, OneDrive sign-in, Microsoft 365 entitlement, and local Office retail activation. Users who purchased legitimate one-time installation Office licenses should not be forced into Microsoft 365 Apps by unclear update behavior. If Microsoft wants users to move to Microsoft 365, that should be a deliberate, informed choice — not a silent process that leaves the user cleaning up the installation and losing access to a paid retail license. I am not asking how to install Microsoft 365. I am asking Microsoft to stop Microsoft 365 Apps from taking over valid one-time Office 2019/2021 installations without explicit consent.Is using Planner for tracking OKRs a good idea?
So our team has been trying to use Planner to track OKRs. We set up buckets for each objective and tasks for key results. It kinda works for a small team but now that leadership wants to roll it out company wide, its getting messy. Theres no way to show progress rollups from team-level OKRs to company-level ones, no percentage tracking on key results, and managers cant see a consolidated view across teams. Has anyone found a decent way to make Planner work for OKR tracking at scale?
Not For Profit Licence suddenly disappeared and then deleted
Hi All Have a big issue. Have a not for profit account for our charity. Renewed licence earlier in the year and all was ok and working. Then a few days ago I had reports of not being able to access data. After much hunting I found the below. Seems account was suddenly and without warning disabled and then reported as deleted a few days later. What do I do? I desperately need to recover the files that were on the associated teams? Any help would be much appreciatedOneDrive sync causes workflow inefficiencies and UX issues in Microsoft 365 and File Explorer
I would like to describe some workflow issues caused by the current integration between OneDrive, Windows, File Explorer, and Microsoft 365 apps. I understand that OneDrive is designed to synchronize files across devices, but in some scenarios the current behavior creates unnecessary delays, especially with slow internet connections or large synchronization queues. 1. Exported Microsoft 365 files are not immediately available in the selected OneDrive folder When exporting a Microsoft 365 file, for example exporting a Word, Excel, or PowerPoint document to PDF, the user can select a OneDrive-synced folder as the destination. However, the exported file is not always immediately visible or accessible in that folder through Windows File Explorer. From the user’s perspective, it seems that the file is first saved into a temporary or internal Microsoft 365/OneDrive staging location, then uploaded to OneDrive, and only later appears in the actual synced folder through the normal synchronization process. The issue is not that the file is never stored locally, but that it is not immediately available in the location explicitly selected by the user. This creates practical problems. After exporting a PDF, I may need to quickly locate it in File Explorer to copy it elsewhere, attach it, upload it to another platform, or use it in a web tool to merge it with other PDFs. However, even though I selected a OneDrive folder as the destination, the file may not be available there right away. A related issue is that Microsoft 365 or Windows may open the exported file through a browser or web link instead of opening the local file directly. This can trigger login prompts, open the web version of Office, and interrupt the expected desktop workflow. Expected behavior: When saving or exporting a file to a OneDrive-synced folder, the file should become immediately visible and accessible in the selected folder in File Explorer, while OneDrive continues uploading or syncing it in the background. If the user selected a local OneDrive path, Microsoft 365 should prioritize the local file workflow and avoid redirecting to the browser unless explicitly requested. 2. File duplication inside OneDrive should use both cloud-side copy and local optimization Another issue occurs when duplicating or copying a file that is already stored in OneDrive, especially within the same OneDrive account. Currently, the process may behave like a traditional local copy: the file is downloaded if needed, copied locally, and then uploaded again as a new file. This is inefficient when OneDrive already has the source file in the cloud and the operation is simply a copy within the same account. Ideally, OneDrive should combine two optimizations: Perform a cloud-side copy when possible, so the duplicated file appears quickly in OneDrive online and on other devices. Reuse the local cache when available, so the current device does not unnecessarily download and re-upload the same data. This would make copied files appear faster on other devices as online-only placeholders, ready to be downloaded later if the user opens them or marks them as available offline. The other device should not have to wait for the first computer to download, copy, re-upload, and then synchronize the change. Expected behavior: When copying or duplicating a OneDrive file within the same account, OneDrive should use a cloud-side copy whenever possible, while also reusing local data when available. The copied file should appear quickly across devices as an online-available item, without forcing a redundant download, local copy, upload, and synchronization cycle. 3. OneDrive does not dynamically prioritize files the user needs immediately A third issue appears when OneDrive has a large backlog of pending synchronization changes, especially after using another computer. In this situation, OneDrive seems to follow its own synchronization order, even if the user opens a specific folder or tries to access a specific file urgently. For example, if there are hundreds or thousands of pending changes, and I need one specific document, that file may remain unavailable until OneDrive reaches it in the queue. Even when I navigate directly to the folder or attempt to open the file, OneDrive does not seem to move that item to the top of the sync priority. Expected behavior: OneDrive should dynamically adjust synchronization priority based on user activity. If the user opens a folder, selects a file, or attempts to open a cloud-only item, that file and its immediate dependencies should be prioritized over the general sync queue. Summary of requested improvements I believe these issues could be improved with smarter local and cloud prioritization: Exported or saved files should become immediately visible in the OneDrive folder selected by the user. Microsoft 365 should avoid opening exported files through a browser when the local file workflow is expected. Copying files within the same OneDrive account should use cloud-side copy operations when possible. Local file data should be reused to avoid unnecessary download and upload cycles. Copied files should appear quickly on other devices as online-available placeholders. OneDrive should prioritize files and folders the user is actively trying to access. Is this behavior expected, or are there settings to make OneDrive prioritize local file availability, cloud-side copy operations, and currently accessed files more intelligently?Can anyone help me with this SWITCH function
Hello Everyone, This SWITCH function is used to produce a number that then I can use to sort workers and their functions. =SWITCH(TRUE, IF(AND(ISNUMBER(J2)=TRUE,M2="Working")=TRUE,5,0), IF(AND(ISNUMBER(K2)=TRUE,M2="Working")=TRUE,500,0), IF(AND(ISNUMBER(J2)=TRUE,M2="Special Project")=TRUE,15,0), IF(AND(ISNUMBER(K2)=TRUE,M2="Special Project")=TRUE,515,0), IF(AND(ISNUMBER(J2)=TRUE,M2="Stand By")=TRUE,20,0), IF(AND(ISNUMBER(K2)=TRUE,M2="Stand By")=TRUE,520,0), IF(AND(ISNUMBER(J2)=TRUE,M2="Special Project UFN")=TRUE,25,0), IF(AND(ISNUMBER(K2)=TRUE,M2="Special Project UFN")=TRUE,525,0), 50 ) In Column J I have their Start Time, from the Kronos System, and in Column K I have their End Time. In Column M I have Tasks names that would indicate what each Team member is doing. Each component does evaluate correctly but the function always return 50? What am I missing here? Thanks in Advance! GiGiExcel Help
Is there a way (either formula or macro /something) for the following. I have 2 different spread sheets (files) open at the same time. First is called Time Card Second is called Wages Time Card will have a staff members details as well as dates and shift times. (20 Tabs for different staff members and their details) Wages will have Tab 1 - Summary of all staff names, hourly rates, hours worked for each day and gross amounts to be paid Tab 2 - 20 payslips with the above mentioned details, but payslip style. Lets call the first person Joe Deer I need something in Time Card next or close, to this person's name, when clicking it it will jump to his payslip in Wages sheet As mentioned. Formula or macro.. Guess anything will do. Thanks
