3 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

This Week's /r/Excel Recap for the week of February 21 - February 27, 2026

Saturday, February 21 - Friday, February 27, 2026

Top 5 Posts

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

 

Unsolved Posts

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

 

Top 5 Comments

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...

 

submitted by /u/subredditsummarybot
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#Excel compatibility
#no-code spreadsheet solutions
#financial modeling with spreadsheets
#generative AI for data analysis
#natural language processing for spreadsheets
#cloud-based spreadsheet applications
#real-time data collaboration
#rows.com
#big data management in spreadsheets
#conversational data analysis
#google sheets
#intelligent data visualization
#Pivot Tables
#Power Query
#Excel migration
#Power BI
#data set
#special characters
#checkboxes