Recent Discussions
Criteria for a query
I have a database containing multiple records, and I want to create a query that allows the user to specify how many times the records should be displayed. This should be done without duplicating the original data preferably using a criteria. Sample: 1 Row Date: 02/16/2025 Code: 123456789 Description: Test But if the user types 2 will show a duplicate row. 2 Rows Date: 02/16/2025 Code: 123456789 Description: Test Date: 02/16/2025 Code: 123456789 Description: Test18Views0likes1CommentLinking Access to Excel does not work
I have created a simple Access that is connected to a linked table to an Excel file as a data source. I can run the Access without any problems. It accesses the data and everything is fine. But when my colleague wants to run the Access, she gets the following error message "Microsoft Access “C:\Users\User\ [Source Path] .xlsx” is not a valid path. Please ensure that the path is entered correctly and that you are connected to the server where the file is located." We use OneDrive/SharePoint in our company and the colleague has access to the folder where the Excel and Access files are located. But it doesn't work. I think it's the path, as it seems to be local. But I don't understand why. This Access in turn serves as a source for another Excel (the target file). There it has a similar error message: ‘’Microsoft Excel [DataFormat.Error] “ [File Name] .accdb” is not a valid path. Please ensure that the path is entered correctly and that you are connected to the server where the file is located." I can open and run both the Access and the target Excel without any problems. Thanks a lot in advance. I appreciate your help a lot.35Views0likes1Comment- 46Views0likes2Comments
Conditional Formatting Partial
Good morning, In need of a little bit of help. My current situation is I can't figure out a formula to highlight partial matches. In my current excel I gather information from a scan then I filter it out to give me the text I want. Now from there I want that filtered info to match another sheet that same text followed with text after. Due to privacy reason I cant share my excel sheet but will provided a similar example. So lets say column D is the filter info from my scan and my list is from column A (in real word list and filtered info are in 2 separate sheets but same book). on the top you can see a formula I have been trying but doesn't always work. I want both sides (or sheets to highlight when it happens).Solved102Views0likes9CommentsUtilizing Excel's turing capabilities to create Conway's 'Game of Life'
The Background It's been said with Lambda (and LET and a wealth of functions in 365) Excel has become 'turing-complete'. To quote the article linked below: "You can now, in principle, write any computation in the Excel formula language." https://www.microsoft.com/en-us/research/blog/lambda-the-ultimatae-excel-worksheet-function/ The Challenge I thought it would be fun to create Conway's 'Game of Life' in Excel 365 to see how far I could push things. Conway's Game of Life - Wikipedia The rules are simple: A 'cell' has up to 8 adjacent cells (less if the cell is on the edge of the board). A 'neighbor' is a cell with a 1 while a 'dead' cell is empty. An 18x18 board Multiple iterations Bigger boards! more (it's relaxing to create new shapes and designs) The Approach My first thought was to use MAKEARRAY because I could use 'r' and 'c' coordinates and there would be no stacking. I devised a recursive function that worked for 1 iteration but failed on subsequent iterations because the use of TAKE/DROP was slowly shrinking the board! The revised approach is essentialy a recursive MAP that uses 3 arrays: the input matrix, the 'r' array (row numbers) and the 'c' array (column numbers). It's my way of using r/c without using MAKEARRAY. For Discussion I welcome any improvements to the existing function and any different approaches someone may have to creating Conway's Game of Life. Conway Lambda follows: Conway =LAMBDA(matrix, iterations, IF( iterations = 0, matrix, Conway( LET( height, ROWS(matrix), width, COLUMNS(matrix), r_arr, SEQUENCE(height) * SEQUENCE(, width, 1, 0), c_arr, SEQUENCE(height, , 1, 0) * SEQUENCE(, width), CheckNeighbors, LAMBDA(lattice, r, c, LET( RCx, LAMBDA(row, col, IFERROR(CHOOSECOLS(CHOOSEROWS(matrix, row), col), 0) ), N, RCx(r - 1, c), NE, RCx(r - 1, c + 1), E, RCx(r, c + 1), SE, RCx(r + 1, c + 1), S, RCx(r + 1, c), SW, RCx(r + 1, c - 1), W, RCx(r, c - 1), NW, RCx(r - 1, c - 1), compass, VSTACK(N, NE, E, SE, S, SW, W, NW), neighbors, SUM(compass), IF( AND(lattice = 0, neighbors = 3), 1, IF( AND(lattice = 1, OR(neighbors = 2, neighbors = 3)), 1, 0 ) ) ) ), MAP(matrix, r_arr, c_arr, CheckNeighbors) ), iterations - 1 ) ) )2KViews3likes16CommentsCustom Bullets Transparency Issues
So I've been using custom bullets for years, in January 2025 there was no issue. I was unable to work on my document since then because of issues with my PC. Yesterday when I opened my document, my bullets no longer had transparency. Normally, it wouldn't be a problem because the background is also white, but in this document, I have background images as well. As you can see the background on the bullets stand out. The file is a PNG with a transparent background. I have tried replacing it more than once, I have 2 different bullets in this document and they are both doing it. I checked another document that was fine in the past and it too is having the issue. I opened a brand new doc and changed the background color of the doc and it does the same thing. I contacted M365 support, it was painful they didn't even know how to do a custom bullet, they were looking for picture settings... Hehe. Anyway, they told me to post here. To me it's something in Word itself because it was working before. The doc is NOT in compatibility mode or anything like that. I can't find anything on the Internet and its frustrating me to no end. Of course I could take the custom bullets out but this is going to be a publish book, that little extra flair is everything, and this is the 4th book in the series, and having it differ from the first three.... Again it's in the details, readers might not care, but I care.45Views0likes2CommentsShift Work Calendar Year at Glance Template
I would like to use the Shift Work Calendar year at glance Template in Excel, but it is only built for 3 jobs. I need to edit for 7 or more jobs, but can't figure out how to do it. I'm sure it's a simple solution, but I'm new to this.59Views0likes2CommentsPivot by function and graphs.
Hi, I am trying to make my graph based on a pivot ny function to keep updated. As soon as I Add a new line in my table, the graph gets ruined. See attached document for example. Any clever solutions for using Pivot by and graphs? Best regards - Geir45Views0likes1CommentSUMPRODUCT() Formula Query
Hello, I'm facing issue while using SUMPRODUCT(). I have 2 different table (TableX and TableY). TableX = Contains Department, Candidates and Joining Date TableY = Department, Candidates and New Column under which I want to populate the count Candidates who will join in specific month. Below formula is not working. Can someone please help on this ? =SUMPRODUCT((TableX[Department ID])=A2)*MONTH((TableX[Joining Date])=6) Table1: Table2:Solved90Views0likes5CommentsPower Query Dropping Decimals with Accounting Format
I'm encountering what seems like a bug in Power Query. I have a table with data that contains numbers with more than 4 decimal places. When this data is in the Accounting format, Power Query is only picking up 4 decimal places, even if the Query is formatting the data is Decimal Number (Changed Type). When the data is formatted as Number, Power Query is able to pick up all decimal places (Some numbers have 10+ decimals) Is this normal behavior? I would like to use the Accounting format because it looks cleaner, but obviously I cannot sacrifice data accuracy. It is also very illogical to have a format labeled "Accounting" only hold 4 decimal places when passed through Power Query I did try restarting Excel multiple times, refreshing queries, the only thing that resolved it was changing the local format to Number.126Views0likes10CommentsNew to Win 11 and cant figure out where my files are going
Using: Win11, Microsoft 365 subscription, Dell Inspiron AIO Good Afternoon, I purchased a new computer with Win 11. I screwed up the setup because I chose set up as a new PC so It's hard to find old files. I would like to keep everything on ThisPC and only allow certain files/folders on One Drive. Right now, it looks as if everything is going to drive C and there are no folders available on This PC. This may be because before I stopped using my old computer, I backed up everything into OneDrive. Q: How to change OneDrive configuration back without losing everything that is already saved in the cloud? Q: How to add folders to ThisPC? Q: I would like to save everything by default to This PC. If I do that, but have the correct folder set for one drive, will the file automatically save on my pc and save a copy in the cloud. Thank you in advance for your help, I appreciate it. I hope I'm not as clear as mud. MissJaynee31Views0likes1CommentCreating a Form from a List
The Forms link at the top of a Microsoft List is awesome -- it lets me create a Form for the current list. I can use all of the great features of Forms to make the list be exactly what I want. What's really disappointing, though, is that there's no way (at least that I can find) to connect my beautiful form to the New button for the list. In the Forms section of the List settings, I can opt for the default form, a Power App form, or an Info Path form. It would be fantastic if I could choose the form that I just created -- FROM THE LIST -- to the list. It seems like an obvious and confusing disconnect. The very presence of a link to Forms suggests that this is the way to customize an intake form for the list. But alas, no. I assume I'm not the first person to fall into this pit! Is it on the roadmap?22Views0likes1CommentFilter via checkboxes with multiple criteria
I want to make a feature/application matrix where you can choose features by clicking on a checkbox and the filter needs to show only the application where all the chosen (checked) are available. So instead of the inbuild header filter I want to choose by checking / unchecking the boxes . Example: Can some one tell me how to achieve this? (I prefer to have the features vertically and the application/platform horizontally but I think that's harder to achieve or I'm I wrong?)64Views0likes5CommentsExcel Data Model File Path Change
My boss created an Excel data model before I joined the company. He created the data model and queried the data from files within his personal drive. Now that I am here, he wants me to have access to these files and has moved them into a shared folder. The thing is, all of the queries now have the wrong file path. Is the only way to fix this to manually update the file path within the Source step of the power query editor? If there is an easier way, please let me know!476Views0likes4Comments"New Outlook" Inbox not updating
In the "New Outlook" (which appears identical to the current web version of outlook): whenever I get a new email, I will get a notification and the unread counter next to my inbox tab will increase by one... but the email itself will not appear in the inbox UNTIL I click out of the inbox and back into it! It doesn't appear that the inbox can refresh itself "on-the-fly" as new emails come in, it only refreshes itself when it is loaded up! Are others experiencing this issue? I see svhelden posted about it a year ago but they said a software update fixed it... to me it seems to still be occurring with both the desktop and web app.56KViews5likes24CommentsExcel to PDF images not included
I am experiencing an issue when I PDF an excel file that my images, within the table, are not showing up. My links are also not working anymore. All of this started with the last adobe and excel updates which hit at the same time for me. I found the link below on the Adobe forums. It seems to be pointing to Excel as the culprit. Anyone have a solution for this? https://community.adobe.com/t5/acrobat/excel-to-pdf-images-are-not-included/m-p/10800897#M23262920KViews0likes4Comments
Events
Recent Blogs
- Measure and drive Microsoft 365 Copilot adoption in your organizationApr 16, 2025540Views3likes0Comments
- Level up your notetaking skills with these underrated OneNote features.Apr 14, 2025834Views2likes0Comments