Recent Discussions
how to ignore conditional formatting for a cell that is not empty but invisible (cell format ;;;)
hi, i need help with a conditional formatting of cells that are not empty but invisible (cell format to ;;; (invisible)). I have a calendar where the dates are invisible (outside of the month) but the cell formatting applies to it (cuz it is that date, i.e., public holiday). i have attached the screenshots and i hope someone can help me out. thank you so much. regards, angel
Add-in Excel Labs
Da tempo sto utilizzando l'add-in Excel Labs, soprattutto nelle sua funzionalità base di "Advanced formula environment" particolarmente utile nella compilazione di formule LAMBDA che stanno avendo un così grande sviluppo in questi ultimi tempi. La facilità nella redazione e nel debug inline delle formule, i commenti e la gestione delle stesse in "Gestione Nomi" ne ha fatto per me e penso per molti uno strumento eccellente che ovviamente non può essere paragonato all'edito base di Excel. Rivolgo perciò un invito a considerare possibile la sua implementazione direttamente in Excel come strumento alternativo all'editor di base . Ritengo che tutti potranno giovarne.
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?
Freezing multiple rows
I just need to freeze the top 3 rows in a spreadsheet. Easy: select the 4th row, click 'Freeze Panes' and choose the 'Freeze rows' option. Except that the option isn't there - the only option offered is to freeze the top row. I am using Office 365, so my Excel is a current version. And I am working in Normal View. So I don't understand why I cannot freeze multiple rows any more!
Word Help
My word application kept defaulting to an old version that is no longer active. With the help of one of your technician's, I was able to erase that and sign in to my microsoft word account. However, I cannot restore my dissertation document with all the formatting, charts, maps, etc. Thankfully I saved it on my OneDrive through my university, but when I try to download it back onto my computer, it scrubs all the formatting, charts, maps. I've tried to pull it off my icloud but it only has the scrubbed version. The technician suggested I post here to see if anyone can help me.Ruby text functionality/Publisher-like formatting
I use Publisher to create workbooks for students learning Japanese. Word is not a suitable replacement because it has ridiculous formatting issues. PowerPoint has better functionality because you can control placement of text and images and the pages are discrete. But there is no way to use Ruby text (phonetic guide) in PowerPoint. Can it be enabled in Powerpoint? I asked a support person and they told me to copy the sentence from Word to PowerPoint but that doesn't work. Alternatively, is there a way to make Word function like Publisher, so each page is a discrete entity and when I add something, it doesn't muck up the formatting on every other page or push things to another page?
Error del complemento. No pudimos conectarnos con el servidor de catalogo "{0}" para este documento
Estoy usando Word Online (Office 365) y al abrir complementos como Mendeley Cite aparece el error: “Error del complemento. No pudimos conectarnos con el servidor de catálogo {0} para este documento.” En general, este error aparece en todos los complementos existentes, como si en mi cuenta los mismos no estuvieran habilitados. Ya probé: Cambiar de navegador (Edge, Firefox, Google). Limpiar datos de navegación. Reiniciar sesión y el computador. Permitir cookies y permitir permisos de los navegadores Hasta ahora no hay forma de que los complementos funcionen en Word Online. ¿Alguien sabe cómo resolverlo? El flujo concreto es: Entro a un documento en word online -> oprimo el botón de complementos -> se abre la lista de complementos -> elijo cualquier complemento y me aparece el error del titulo de esta discusión. Hace una semana si me funcionó en edge, ahora no hay formas.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.
Equation editor renders properly on screen but does not print properly
For multiple people at my workplace, on both their home and work computers, Equation Editor expressions are often not printing properly, either to pdf or to physical printers. On screen, everything shows correctly. It's especially frustrating because equations are partially rendered -- cos x will be printed as co , a polynomial expression will be missing the last term, etc. -- which means that the errors don't jump out in a quick look at the printout or pdf. As far as we can tell, the longer you wait after opening the document in Word, the more renders properly, but there are no guarantees, and there are often a great many errors on a one- or two-page sheet with lots of formulas. I didn't see this problem before this last year or so. We are using version: Word for Microsoft 365 MSO (Version 2604 Build 16.0.19929.20164) 64-bitAvailability in MS Bookings not correct
In our bookings portal, we set-up a service with 2 staff assigned. The first staff memeber is available, the second one is on holiday (time off) We have made this set-up in the back-end. If there is a booking on that day already sheduledfor staff number one for let's say 10h, It will still show this time on the front. It looks like it doesn't count the time off from the second staff
User agent : ODMTADemand-Transform_Zip
Hello guys, I’m investigating a SharePoint/OneDrive alert and noticed the following user agent: """ODMTADemand-Transform_Zip""" I found information about OneDriveMpc-Transform_Zip/1.0 being related to ZIP downloads from SharePoint/OneDrive, but I can’t find anything specific about ODMTADemand-Transform_Zip. Does anyone know what this user agent is used for? Is it a legitimate Microsoft backend process, and is it related to ZIP generation/download operations in SharePoint or OneDrive?How to anonymise user file uploads in MS Forms
Hi, I've created a form to allow users to anonymously report IT incidents, but when someone uploads a file I'm getting an email from Sharepoint Online telling me the name of the user who's uploaded it. The red in the top right is the users name. The form itself doesn't tell me the username, that part of the anonymisation is working fine, it's just this bit related to file upload. This kind of defeats the point of allowing anonymous reporting, and whilst the users wouldn't know, it is a breach of trust when we're trying to create a positive attitude to security. Is there a way to turn this off?Google Workspace sender stuck at SCL=5 to all Microsoft-hosted recipients
Sending email from a new domain via Google Workspace. All mail to Microsoft-hosted recipients (both Outlook.com consumer accounts and Microsoft 365 Exchange Online tenants) is being routed to junk. Authentication passes perfectly on every message. This appears to be a domain reputation cold-start issue and I am looking for guidance on how to resolve it without waiting 2-4 weeks. Affected recipients are all Microsoft-hosted recipients tested (Outlook.com consumer + Microsoft 365 Exchange Online tenants). Please help me!!! Confirmed via X-MS-Exchange-Organization-SCL: 5 and delivery header dest:J;OFR:SpamFilterAuthJ;RF:JunkEmail on all test emails including ones with normal subject lines and body text. Content makes zero difference to the score. What has already been done: SPF hardened from ~all to -all DMARC upgraded from p=none to p=quarantine IP confirmed not listed on Microsoft's delist portal (sender.office.com) Domain confirmed not listed on Spamhaus DBL or SURBL Domain registered with Google Postmaster Tools JMRP enrollment attempted — not available to Google Workspace senders as SNDS requires IP ownership Outlook.com Postmaster support request submitted
Is XML in Power Query is broken on macOS
Hello, XML from Power Query seems to have broken after update (July 2nd 2026). I tried this on several Macs To recreate just create a new file. Power Query -> XML -> Choose any xml file For me it doesn’t work. It keeps loading endlessly Am I the only one? Is there a workaround? Thank you
OPENED FILE AND ALL CHARTS WERE MISSING
So, I have been using this spreadsheet since 2014 and have always upgraded it to stay current. I had a file in Jan 2024 that I added data to and saved. Last month (Apr), I opened the file to add new data as I always have, and all my charts were gone. I've searched and cannot fight how these charts were deleted. It was not me. I've looked for fixes and there is little to no similar issue to mine unless my search was weak. I'm looking for ideas, and while I am not a computer engineer, I know Excel and lots more. I already tried the options, checkmark solution. Thanks in advance charleyNot 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 appreciated
Stock Data Type - SPCX
I have spreadsheet that pulls Stock data and it has been working fine. Bought some SPCX shares and added SPCX to the Stock cell. Selecting Stock Data Type does NOT find SPCX in the list of shares. This is on the deaktop app. I tried this wth Excel Online and SPCX is found and works fine? I have also made sure the Desktop apps are all up to date. Any potential fixes out there?
Recent Blogs
- 6 MIN READExplore what's new for Agent 365 in June 2026.Jul 08, 2026
- Unlock financial intelligence from Xero directly in Copilot.Jul 08, 2026
