Excel topics

Email merge from High School Classmates Spreadsheet

Larry_In_MIssouri — Sat, 31 Oct 2026 12:41:49 GMT

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.

Mise en forme conditionnelle avec formules

TeddyR1 — Fri, 30 Oct 2026 18:34:03 GMT

Bonjour,

En fonction d'un résultat obtenu dans une première cellule (exemple : chiffre d'affaires), je voudrais que la colonne mise en forme (ex : bénéfice) le soit par rapport au pourcentage/résultat obtenu de cette première.

Par exemple, il y a trois entreprises qui réalisent 1M€, 500k€ et 100k€ de CA et respectivement 50k€, 40k€ et 20k€ de bénéfice.

Je voudrais que si une entreprise réalise 10% ou plus de bénéfice par rapport à son CA, elle soit en vert, entre 5 et 10% en orange et moins de 5% en rouge.

Comment dois-je faire ?

En vous remerciant pour votre aide.

Teddy

Excel 365 removes VBA projects (vbaProject.bin) from all .xlsm files on Windows 11

vhnl — Thu, 29 Oct 2026 23:53:34 GMT

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 Support

Fill in a cell based on an answer from another range

cRokitski — Thu, 29 Oct 2026 18:21:45 GMT

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?

Excel 365 activation request preventing Excel-for-Mac 16.114.2 from saving file.

VelcroJP3 — Thu, 29 Oct 2026 15:26:04 GMT

I have been using Excel on my Macintosh (desktop, Powerbook, MacBook, iMac and MacMini) since 1988. I purchased Microsoft Office 2019 (for Macintosh) in December 2019 and have the order number and the 29-character activation key, which I used to activate the licence, immediately or within one or two days. I created a spreadsheet on October 1, 2026, and have been using it every day since then. When I started my Mac today, I opened the spreadsheet as usual but was shown a screen "offering" me a "free trial" of Office 365 -- only two options were available "Activate" or "Try Later". I tried Office 365 about 2 or 3 years ago and it did not have the features / functions I wanted (available only with Windows) and the other functions were not an improvement on those in Excel for Macintosh -- ditto for Word -- so I cancelled the trial. I DO NOT WANT OFFICE 365 and I want to continue with Excel (and Word) for Mac, using the license I purchased two, three or four years ago. Since I did not wish to activate Excel 365, I selected "Try Later" and updated my spreadsheet, using the spreadsheet opened automatically at startup. Excel (for Mac) will no longer save my file -- the "Save" and "Save As..." options are "greyed out". To restart Excel, I clicked on "Close", thinking that would allow me to save. Instead, I got a message asking if I want to save my file followed by

"Your changes will be lost if you don't save them. Click cancel and then activate your subscription to save your changes", followed by two options "CANCEL" (which was the default) and "Don't Save".

"About Microsoft Excel" shows that the product/licence is owned by me but says that the licence is not activated (which is untrue -- see above).

The spreadsheet is important to me and uses formulae which either are not supported by Apple's "Numbers" or which work differently in Numbers. (When I go away, I take a backup copy imported into Numbers, but many of the cells with functions have the resolved values rather than the functions, so the spreadsheet is merely a table from which I could reconstruct the spreadsheet, in extremis.)

Can anyone help me, please? Is this an actual Microsoft issue or has my system been hacked?

Formulas in excel for items uploaded to Google

swexcelnurd — Wed, 28 Oct 2026 05:54:20 GMT

We have been using the sheet in the link on our google drive but we are having ongoing issues with the formula erroring. The sheet is not working again now but did work for several years. Often I can get them to work in excel on my desktop but once I drag them to our Google Drive for everyone to use, they seem to have interesting things happen.

Can someone please help me with the formula for this one so I can have the students automatically populated in other sheets corresponding to the area of the school they are in please. Like I said, it was working, but will not even work when I open in excel now either.

In the EY sheet, I have pasted the old formula that was working which is not returning zero.

https://docs.google.com/spreadsheets/d/1d8ToveFB-raTakAXZ-buiflXOHBQc-sp/edit?usp=sharing&ouid=112080839837559797864&rtpof=true&sd=true

腾龙总公司app登录账号和游戏开户注册怎么弄

dvgd — Wed, 28 Oct 2026 05:16:51 GMT

腾龙公司会员账号游戏登录流程 —薇—【 ax 190033】游戏里有个小黄人就是客服。第一步：在登录/住册页面，找到住册会员“按钮并点击

macro not avaliable in this workbook

ghorivipul42 — Tue, 27 Oct 2026 13:39:09 GMT

1: Check whether Excel has blocked the macros

Close the workbook.
Open File Explorer and locate the .xlsm file.
Right-click the file and select Properties.
On the General tab, look at the bottom for a Security message with an Unblock checkbox.
If it appears and you trust the file, check Unblock, click Apply, then OK.
Reopen the workbook.

2: Enable macros in Excel

Open Excel.
Go to File → Options → Trust Center.
Click Trust Center Settings → Macro Settings.
Choose an appropriate setting that allows the workbook's macros to run, subject to your organization's security policies. Avoid enabling all macros globally.
Click OK and reopen the workbook.

Excel 365 64-bit: Out of memory when editing VBA in an existing XLSM

WalmirLuz — Tue, 27 Oct 2026 13:33:40 GMT

Hello,

Microsoft Support referred me to this community because they could not resolve an Excel VBE editing issue.

Environment:

Microsoft 365 Excel for Windows, 64-bit;
Version 2610, build 16.0.20527.20088;
Existing macro-enabled workbook (.xlsm);
Calculation mode: Manual.

Problem:

While editing an existing standard VBA module, typing: Dim testeCompilacao As Long and pressing Enter triggers “Out of memory.” Adding a new procedure also triggers the error. This occurs before compiling or executing any macro.

In a new blank workbook, I can create a VBA procedure normally.

Tests already completed:

Office Quick Repair: the error persists;
Excel Safe Mode: the error persists;
Checked VBA references: none marked MISSING;
Tried another existing standard module: the same error occurs.

A preserved version of the workbook previously compiled successfully and opened without a repair warning.

The workbook contains 46 worksheets, 12,485 formulas, VBA and CustomXML used to persist scenario data. These elements must be preserved during troubleshooting.

Support suggested importing native module exports into a separate new XLSM, without copying worksheets. That isolation test has not yet been completed.

What diagnostic steps can distinguish an Office/VBE build or installation issue from a problem within this specific VBA project? What logs or additional evidence would help identify the cause?

I can provide screenshots of the error and the Excel version. The complete workbook contains proprietary code and data and is not suitable for public posting.

Thank you.

Problem with Excel's check boxes aspect/render/font

Teletexto — Mon, 26 Oct 2026 10:08:18 GMT

Ok, this may be a weird one.

I just installed Windows 11 (fresh installation, not over an older version) and then installed Office 365. Windows 11 Pro 26H2 26300.9711 and Excel version 2609 Build 16.0.20430.20032 64-bit, if that matters.

Now, I have this weird thing, and it may be difficult to explain.

In my older SO, my work pc (W10) and Excel online, when I put a checkbox in a cell, it is a rounded square and when you checkmark it, the hole square gets colored as the text color and only the actual checkmark is colored as the background. It's very easy to distinguish them, because you have empty boxes that are only border-colored and checkmarked boxes that are completely colored.

In my new installation, when I put a checkbox, it shows as a not-rounded square border, and if you checkmark it, it only adds the checkmark inside the square, but it doesn't fill the square, still just the border and the tickmark. Which makes them very easy to miss, specially in long lists.

Since is difficult to understand just written, here is an illustation:

It's the same file, good on my work PC and online, bad at my new W11 installation.

Of course, to solve the visibility problem, I can add some conditional formatting to color the "TRUE" values or so, but that's besides the point. It used to work correctly and still works correctly in other installations, but not in the new one and that's what I want to solve, not just work around it.

To add some info: it's not about the font chosen, nor about the , they don't change aspect independently of the font I have selected. The exact same file shows them different in the different computers. It may be a Windows thing, more than a Excel thing, but I don't know what to even check. It also may be some kind of font/symbol/character file that Office uses as default, but also don't know how to check. I already updated both Windows and Excel with no luck.

Any ideas what may be?

Excel 4.0 macros are not working properly after last update Oct 2026

akakat — Mon, 26 Oct 2026 05:26:23 GMT

One of the functions I use in the name manager Eval1=LAMBDA(x,IF(TODAY(),EVALUATE(x),)) has stopped providing results. It only returns #NAME? as result. I have been using it for years without a problem and the last update (Oct 2026) I believe was the source of this issue. I have already checked the settings in the Trust Centre and are fine.

How do I format Excel to show timings.I want to show F1 one lap times to a thousandth of a second

RPShifty — Sun, 25 Oct 2026 00:01:08 GMT

I want to format Excel to show F1 lap times in a minutes: seconds to three decimal places

Feature Request: Repeat Rows at Bottom of Printed Pages

MarkFoster13 — Sat, 24 Oct 2026 19:04:00 GMT

Excel currently supports "Rows to repeat at top" (Print Titles), but there is no equivalent feature for repeating rows at the bottom of every printed page.

This would be useful for stocktaking sheets, picking lists, audit forms, inspection records and other printed worksheets where users need space for handwritten additions or notes.

Proposed enhancement:

Add a "Rows to repeat at bottom" option in Page Setup, similar to the existing "Rows to repeat at top" setting.

The specified rows would be printed at the bottom of every page, regardless of sheet length or filtering.

My current use case is stocktake reports generated from Power Query where counters need 3-5 blank lines at the bottom of every printed page to record items not listed.

formulas

ExcelApprentice96 — Thu, 22 Oct 2026 23:01:16 GMT

I'm trying to use the XLOOKUP formula and when trying I can use the 1 cell reference but can't use the whole column without excel popping up an error message about there being a problem with my formula. I even used the excel training video before coming here.

2FA popup message persistent on excel for mac

Andrew2250 — Thu, 22 Oct 2026 21:52:25 GMT

When I sign in to any site that requires a multi factor authentication through sms messaging, the pop up window for the 2FA code appears in the top corner of any excel spreadsheet that I have open.

If I try and move up to the spreadsheet corner, I can't.

If I tab up to get to cell A1, the popup is activated and I can't access cells it is covering.

I can't click and delete the popup message.

It may disappear over time, but I am unable to use excel effectively while it is present.

Any ways to delete the pop up?

Advanced Filtering encounters an error in Excel for Mac

robustnano3711 — Thu, 22 Oct 2026 11:49:21 GMT

I am trying to use advance filtering to find unique rows in a spreadsheet and paste them into a specified empty worksheet. Using Golden Gate 27.0.1 with Excel.

How do I fix this?

Content Not Permitted, two-four-seven is not allowed in the community. Remove it & try again.

Tracy7212 — Wed, 21 Oct 2026 21:45:59 GMT

What does this mean? "Content Not Permitted, two-four-seven is not allowed in the community. Remove it and try again."

My post had text and snipping-tool images from my Excel spreadsheet - that's all. What is "two-four-seven"?

How can I display images from my spreadsheet without triggering this error?

And as I tried to publish this question, I got the same warning! So I have spelled out the numerals.

Excel “Trace Dependents” stops working in XLSX files generated by ChatGPT

LuloSun — Wed, 21 Oct 2026 19:46:49 GMT

Excel “Trace Dependents” stops working in XLSX files generated by ChatGPT – Cause and tested solution

Problem

When opening Microsoft Excel workbooks (.xlsx) generated by ChatGPT, the Trace Dependents feature may stop working, reporting that a cell has no dependents even when other cells explicitly reference it.

The Trace Precedents feature may continue to function normally.

In our testing, the problem was particularly difficult to diagnose because:

It occurred repeatedly with Excel workbooks generated by ChatGPT.
Opening an affected workbook caused Trace Dependents to stop working even in other workbooks that had previously worked correctly.
The malfunction persisted after closing the affected workbook.
Recalculating formulas, rebuilding the calculation chain and reconstructing the workbook did not consistently resolve the issue.

Root cause identified

The affected XLSX files generated by ChatGPT contained the following setting in xl/workbook.xml:

forceFullCalc="1"

This setting enables forced full calculation, bypassing Excel's normal dependency-based calculation mechanism.

Tested solution

Close Excel completely, including any remaining EXCEL.EXE processes.
Open the affected XLSX file as a ZIP archive.
Locate xl/workbook.xml.
Find the <calcPr> element.
Change forceFullCalc="1" to forceFullCalc="0", or remove the attribute.
Save the corrected XLSX file.
Restart Excel in a clean session.
Open only the corrected workbook and test Formulas → Trace Dependents.

Experimental confirmation

We verified that:

An original ChatGPT-generated workbook containing forceFullCalc="1" triggered the malfunction.
The problem affected the entire Excel session and persisted after closing the original workbook.
A corrected version containing forceFullCalc="0" worked when opened in a clean Excel session.
The same issue was reproduced through multiple tests, including Excel Safe Mode.

Recommendation for ChatGPT and XLSX-generation developers

ChatGPT's spreadsheet-generation workflows should explicitly prevent the unnecessary activation of forceFullCalc=True.

Before delivering generated XLSX files, the system should inspect xl/workbook.xml and ensure that persistent forced full calculation is disabled unless specifically required.

This check is particularly important because the problem may affect not only the generated workbook but also other Excel workbooks opened in the same session.

Scope and limitation

This issue was repeatedly observed in workbooks generated through ChatGPT in our testing. The results do not establish that all ChatGPT-generated Excel files are affected, nor that this setting is responsible for every Trace Dependents malfunction.

Nevertheless, the relationship between forceFullCalc="1" and the observed behavior was confirmed experimentally in the tested environment.

Conclusion

A ChatGPT-generated XLSX workbook with forceFullCalc="1" can trigger a persistent malfunction of Excel's Trace Dependents feature.

Disabling this setting and restarting Excel restored the functionality in our tests.

Halloween 2026 Scheduling Challenge 🎃

Patrick2788 — Wed, 21 Oct 2026 14:53:26 GMT

Happy Halloween!

You'll find the rules in the screen capture below and in the attached workbook.

Creative solutions are encouraged. Feel free to use any functions available in the Beta channel.

I won't post my solution immediately so submissions aren't influenced.

Enjoy!

Conditional formatting

esmefarrow — Wed, 21 Oct 2026 13:15:43 GMT

I'm making a rule to Highlight cells in Column AZ when the value is lower than Adjacent cells in Column P.

For the most part it works except for two cells in AZ (1 shown as an example) that are higher than P but are being picked up by the conditional formatting. The two cells I'm focusing on here are P14 (£0.27) and AZ14 (£0.43).

£0.43 should not be being highlighted pink as it isn't lower than £0.27. This has to be something obvious but I have looked at it too long. Please help if you can :)