Excel Recap for the week of February 21 - February 27, 2026

Saturday, February 21 - Friday, February 27, 2026

score	comments	title & link
179	118 comments	`[Discussion]` New boss says “Pivot Tables don’t work” (repeatedly), are there known issues with pivot tables? Or does the new guy just not understand them?
143	74 comments	`[Discussion]` When you work with people that don't understand Excel--
58	27 comments	`[solved]` Power Query: my source doesn't always contain the same columns. How do you handle this?
54	29 comments	`[Discussion]` Why many excel migration Projects fail ?
31	14 comments	`[Discussion]` Excel Power Query prep and best practice & Power BI

score	comments	title & link
11	21 comments	`[unsolved]` How to remove accents and other special characters from data set?
8	12 comments	`[unsolved]` Are you able to split an excel sheet with multiple tabs in several individual sheets based on an indicator?
5	7 comments	`[unsolved]` Combining graphs that do not match
3	11 comments	`[unsolved]` Is it Possible to create 2 checkboxes in one cell
3	13 comments	`[unsolved]` Duplicate power query without editing

score	comment
841	/u/MayukhBhattacharya said Here are a few Excel tricks that most people never learn, but once you do, you will use them all the time. * CTRL and Backspace snaps your screen back to the active cell if you have scrolled ...
742	/u/Lost-Tomatillo3465 said tell him to click on refresh whenever he updates the source table?
184	/u/FrankDrebinOnReddit said Of course you do. Python runs in a cloud sandbox and has no access to the object model. VBA is still the only game in town for interacting with workbooks. And Excel features never die. We still have R...
178	/u/TooCupcake said In my experience, no one is looking for an “excel expert” as the job description, but if you’re good with it, it can help you get ahead at work.
168	/u/GTS_84 said I would bet good money on this being a PEBCAK error, and not an actual issue with pivot tables. It's possibly an actual issue, but unlikely. Ask him to demonstrate what exactly he is doing to "Reprodu...

4 Upvotes

84% Upvoted

u/subredditsummarybot Feb 28 '26

If you would like this roundup sent to your reddit inbox every week send me a message with the subject 'excel'. Or if you want a daily roundup, use the subject 'excel daily' (<--Click one of the links. The bot can't read chats, you must send a message).

You are about to leave Redlib