r/excel • • 22h ago

Weekly Recap This Week's /r/Excel Recap for the week of November 14 - November 20, 2026

4 Upvotes

Saturday, November 14 - Friday, November 20, 2026

Top 5 Posts

scorecommentstitle & link
30573 comments[Discussion] I just learned about LET and it cleaned up this formula - what else do you use it for?
8429 comments[Discussion] After LET, I tried LAMBDA - here is a reusable formula I made
8120 comments[unsolved] what's this new green dots thing on excel?
7513 comments[Novelty] Film made entirely in Excel...
5668 comments[unsolved] How does copying in Excel actually work?

 

Unsolved Posts

scorecommentstitle & link
2428 comments[unsolved] How to prevent Powerquery from re-downloading an excel file used as a source over and over?
1823 comments[unsolved] Data entry in shared files horribly built
1215 comments[unsolved] Best Excel architecture for configuration control: 1 Master + 49 Sub-Packages tabs
1212 comments[unsolved] Weird New Options Around Column/Rows
109 comments[unsolved] Getting constant "Circular reference" warnings

 

Top 5 Comments

scorecomment
316/u/gerard4156 said Braille
148/u/PedroFPardo said Excel’s clipboard doesn’t work like the normal Windows clipboard. If you type something somewhere else in the document after pressing Ctrl+C, Excel will forget what you were copying, and to show this,...
108/u/Shahfluffers said I typically use LET when I have truly gnarly multi "if-else" formulas. Which tends to happen when calculating budgetary/payroll/benefit stuff. Example: - LET(rate01,C50,benefitName,A50,benefitAp...
90/u/CIP_In_Peace said You get more value out of Excel with AI if you know very well what Excel can do. So yes there is a need, but not as much as there maybe once was.
79/u/SolverMax said Wait until you find out about new lines (ALT+Enter) and indents (Space). =LET( _data, A2:A10, _threshold, C1, _rate1, C2, _rate2, C3, _total, SUM...

 


r/excel • • 9h ago

Discussion Learning Excel through Google Sheets – is that normal?

20 Upvotes

I recently bought an Excel course, but the instructors said we'll be doing all the lessons and exercises in Google Sheets because the two programs are supposedly 95% identical.

I'm curious if that's really the case. What do you guys think?


r/excel • • 20h ago

Game I made an excel style game for you. Play in browser, free, no signup

25 Upvotes

I made this fun little game where you have to hit a certain target each quarter. Or you'll get fired. It's a strategy/RNG game where you try to figure out different synergies to be able to hit the target. Don't play if you have anything productive to do!

https://gamesgamestudio.itch.io/excel-roguelite


r/excel • • 16h ago

unsolved Make Graph Lines Automatically Change Color Based on Series Values

7 Upvotes

I have a set of graphs that automatically update to reflect the last 6 weeks of data. These measure performance in terms of success rate, and all have a set target percentage that we want to hit/exceed. Currently the lines are all constant colors, but I would like to have the lines of each graph change color to show if they are meeting target or not for that week of data.

I could see this being presented 2 ways:

- If the value is below target, that entire line segment (last value to current value) turns red. If above, the entire line segment is green.

- Any part of the line that is below the target line turns red.

What is the best way to automate this in Excel 365? Obviously I could just manually change the color of the line segment, but I feel like there has to be a better way. I briefly messed around with gradient lines, but could not find a way to make the cutoffs automatically update as data changed. I also considered creating dummy columns to split the data into 2 series, 1 red and 1 green, but that was not displaying how I wanted, and the lines were not connecting.


r/excel • • 20h ago

Plugin Python embedded in Excel

9 Upvotes

Hi All,

This weekend for a bit of fun I built a free / source-available Excel add-in which hosts it's own Python runtime.

You can find a feature runtime and installation guide on the website:

https://sancarn.github.io/xll-python/index.html

fork it here: https://github.com/sancarn/xll-python

But here's an overview:

  • You can write user defined functions which execute like formula.
  • Returning a generator will make the result update every time it yield's a result.
  • You can write macros (e.g. reading / writing CSVs/databases from disk etc.)
  • There's an in-built IDE
  • You can debug formula in the IDE
  • There's a console/REPL where you can experiment with the available runtime
  • There's a package manager where you can install pip packages
  • There's a compiler so you can compile your own scripts into standalone .xll addins.

Hope you find this helpful! ~Sancarn

Edit: This project is AI:X. All code written by Astra & Sol 6.2; albeit with a lot of steering.


r/excel • • 12h ago

solved Option to modify cell styles not appearing when right clicking

2 Upvotes

Using excel for Mac standalone version, Microsoft 365 subscription, Version 16.115 (26110837) latest version as per the updater. I need to modify the cell style for hyperlinked cells like I used to do the past weeks, but recently the option for that disappeared probably few days ago, just noticed it last night. Right clicking on the cell styles does nothing. Anyone having this problem and how did you fix it? Tried signing in and out of the app, clear application data on the help tab, and restarting laptop. Thanks.


r/excel • • 1d ago

Waiting on OP Looking for practice questions of c-server type questions on excel

4 Upvotes

Hi everyone!

I'm looking for resources containing challenging, application-based practice questions involving queuing systems and service operations on microsoft excel.

I'm particularly interested in longer word problems where you're presented with a real-world scenario (example: a set of customer arrival and service data, and several interconnected questions that require you to analyse and interpret the situation).

Ideally, I'd like practice covering the following areas:

  • Average arrival and service time
  • inter-arrival time between consumers
  • Average waiting time and time spent in the system
  • Queue length and number of customers in the system
  • Server utilisation and traffic intensity
  • How adding or removing servers affects waiting times
  • Interpreting arrival/service patterns and making operational recommendations, etc

I'm especially looking for multi-part word problems that combine several of these concepts, rather than isolated questions involving direct formula substitution. I'd like to practise interpreting unfamiliar scenarios, deciding which calculations are necessary, and drawing conclusions from the results.

If anyone knows of relevant question banks, textbooks, practice papers, case studies or websites, I'd really appreciate the recommendations!

Thank you!


r/excel • • 1d ago

unsolved How to prevent Powerquery from re-downloading an excel file used as a source over and over?

31 Upvotes

I'm trying to use multiple excel files to automate a process that my predecessor would have to repetitively copy and paste from other worksheets.

The file i'm sourcing is about 200 kb. It's tiny. But each time I add a step to my query, it redownloads it at my workplace's potato speed internet.

I added Table.StopFolding and Table.Buffer steps and no dice. It still redownloads the thing, so each time I add a step as I work through this problem, it goes and redownloads the excel data like it's an addict.

I tried referencing the query that downloaded the data initially and even then, adding the reference? Better redownload that file. Renaming my reference query? Better redownload the file. I also turned off downloading the preview in the File/Options section, and doing that caused it to again redownload the file, which would be funny except i'm aleady kinda mad at it for ignoring my attempts to store 100 kb of data in memory.

Anyone had any luck with this? Some of my bigger projects can take 10-15 minutes to evaluate because of the length of time required to do these evaluations, and these are relatively simple but deal with much larger data sets.


r/excel • • 1d ago

unsolved Best Excel architecture for configuration control: 1 Master + 49 Sub-Packages tabs

10 Upvotes

I manage a risk/hazard register with 1 Master and 49 Sub-Packages, tracking Hazard, Cause, and Control Measures (one-to-many relationships).

The master register contains key details, which are common to all the sub package registers. The Sub package registers contain additional information

Current workflow & configuration pain points:

Bidirectional updates: Changes originate at a sub-package level, update the Master, and then all other 48 sub-packages must assess how the new/updated Hazard, Cause, or Control affects them.

Strikethrough text problem: currently use strikethrough formatting inside cells to indicate removed/amended Hazards, Causes, or Control Measures

Is maintaining a master sheet and 49 separate sub-package sheets the wrong pattern here? Or is there a cleaner Excel pattern for handling this?


r/excel • • 2d ago

solved Excel is rounding a multiplication formula and I don’t know why

30 Upvotes

The current formula would be A1*A2 where A1 is 20.1 and A2 is 2.09. I need it to give me 42.009 but it gives me 42.000 no matter how many decimals I allow it to display. I have no rounding parameters that I know of.


r/excel • • 1d ago

solved Excel overwriting previous rows without prompting

11 Upvotes

/preview/pre/f8fsqup0rt2i1.png?width=807&format=png&auto=webp&s=94623bdfe21729a2b5257394475a2c7665e1defe

Why is excel overwriting previous rows without prompting? To troubleshoot, I've gone in and disabled AutoComplete and Flash Fill in Excel options > Advanced > Editing options, but it's still happening. I would expect Undo to only undo the other changed rows, but it undoes everything. I'm using Excel 365 Apps for enterprise Version 2610.

Here's a video (expiring in 2 days) of me typing the new text and then hitting Undo https://streamable.com/67kcor

Edit: I'm unable to replicate the problem after doing other work, so I'm marking it as solved. Likely an intermittent bug in Excel.


r/excel • • 1d ago

Waiting on OP I am looking for a solution to a budgeting spreadsheet issue. I am trying to make a spreadsheet with a chart that shows the balance and the amount paid of credit card accounts, but I want excel to automatically calculate the monthly interest and count that into the equation.

5 Upvotes

Hello! I am trying to figure out how to add in an interest formula to auto-calculate the interest accrued on a credit card or loan account in order to make the visuals in my sheet be accurate. I have a line for balances and amount paid, but obviously the balance shifts due to interest daily or monthly depending on the account, so I'm wanting to have excel calculate that for me, so I'm not having to adjust the balance, I can just input the amount paid toward the account. TIA!!


r/excel • • 1d ago

solved Excel keeps not responding

2 Upvotes

Hey all!

I’ve been using excel on my MacBook for a project in uni, but every time I try to edit it’s just stuck loading. I’ve been having to force quit every time because it says my excel is not responding.

Any tips on how I can have excel running smoothly again? I’m not exactly tech savvy so any advice would be helpful!


r/excel • • 1d ago

solved Different rounding parameters in the same cell

6 Upvotes

Firstly, thank you all for all the help you’ve been the last day or two. It makes everything so much easier when I can ask a person instead of googling everything.

Cell G7 has a formula based on the values in cells G4,5,6. Cell G8 needs to round the number in G7. The specific formula I need is: if G4 is 0-1999 then I need the value in G7 to be rounded up to the nearest 100 in G8, if the value in G4 is >=2000 then I need the value in G7 to round up to the nearest 1000 in G8.


r/excel • • 2d ago

solved How can I create a tool that others can use to automatically modify a spreadsheet?

18 Upvotes

I work as a cycle instructor with colleagues, and we all download a simple xlsx spreadsheet with pupil details on at the start of the week. Not the same file, but exactly the same spreadsheet format no matter where everyone is working - just with different contents.

It doesn't display at all well on a phone (too wide and too much info), and the software people aren't willing to do anything about it. So I wondered if I could create something like a macro, to chop out columns we don't need to see, and change justification on boxes that might contain a paragraph of text that makes the sheet a mile wide. And then share that "macro" with everyone else, so they could apply it to the spreadsheet they download.

I can do this for myself, on my own desktop PC, but is there a really simple way, or perhaps some kind of tool or phone app people can get, that would make it so people who are less computer literate than myself (and I'm no excel expert) can easily do the same?


r/excel • • 1d ago

unsolved Sequenced numbers in parentheses

5 Upvotes

In one row can I do an increasing sequence (1/30) … (30/30) for example in the screen shot? No worries about the 100% on the left side, that is added daily.
Normally we type each cell individually so was just seeing if there is a better way


r/excel • • 1d ago

unsolved Green Triangle But No 'Error Options'

3 Upvotes

In the last few months I've had green triangles appear with no 'error options' when selected and no 'ignore error' available when I right click. Is this a new feature? I can't find any way to turn these off.

For clarity, I'm very familiar with resolving the usual green flag error. This seems new.

Searched, but apologies if I've missed anything!


r/excel • • 1d ago

solved The date from one spreadsheet is not copying over to another the way it should anymore.

3 Upvotes

I use certain Excel templates daily for work, but I did not create them and so I'm not sure what the disconnect is.

Part of my job includes downloading a spreadsheet from a website and then copying and pasting the info to one of our Excel templates. Part of this information is a date. In the past, I was able to copy the mm/dd/yyyy date from the source and then paste it onto our template and it would remain mm/dd/yyyy. The source spreadsheet recently changed a little bit, and I was able to configure everything just fine except the date.

Now, when I paste it over, it becomes some random numbers that don't seem related. For example, 11/24/2026 becomes 46350, 12/3/2026 becomes 46359, 1/8/2027 becomes 46395, etc. Those numbers are reflected in the formula bar. I have NO IDEA what's causing this. Further, when I go to type the actual date into the cell, it just comes becomes a bunch of pound signs while the formula bar reflects the date I typed.

I'm usually good at poking around and figuring things out on my own, but I'm stumped. I know this probably has to do with our specific formatting, but can someone possibly point me in the right direction to get this fixed? Any ideas at all?

Edit: Solved, thank you! I widened the column and made sure the cells were formatted as date. Still have no idea why this changed, as everything was fine up until yesterday when the source updated their spreadsheet, but it is what it is!


r/excel • • 2d ago

Discussion Why doesn’t a nested array broadcast in IF, but a thunk does?

5 Upvotes

We all know the neat trick of broadcasting with an IF condition: =IF(SEQUENCE(2),1) stretches the scalar across both rows.

I wanted to use it with Excel’s new nested array support, to get an outer array of size 2 where each element holds an inner array. But it unexpectedly returns #VALUE! errors:

=IF(SEQUENCE(2),{SEQUENCE(,2)})

There is a workaround: the old thunk technique. Wrapping the inner array in a LAMBDA makes it behave as a scalar, so it broadcasts:

=IF(SEQUENCE(2), LAMBDA(SEQUENCE(5)))

The catch is that you then have to evaluate the thunks with an iterator like MAP or REDUCE, so it feels a bit like a loophole. Not sure about it's efficiency either.

Is the #VALUE! error expected in the first place?


r/excel • • 2d ago

Discussion Is VBA Certification Worth It for a Document Controller?

4 Upvotes

Hi everyone!

I'm currently working as a Document Controller in the construction industry, and I've recently started learning Excel VBA.

My daily work involves handling Inspection Requests (IRs), document logs, tracking revisions, managing pending responses, organizing correspondence, and dealing with large amounts of Excel data.

I'm learning VBA because I want to automate repetitive tasks, improve my Excel skills, and become more efficient at my job.

I have a few questions for experienced VBA developers:

  1. Are there any recognized VBA certifications worth pursuing?
  2. Does VBA certification actually help when applying for jobs, or is practical experience more important?
  3. What real-world VBA projects would you recommend for someone working in Document Control?
  4. Is learning VBA still valuable in 2026, considering Power Query, Power Automate, and Python?
  5. Can strong Excel VBA skills make a difference in a Document Controller's career, especially in the construction industry?

I'd really appreciate hearing about your experiences and recommendations.

If you were starting your career as a Document Controller today, would you invest more time in Advanced Excel, VBA, Power Query, or Python? And why?"

Thanks!


r/excel • • 2d ago

unsolved Lost the modification I made to an excel file

3 Upvotes

Hello everyone

So I accidentally closed an excel file without saving an important modification I made to it and I really need it

  1. I tried to look for it in the file-info-unsaved files but it's not there
  2. I also copied it but I didn't have clipboard history on so it's not there either

Can you please give me any other suggestions or direct me to Somewhere I can pose this question again thank you very much


r/excel • • 2d ago

Discussion Found a weird XLSX bug (and some ways to fix)

19 Upvotes

I came across this weird Excel bug (while uploading product data to ChannelAdvisor/Rithum).

Some products wouldn't import their decimal values correctly, even though everything looked fine in Excel. It drove me crazy, but I was determined.

Turns out Excel saves certain numbers in a weird floating-point representation inside the XLSX file, while other (?!) numbers are saved as normal decimals.

You can reproduce..

Paste these into Excel:

0.06
0.07
0.08
0.075
0.095
0.135
0.266
0.28
0.288

Save as .xlsx, rename a copy to .zip, extract it, and open `xl/worksheets/sheet1.xml` in a text editor.

You'll see that 0.06 and 0.08 are saved normally, but 0.07 and the other numbers are saved with long decimal or exponential representations, such as `7.0000000000000007E-2`.

What's weird is that it isn't random. In my tests, 0.06 and 0.08 always save normally, while 0.07 and the others consistently come out differently.

I'm puzzled as to what algorithm produces this inconsistency.

I wonder if this could also affect lookups, comparisons, or even "=" formulas. It definitely causes problems with some parsers (like in my case)

Here's what I've tried:

Changing the number format doesn't help.

Converting to text =TEXT(A1,"0.###") works if your software accepts text values. (=round(A1,3) won't work). You can check the cell type using =ISTEXT(A1) or =ISNUMBER(A1).

Saving as .csv works! (but if you reopen the CSV in Excel and save it back as .xlsx, the problem comes back)

Opening the file in Google Sheets and downloading it back as .xlsx works! The downloaded file is a little bigger, apparently because it has more empty cells, but the numbers are saved normally and remain numeric.

IDK if saving as .xls helps. ChannelAdvisor doesn't accept .xls, so I couldn't know for sure (but roundtrip save to xls and then back to xlsx has the same problem)

I remember seeing the same behaviour years ago. How come this still hasn't been fixed?

Does anyone know why Excel treats certain decimal numbers differently, and whether there's a way to fix this in Excel itself (without converting the values to text)?


r/excel • • 2d ago

solved need a formula to base the content of one cell on another + IF/THEN statement

14 Upvotes

hello! i'm trying to update a spreadsheet for work and need some help with formulas.

context: i have a cell, J8, with a mm/yyyy in it (apr 2026). i need Q8 to be the year of J8 + 1096 (3 years), so 2029. i've got this part.

however, the year i'm working with is from 3/31 to 3/31, not 1/1 to 1/1. anything after 3/31 should be pushed to the following year. since apr 2029 is after 3/31/2029 (and before 3/31/2030), i'd instead need Q8 to read 2030. anything prior to 3/31/2029, but after 3/31/2028, would still be the year 2029. how can i incorporate this into the formula that i already have?

pretty unrelated but also a formatting question: can i use conditional formatting to change the color of a cell, F4, based on the date of F4, but only if the status of D4 is marked "HELD"? i need to follow up based on dates but when to follow up is dependent on the status of the file.

pls help!! thank u so much


r/excel • • 2d ago

solved Calculating from date to current date

10 Upvotes

Wanting to Calculate the time between a date and the current date. Would like for it to refresh to current date when opening. Ideally if it could format in how many weeks/days since the date would be great.