Recent Discussions
Lost ability to create macros
Just tried to create a macro and have found that all the buttons on the macro console are greyed out. I've been editing macros in this file earlier but now all have disappeared and I can't do anything with the macro console. All set up in the trust centre ok. Any ideas?Pivot Table/Slicers Skipping Month
Hello, I have a Pivot Table where I use data slicers. A couple of the data fields are "Year" and "Month". When I updated the PT with data for October it treats the new data like it is November instead. I reviewed the following: I verified in the data that there was no incorrect month put in. So there is nowhere in the data where the "Year" = 2025, and the "Month" = "11". The data that was added to the table has the correct "Year" of 2025, and the correct "Month" of 10. I verified that the pivot table was set to view all months, which it is (there is data going back to Jan of 2024.). An additional filter is "Did we answer your question/concern?". This is set to No, and there were three "No's" in October. If I remove the data for October, then the PT removes the info showing for November. Including screenshots of the info. Does anyone have any idea why it is doing this?A button to transpose data into a destination table
Hi, I have a table filled with data that I need to be pasted into a final blank table but the destination table is larger than the original table. Also the data needs to be sorted by one column and the column order doesn't match. See image. This is a process that needs to be carried out by people with limited experience of excel or even computers, hence thinking that a button linked to a macro might be a solution, but open to any solutions! Thanks
Spell Number in Bangladeshi/Indian Style By Excel Formula.
On web there is SpellNumber() VBA custom function which spell numbers to word in million, billion. We Bangladesh, India, Pakistan spell amounts like lakh, crore etc. Here is a formula to convert amounts to word in Bangladeshi/Indian style. In attached file there is also a generalize LAMBDA() named function SpellNumberBD(). =LET(x,A2,lr,TEXT(INT(x),"00000000000000"),cr,LEFT(lr,7),lc,RIGHT(lr,7),dec,ROUND(x-INT(x),2)*100,c,CHOOSECOLS, digits,{"One","Two","Three","Four","Five","Six","Seven","Eight","Nine","Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"}, Tenths,{"Ten","Twenty","Thirty","Fourty","Fifty","Sixty","Seventy","Eighty","Ninety","Hundred"}, SPELL,LAMBDA(val,abr,IFERROR(IF(val<20,c(digits,val),c(Tenths,LEFT(val,1)) & IFERROR(" " & c(digits,RIGHT(val,1)),"")) & SWITCH(abr,6," Lakh ",5," Thousand ",3," Hundred ",1," Poisa Only.",""),"")), Taka,SPELL(--MID(cr,1,2),6) & SPELL(--MID(cr,3,2),5) & SPELL(--MID(cr,5,1),3) & SPELL(--MID(cr,6,2),"") & IF(--cr>0," Crore ","") & SPELL(--MID(lc,1,2),6) & SPELL(--MID(lc,3,2),5) & SPELL(--MID(lc,5,1),3) & SPELL(--MID(lc,6,2),""), Poisa,IF(dec<=0," Taka Only."," Taka And " & SPELL(dec,1)),TRIM(Taka & Poisa)) Alternate Download Link (Google Drive).Agent in SharePoint option is not visible in the M365 admin center
Agent in SharePoint option is not visible in my M365 admin center under pay as you go service and it's only show Syntex services option not the Agent in SharePoint. As before we were able to see both options like Agent in SharePoint and Syntex services but now Agent in SharePoint is not visible. I have also attached the screenshot where both of the options were visible but now the Agents in SharePoint option is not visible, so is there new update in admin portal or is this is some kind of issue?How to filter visible cells by formula after applying filter to a dataset.
I have a dataset from A1:B11 (in real case many more). I apply a filter on dataset, for example filter data for Retailer1 and Retailer3. I want on a separate sheet to filter these visible cells using formula (not VBA). Preferably using a generic LAMBDA function like =FILTERVISIBLE(A2:B11). Any thought or idea to achieve it?
Events
Learn, Connect, and Be Inspired at ESPC25
Join us in Dublin for ESPC25! One of Europe’s largest community conferences, ESPC25 is your opportunity to expand your Microsoft 365 Copilot, Collaborative...
In-Person
Recent Blogs
- Thanksgiving and Christmas are fast approaching! Prepare for the holiday shopping and travel rush with Microsoft Copilot.Nov 06, 2025
- Bug Name Issue Fixed Undo/Redo don’t work for Bring To Front and Send To Back commands. In Form/Report Design view, after executing a Bring To Front or Send To Back command...Nov 05, 2025
