Skip to content

{ Category Archives } Excel

Repairing links in Excel documents

Another off-topic post today, because lately it’s all been migrations – Exchange migrations, data migrations, printer migrations…. I think I might have to rename this blog Miss Migrations! As part of an enourmous data migration involving server name and drive letter changes, I was tasked with repairing links in thousands of Excel spreadsheets. We trialled [...]

powershell: Retrieving data from Excel

I would love nothing better than to do one ILM project after another, but it doesn’t always pan out like that, so now I’m back to the bread-and-butter work of server installations, email migrations and security audits. Still, it’s giving me an opportunity to get my powershell skills up to date. This post, after some blurb, includes a [...]

Tagged

Updating AD attributes from an Excel spreadsheet

You don’t always have access to a proper IdM system. At the moment I’m at an organisation which still uses the old, manual ways of updating AD. I was asked if I knew an easy way to update the mobile phone numbers of a list of users, the data having been sent to Helpdesk in [...]