Recent Discussions
Microsoft’s Push to Save Office Files in the Cloud
A new policy setting is available to force Microsoft 365 enterprise (Office subscription) applications to save to cloud locations and ignore the local disk. The idea is to increase cloud usage and improve compliance by storing all Office files in OneDrive for Business or SharePoint Online. Like a network PC, creating a dependency on a network connection only makes sense when a network connection is dependable, which might not always be the case. https://office365itpros.com/2025/09/09/save-to-cloud-locations/2Views0likes0CommentsSUMIFS function won't give me a sum for 1 text criteria and date range
I have been trying to create a formula that will pull the sum of my various expenses/income according to the their category and within a month's range. Here is the formula I wrote: =SUMIFS('Transactions'!E:E,'Transactions'!C:C,'Gifts','Transactions'!A:A,'>='&'1'!G2,'Transactions'!A:A,'<='&'1'!H2) I want the sum to populate on the sheet named '1' and I'm having it pull the info from the sheet named 'Transactions,' which has a masterlist of all my transactions for the year (both income and expense) which includes the columns date, paymentmethod, type, description, and amount. I have data validated date, paymentmethod, type, and amount. Column E is amount, C is type (which includes 'Gifts'), and A is date. G2 and H2 are start date and end date which I typed out as 1/1/25 and 1/31/25. They are formatted as dates and data validated. Every time I press enter on this it just shows what I typed with red dotted lines around it. Other basic functions work (e.g. sum) but this one won't. Any idea how I can get this to work?27Views0likes1CommentPDF figures inserted in Word exhibit black background
I am using Word for Mac to prepare a manuscript. I inserted a PDF figure with transparent background, which was created with Adobe Illustrator. It looks fine on my Mac. But when I transfer the document to a Windows computer, the transparent background of the figure becomes black. For other Office softwares, such as PowerPoint, similar issues also happen. I know if I convert the figure to png format would fix the issue. But I still want to stick on the PDF format since it's vector image and compatible with LaTeX. Can you figure out why is this happening and how to fix it? Thanks!!13Views0likes1CommentClash analysis for manufacturing hall
Hi all, I'm trying to build an excel sheet that has 3 "manufacturing bays" and when I list a move date & location against a piece of plate, that it moves a cell and recreates that live picture in that build hall. Initially I was trying to use some of the functionality in the (board game) Battleship excel templates to see if writing a VBA would allow for this/ linking it to a button. Something like the below: I then want it to highlight if two plates are likely to be moved into the same space at the same time as part of the clash analysis. Does anyone know if it's possible to build this level of functionality into excel through VBA etc34Views0likes1CommentAuto save is not enabled prompt every time.
In word when I open documents there is a yellow bar telling me autosave is not enabled. I know, I am a grown adult and chose not to have auto save. How can I stop this annoying yellow bar? Whilst we are at it, how can I stop excel from telling my my work book might be slow on every workbook I open? Who in the coding department thinks this is helpful?37Views0likes1Commentcopy day name by value only from cell containing =today() function
is this any way to copy day name (text only) only from cell containing =today() function i set A1=TODAY() and i set format to dddd so the today name is displayed i want to set A2 cell to be set to the day name as text to use it in conditional format using day names ? any help ???19Views0likes1CommentError VBE6EXT.OLB
HolaWindows 10 home compilación 19045.5854, excel hoy presentó el error que no podía cargar "VBE6EXT.OLB" y si pincho en aceptar indica memoria insuficiente, también con un botón de aceptar. Intenté reparar la instalación (fuera de línea como a través de internet). Desinstalé y volví a instalar Microsoft 365. El problema persiste. Mi sistema tiene 32 GB, y funciona bien bajo carga, por lo que no es problema de memoria. Otras soluciones de internet que intenté fue limpiar la caché de excel y volver a registrar el archivo VBE6EXT.OLB, pero el problema persiste. ¿hay alguna otra forma de resolver la situación? Gracias. Daniel Castañeda AbarcaSolved154Views0likes2CommentsHow to fix "upload pending" error message in Microsoft word
I dealt with this frustrating issue for over a year, but here's how you can fix it. Example image: How to fix: 1. Make sure Finder is open and all office apps are closed, including Microsoft Word. 2. Click on "GO" in the top bar. 3. Once the drop down menu descends, hold down the OPTION key on your keyboard. You'll see that a folder called "LIBRARY" appears. Click on "LIBRARY". 4. Once inside "LIBRARY", click on a folder called "CONTAINERS." 5. Scroll down until you find a folder called "com.microsoft.Word". 6. Once you've found it, delete "com.microsoft.Word" off your computer. 7. Now, reopen Microsoft Word, and make sure the upload pending error message is gone. It should be, and you should now be able to delete the file if you so choose. Also, if you're experiencing this problem with Excel and/or Powerpoint, you can probably fix it the same way. You'd just have to delete "com.microsoft.Excel" and/or "com.microsoft.Powerpoint" respectively, instead of "com.microsoft.Word". All the steps leading up to that would remain the same. I really hope this helps other people who are dealing with this problem. And if for some reason it doesn't work for you, reach out to Microsoft support while signed into your Microsoft account and get into a chat room. Chatting with a specialist was the only reason I was able to figure this out in the first place.30KViews0likes2CommentsExcel - Matching outgoing to incoming inventory based a specific conditions
Hello, I wonder if anyone here can help me. I have created an inventory tracking file in excel but I have encountered a difficulty that I cannot seem to find an answer for. I have sequenced each incoming shipment but I am unable to sequence or match or track outgoing shipments automatically based on specific conditions: I need to assign #1 to outgoing shipments until outgoing piece count of 25 is reached, then #2 until 20 is reached and so on When incoming and outgoing piece count net out to 0, I need the status to be "Closed", when we've started pulling from but not emptied out yet, "In progress", and when untouched "Open" I would like outgoing to be link to earliest, not closed, incoming shipment. Of concern: "Out" and "Status" columns Can anyone help with this? Thank you! Christine124Views0likes5CommentsValidação de Dados: como evitar que Ctrl+V contorne as regras?
Olá a todos, Gostaria de partilhar uma situação com a comunidade para perceber se existe alguma solução ou truque menos conhecido. (sem macros) Estou a utilizar a funcionalidade de Validação de Dados no Excel para restringir a introdução de valores num determinado intervalo (exemplo, apenas números inteiros entre 1 e 5). Quando os utilizadores introduzem os dados manualmente, a validação funciona corretamente e impede entradas inválidas. Contudo, se os utilizadores fizerem Ctrl+V (colar) seja de outra folha, do mesmo ficheiro ou até de outro ficheiro o Excel ignora completamente a validação de dados e aceita os valores, mesmo que não cumpram os critérios definidos. Já experimentei as seguintes alternativas: Proteção da folha → não impede colagens. Formatação condicional → apenas assinala visualmente, não bloqueia. Listas suspensas com validação → também são ignoradas em colagens. Sei que através de VBA é possível detetar e anular colagens, mas a minha questão é a seguinte: Existe alguma forma de impedir a colagem (Ctrl+V) num intervalo com validação de dados, sem recorrer a VBA? Agradeço desde já qualquer partilha ou sugestão que me possa ajudar a contornar esta limitação. Se não existir uma forma de impedir esta situação sem recorrer a VBA, então considero que seria útil sugerir esta funcionalidade à Microsoft, para que a Validação de Dados pudesse ser respeitada também em colagens (Ctrl+V), tal como já acontece com a introdução manual. O que acham? Aguardo o vosso feedback e, caso já tenham passado por esta situação, seria muito útil conhecer a vossa experiência e forma de lidar com o tema.35Views0likes2CommentsOneNote vs. OneNote for Windows 10
I received an email this morning reminding me of the impending end of support for the OneNote for Windows 10 app. As I do periodically when I am reminded about this, I launched the OneNote on Windows (OneNote M365) app and lamented how much less user friendly it is than its doomed cousin. The lack of a "Recent Notes" view is my biggest gripe, but the awkward "pop-over" search comes a close second. The tabs and search result are on an ugly grey background and everything is just slightly too small to read comfortably. Am I the only one?356Views1like7CommentsHaving trouble with IF formula
Hello, I'm not sure what's going on with my formula, but it is supposed to double the "Grip" when a checkbox is checked. All the numbers being pulled from tables are correct and when not checked the "Grip" adds up correctly. When doubled, it is also adding the "Wall Thk." number an extra time. Correct single Grip = 1.625" Correct double Grip = 3.25" I get 3.5" for double grip. Formula used below, as well as pictures. If my formula is wrong, then I can't see it, but it has to be adding T8 somehow. =IF(X8,((INDEX(DATA_THK,MATCH(1,(Flg_Thk[Spec.]=N8)*(Flg_Thk[Series]=O8)*(Flg_Thk[Class]=P8)*(Size=Q8),0),MATCH(R8,FLG_TYPE,0))+T8*(R8="Lap Joint (LJ)")+V8*(U8="RF"))*2),(INDEX(DATA_THK,MATCH(1,(Flg_Thk[Spec.]=N8)*(Flg_Thk[Series]=O8)*(Flg_Thk[Class]=P8)*(Size=Q8),0),MATCH(R8,FLG_TYPE, 0))))+T8*(R8="Lap Joint (LJ)")+V8*(U8="RF")Solved69Views0likes5CommentsText Boxes Have Been Acting Weird Recently
I have a user who has been using text boxes in Word for many years. Today she showed me that when she types in one text box, the text affects another text box. On top of that, sometimes when she types in a text box, a second line will replicate her text for a little while. I made sure she didn't have linked text boxes before coming here. I am not able to upload the video screen recording to show you. Is this a bug?385Views1like8Comments
Events
Recent Blogs
- Formula completion with Copilot in Excel, helps you write accurate formulas faster by offering intelligent, real-time suggestions based on your worksheet’s context.Sep 08, 2025452Views3likes0Comments
- This podcast-style recap will summarize key topics and takeaways from a single or multiple meetings in minutes.Sep 05, 20251.2KViews1like2Comments