Slicer to create Dynamic Chart Titles
Hi. I have a chart that the title is the name of a category. There are 6 categories, let's say: A,B,C,D,E,F I created a Category slicer, so that when I select whatever category, the chart title updates with that Category label. I know how to create a formula that shows the title as whatever categories are selected, e.g. if I select A,B,C,D, it shows "A+B+C+D", and if I select all 6, then it shows "All Categories". But I want the formula to be such that if 4 out of 6 categories are selected, it would show "All Categories excluding..." where the "..." are the categories which are excluded, so instead of "A+B+C+D", it would show "All Categories excluding E+F". That's where I am stuck. I want it so if the majority of categories (i.e. 4-6) are selected, it would display the "All Categories excluding...", but otherwise it would display the categories separated with the "+". Hope my question makes sense. Can you advise me how to proceed. Thanks!
PivotChart is tall and narrow with lots of white space
Everything I know about PivotCharts is self-taught, so there are some gaps in my knowledge. Normally when I make a PivotChart, the plot area sizes itself so that it fits nicely within the chart area. However, the column chart I'm currently viewing is very narrow for some reason. Why did it generate this way, and is there any way to change the height to width ratio?
Embedding Word/Excel files from OneDrive into a webpage via iframes stopped working
As of ~10/31/2026, the iframes display a blank window instead of the expected .DOC/.XLS content. Affects both brand new files AND old files that were previously embedded and working prior to 10/31/2026. To replicate, try to embed an Excel file into a webpage per these instructions: https://support.microsoft.com/en-US/Excel/share-it-embed-an-excel-workbook-on-your-web-page-or-blog-from-onedrive. Or Word via https://support.microsoft.com/en-us/onedrive/how-to-add-an-embedded-document-or-picture-into-a-webpage. Symptoms appear to be identical to an earlier instance that occurred from 8/21/2026 to 8/27/2026 (see support case #7107584914). Issue exhibits whether source .XLS files are created by Excel for Desktop vs. Excel for Web. Files open and share normally from onedrive.live.com, but will not embed. Browser-independent, occurs on Edge, Chrome, and Firefox). DevTools\Console reports “Uncaught Error: Script error for "odsp.react.lib".
Email merge from High School Classmates Spreadsheet
have an Excel workbook with High School Class information. Some entries (class members) have email addresses and some do not. I would like to send a personalized email to all those with addresses skipping those who do not. The email will contain information (data fields) from the spreadsheet. (name, address, telephone etc). How do I construct a mailmerge that selects only members with email addresses, skips others, but still extracts data in the sheet from those selected? Personal information: Last name, First name,Middle Name, Address, City, State, Zip, Phone, Email are in columns A to I as listed. Not all members have Email addresses so only records with email should be selected, filling in other fields from that record in the merged document.
Excel 365 removes VBA projects (vbaProject.bin) from all .xlsm files on Windows 11
Hello Microsoft Tech Community, We are the technical support team at NEODIMO, a company that develops Excel-based financial management solutions using VBA. We are investigating an unusual issue affecting one of our customers using Microsoft Excel 365 on Windows 11. Problem description: Whenever the customer opens a macro-enabled Excel workbook (.xlsm), Excel displays the following error: "We found a problem with some content..." When attempting to recover the workbook, Excel removes the entire VBA project. The repair log reports: Removed Part: /xl/vbaProject.bin (Visual Basic for Applications - VBA) Troubleshooting already performed: The same workbooks open and function correctly on other computers. The issue persists when Excel is launched in Safe Mode (excel /safe). Even newly created .xlsm files containing simple VBA macros are affected. The VBA Editor opens normally using Alt + F11. Files have been downloaded again, including through Google Drive, without resolving the issue. Excel Trust Center and File Block settings have been reviewed. The customer reports using only Microsoft Defender. Standard .xlsx files work normally. Additional observation: Excel has also displayed a warning indicating that macro-enabled workbooks are blocked by Trust Center settings. Reviewing these settings has not resolved the issue. Environment: Windows 11 Microsoft 365 Apps for Enterprise Excel version/build: Pending confirmation Office architecture: Pending confirmation File storage location: Pending confirmation Security software: Microsoft Defender Questions for the community: What could cause Excel to remove xl/vbaProject.bin from every macro-enabled workbook on a single computer? Could a Trust Center policy, Microsoft Defender security rule, or Office installation component cause this behavior? Are there specific logs, diagnostic tools, or repair procedures we should investigate? Has anyone experienced and successfully resolved a similar issue? We have already contacted Microsoft Support, which recommended bringing this case to the Excel technical community. Our priority is to resolve the underlying issue without disabling important security protections or compromising the customer's files. Any technical guidance would be greatly appreciated. Thank you! NEODIMO Technical SupportFill in a cell based on an answer from another range
As a General Contractor I am reviewing subcontractors/pricing... I have a list of prices in Row1 and a list of Contractor Names in Row2 I have a separate tab showing lowest price per trade. I use 'min(row1)' to determine which price is lowest and put it in my final sheet. At this point, I want to list the name of the contractor that has the lowest price. If I use min(row1) to find the lowest price, how do I set up the next cell to list the name of the lowest priced contractors?
