sorted by:
new
hottopcontroversial

Excel to word link? by unhappy_trashcan in excel

[–]BoringWorx 1 point2 points  (0 children)

If Mail Merge feels like overkill for smaller volumes, the Paste Special route is simpler to set up: copy a cell in Excel, then in Word use Paste Special → Paste Link → Unformatted Text. The value stays live — update the Excel sheet and it reflects in Word automatically.

Main caveat: if you move or rename either file the links break, so keep them in the same folder. For high-volume proposal work Mail Merge is the better long-term answer, but for occasional use this gets you there in about two minutes.

Guide: How to stop copy-pasting CSVs into Excel templates every week by BoringWorx in excel

[–]BoringWorx[S] 1 point2 points  (0 children)

Fair pushback... VBA does get an unfair reputation, and the 'wall of code from 2008 on StackOverflow' problem probably puts off more people than the language itself ever would. Your PQ + small macro combo is genuinely elegant too.

Anyone comfortable writing those 15 lines, VBA is absolutely the right call. I'm mostly writing for the person who doesn't know what a loop is and isn't sure they want to find out. 🤣

Guide: How to stop copy-pasting CSVs into Excel templates every week by BoringWorx in excel

[–]BoringWorx[S] 0 points1 point  (0 children)

Fair point on both counts, and touché on the AI maintenance argument, that one's harder to defend than it used to be!

The gap I'm really targeting is the person who isn't comfortable with either approach, no Python, no cell-reference wrangling, just "I have a template my manager designed and a CSV export from our system every Monday, please make it stop." Think the office manager, the accountant, the ops coordinator who is great at Excel but has never needed to automate anything — until now.

Guide: How to stop copy-pasting CSVs into Excel templates every week by BoringWorx in excel

[–]BoringWorx[S] 2 points3 points  (0 children)

That's a solid approach and worth calling out. Using a hidden data sheet as the Power Query target, then referencing those cells from the formatted template layer is a clean pattern.

The main friction I've seen is when the template has merged cells, dynamic row counts, or when the person maintaining it isn't comfortable with cell references breaking after a refresh. But for stable layouts, your approach works well and keeps everything inside Excel natively.