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

Is it worth learning VBA in 2026, or should I shift to Office Scripts? (Confused about my workplace dynamic)

Hey everyone,

I'm currently facing a bit of a dilemma regarding what to learn next to automate my Excel workflows, and I could really use some advice based on my workplace situation.

My Situation:

  • My Team: We mostly use standard Excel with formulas. The team is very comfortable with formula-based sheets and prefers keeping things simple.
  • My General Manager (GM): On the other hand, my GM heavily uses VBA for macros and automation.

Given that it's 2026, I know Microsoft is pushing Office Scripts (TypeScript) for cloud/web compatibility, but my immediate boss (GM) is still all about VBA.

Should I spend time mastering VBA just to align with my GM, or should I invest my time in Office Scripts/Power Query since they are more future-proof? What would be the smartest move here?

Thanks in advance!

submitted by /u/Accurate_Roll6593
[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
#cloud-based spreadsheet applications
#financial modeling with spreadsheets
#Excel alternatives
#natural language processing for spreadsheets
#generative AI for data analysis
#real-time data collaboration
#automation in spreadsheet workflows
#real-time collaboration
#rows.com
#AI formula generation techniques
#google sheets
#cloud-native spreadsheets
#generative AI automation
#formula generator
#workflow automation
#cognitive automation
#machine learning in spreadsheet applications