How-To Geek on MSN

Why you should never link to another Excel workbook (and what to do instead)

Stop using fragile direct links—Power Query creates faster, automated, and more robust workbook connections.
Geeky Gadgets

How to Combine Excel Files from a Folder with Power Query

What if you could turn the tedious task of combining transaction files into a quick and easy process? With Power Query in Excel 365, you can do just that. This powerful tool allows you to merge files ...
Network World

Find and Replace in an Entire Folder of Excel Workbooks Using Easy-XL

Say that you have hundreds of similar Excel workbooks in a folder and you need to globally change “2009 Budget” to “2010 Budget” in all of the workbooks. This will be a long tedious process for ...
Ars Technica

Excel, create a link to a mapped drive/folder in Citrix?

Okay, so I keep an excel spreadsheet of stuff I'm working on. This is on my workstation. We also use Citrix for some web admin type of stuff.<BR><BR>What I want to do is create a link in excel that ...
TechRepublic

How to sync Microsoft Lists with Microsoft Excel

The article How to use Microsoft Lists to organize Excel data you must track or share is an introduction to sharing Microsoft Excel data with other users via a list prepared by the Microsoft Lists app ...