Recent Discussions
Facing with Outlook issues after switching to W11 24h2
Since switching from W10 23h2 to W11 24h2 several functions in Outlook (Classic) are not working. For example: Find Time (not loading) Share in Teams (clicking button but no action) --> however there is a hidden button "Share with Teams" wich is working.... Adaptive Cards are not displayed (Version 1) The new Report button is greyed out Calendar cant be shared (permissions cant be shown) What did i do to try to fix it? Kinda everything... Reinstall, tested with W11 23H2, cleared cache, deleted all the Outlook relevant files in appdata,new profile (outlook and windows), other computer, switched from monthly to current channel. ✌️
Custom Number Formatting with Symbols
Dear Experts, I have a data like below in A1:D4 :- In Column "E" is the %age change, and in F whether it's a dip or increase with arrow, Could you please help me with a Formula/Custom Number Formatting in Column "F", which will create Automatic arrows for dip/increase? -Ve dip , +ve Increase. Thanks in Advance, BR, Anupam
Copy/Paste Macro using ActiveSheet
Hello I am trying to do something I think for most would be simple, but I am getting hung up. I want to be able to run a macro that will copy the items in column B 11-21 of the ActiveSheet, and paste them in the same cells on the next sheet If there is a T in column A next to the corresponding B columns row number. I have gotten the macro to work if I am calling out a specific sheet name, and cell. I want it to work with whatever sheet is currently being looked at, and move it to the next sheet. I also copy and pasted code from another website that is not working. I have attached a copy of that code, and an example of my sheet. Any help would be much appreciated. I am still a little new to excel, and have only created a few macros.
Return a list of matches across multiple columns based on criteria from Cascading Menus
Long time referencer, first time poster... I feel like I am a well-versed Excel user but have run into a situation I cannot seem to resolve. I wanted to bounce it around and see if anyone has any input that can point me the right direction. I started a new position at a small school and one of the first things I wanted to do was streamline the way that the department references who has Credit Cards. The initial steps were easy and I made a good file that was working well and compiles data from multiple sources to create a single lookup which returns all the information about the specified card holder: One tab has all the dropdown menu options, and then the data is compiled on a separate tab spanning multiple columns. This is easy enough and done mostly with =XLOOKUP to return the data - No Problem. However, it occurred to me that it may be helpful to have a separate tab with the ability to return a list of all people that fit multiple criteria; for example, everyone in Football program (Lookup 'Sport' and Filter by 'Football'): Up to now, no problem as the Cascading Dropdowns are working well. I do not know if it is possible, but what I cannot figure out is a function that allows Excel to look at data across multiple columns (Columns C:I in this screen shot) and return a list (Column B) of everyone that matches. Essentially what I (think) would like is a way to combine the functions of Cascading Dropdowns and XLookup to return all names in a single list. Any suggestions are appreciated!
Excel Script - not calculating as expected
Hi folks....I'm hoping somebody can shed a bit of light on what I'm doing wrong here. We have a simple holiday tracker - it has a small amount of VBA in it which I figured would be a good candidate to migrate over to an Office/Excel script so that it could work in the browser version of the application. The file has over 300 columns, a column for each day of the year. All the macro does is move the view forwards or backwards in the year by toggling the visibility of the column. Above each column, in a hidden row is a simple formula which results in either Show or Hide depending on the current month. It has 2 buttons, one to increease the month number and one to reduce it. The show/hide value updates based on this number. The VBA version works pretty well but given it's fairly basic, I assumed it would be a good cadidate for my learning in Excelscripts! So after much effort I came up with the script below..... function main(workbook: ExcelScript.Workbook) { // Get the active cell and worksheet. const CalcMode = workbook.getApplication().getCalculationMode(); console.log(CalcMode); // TODO: Write code or use the Insert action button below. let ws = workbook.getWorksheet("Refs"); let rng = ws.getRange("rngCurMonth"); let wsY = workbook.getWorksheet("Year"); let rngY = wsY.getRange("rngShowHide"); let rngYVals = rngY.getValues(); let colCount: number = rngY.getColumnCount(); let monthNum: number = rng.getValue(); wsY.getRange("B:NG").setColumnHidden(true); if (monthNum > 1) { monthNum = monthNum - 1; rng.setValue(monthNum); workbook.getApplication().calculate(ExcelScript.CalculationType.full); monthNum = rng.getCell().getValue(); console.log(monthNum); for (let coll = 0; coll <= colCount; coll++) { //console.log( coll + " is " +rngYVals[0][coll]); if (rngYVals[0][coll] == "Show") { rngY.getColumn((coll)).setColumnHidden(false); } } } } I have linked this script to a button. When it's clicked the value relating to the month number changes correctly. The script hides all the columns and then unhides the ones where the value is "Show". The problem is that the formula relating to this Show/Hide value only seems to update once the script has completed. It's not recalculating after the value is changed. I have added a line to try to force the recalc mid process, but it's not working. Any ideas? There are a few console.log lines in there which I need to take out, like the start where I'm checking that Excel is in automatic calc mode....which it is!! Also, after I set the monthNum variable, I have got the script to pull the value from the range holding the month number from the worksheet, to show that's it's updated correctly I'm stumped. I find it difficult to learn these scripts partially because the editor is woeful! Regards, Tony
Microsoft Lists - how to move?
Is there a way to move a List, e.g. from my personal space to an Office365 Group? There does not seem to be a way to do this other than using workaround of export & import to Excel. However, if I click "Export to Excel" from Lists, all I get is a file called query.iqy. Does anybody else experience this issue?
Help! Image disappears when you click on it in Excel, with the message "Picture" appearing instead
Hi. I have a spreadsheet with 200 rows that contains one image in each row of column A. I inserted these images by Insert > Picture > Place Over Cell (then I rotated it as neccessary) > then I clicked the little icon on the top right of the image which puts the image in the cell. However, the problem I have is when you click the image, it dissapears and the text "Picture" appears within the cell and the only way to make the image to come back (to my knowledge) is to Undo. Does anyone know why the image dissapears when I check on an image in the cell? Images attached a reference. Any help would be really appreciated as a lot of time and effort has gone into compiling this document. Is the document corrupt, too many images? Many thanks. Paul > This DeviceHow do I Stop Word Switching to Multiple Pages View
I have a high resolution wide screen monitor. Every time I open a Word document in full screen, it switches to the Multiple Pages view (typically 2 pages, side by side). I hate this view! I can't read 2 pages at a time. I always want a single page view. Does anyone know if there is a way to stop Word changing to this view? I am using Microsoft® Word for Microsoft 365 MSO (Version 2202 Build 16.0.14931.20128) 64-bitExcel will not let me click into cells or incorrect cell is selected randomly
Hi, This is an ongoing issue that I've been having for years across platforms, computers, versions of excel and workbooks. Basicially, one of two things happen: 1-I click on a cell but nothing happens, the cell is not selected 2-I click on a cell but the wrong cell is selected (Example: Click on cell B2 but excel will select C2) This will happen as frequently as a few times a day (across multiple workbooks) to every month (again, across multiple workbooks) In ALL cases cells are NOT protected Saving the workbook, closing then restarting excel fixes the problem. As I mentioned before, this has been ongoing for years now across multiple computers, workbooks, operating systems. All systems and versions of excel were fully up to date at the time of the error. Because this is happening over several different workbooks, I do not belive it is a workbook issue (especially when it doesn't happen 100% of the time to ANY workbook) Systems used: Macbook Pro (circa 2015), OS up to date - No longer have this computer Windows 8 (again, old computer) Windows 10 (old computer Windows 11 (2 different computers, currently owned) I have always kept excel and the OS fully up to date and I'm currently using the most recent version of Windows and Excel. In all cases, I have used built in trackpad and a 3 different wireless mice (with full batteries). Still randomly occurs. It's really just an annoyance and like I mentioned before, saving the workbook and restarting excel solves the issue... until next time (which could be later that day or a few weeks...It's very random.)STOCKHISTORY
The issue regarding STOCKHISTORY function in MS Excel 365. Till yesterday night, it was returning weekly data, not today. It is only returning STOCK Data till 25-4-25. My function is like ' = STOCKHISTORY(A3, F1-1, F1-1, 1, 0, 2 )' where A3 = Stock Data, F1 = Today. It is returnnig today Op, CL through function A3.Open and A3.Price. It is also working for monthly. Got good support from MS for technical repair (Quick) but that didn't yield any result. It is also worth mentioning that, this Stock data fetching thru STOCKHISTORY function from possibly REFINITIV system, is always erratic and non-dependable for business purpose. Request for urgent please. S/W: MS Office 365 Subscription H/W: Dell Inspiron 5640, Win 11 Home. Thanks & Regards Liton NandyExcel FILTER formula limits
Hi! I have been using the FILTER function without issue, except that my dataset has expanded to c 500 rows. Once I try to use the function on the array with more than 345 rows I get an #N/A error. Works fine below that. Is this a limitation on the formula or something else? Thanks!Automating Vacation Requests with Azure Logic Apps and SharePoint
In today’s fast-paced business environment, automation plays a vital role in improving operational efficiency. One of the most common yet time-consuming HR processes is managing employee vacation requests. Fortunately, Azure Logic Apps offers a low-code/no-code solution to automate this workflow efficiently and with minimal setup. In this blog post, I’ll walk you through how to use Azure Logic Apps to build an automated vacation request workflow, integrating with services like Outlook, SharePoint, and Microsoft Teams. https://dellenny.com/automating-vacation-requests-with-azure-logic-apps-and-sharepoint/Using IF, INDEX, & MATCH for complex lookup
Hi folks, I've been trying to figure out a bit of a (seemingly) complex IF, INDEX, & MATCH statement to achieve some reporting on raw data that I'm gathering, but can't quite seem to figure it out, and was hoping one of the gurus around here could point me in the correct direction. I have ~20 sheets (multiple phases) tracking the status of work items, corresponding to particular users, and then marking off individual work items as they're completed for a given user within a phase. So far I've been doing this manually by logging into given systems, confirming a value is present, and then marking the corresponding column in the relevant sheet with a "Yes" for that user. I would like to, instead, pull csv reports from the relevant systems, feed them into a "raw data" sheet at the front of the spreadsheet, and then have the formula for a given column lookup the target value for that user in the raw data, and return "Yes" if that value is there. So at a high level: =IF('RawData'!H2:H1500="*Windows Hello*",(INDEX('RawData'!A1:H1500,MATCH('UserReport'!A1:A100,'RawData'!A1:H1500,0),"Yes"))) ie; Look in the H column of sheet RawData for the value "Windows Hello" Index sheet RawData and compare value of user display name in column A with same column in UserReport sheet. Users' row in RawData sheet contains "Windows Hello", return value of "Yes" in the cell formula is applied to (The column in UserReport sheet which denotes if user has Windows Hello configured). I understand that the "Yes" in the formula should actually be a column number where you want the value to return, but I want to print "Yes", not return a value from a column (Although I guess I could just make a dummy sheet with "Report values" and reference a cell with "Yes" in it? Right now I'm just getting a SPILL error on the formula, so definitely something wrong in how I'm approaching this. Please help!
Recent Blogs
- 2 MIN READWe've eliminated the unused space between the ribbon and your canvas, giving you more room for what matters most.May 08, 2025
- 3 MIN READOneNote for the web went through a series of enhancements made over the past few months, designed to elevate your note-taking experience and boost your productivityMay 07, 2025
