Excel Oddity with Appointments and the Quick Fix

Not only is Excel vital to my team (in Finance we live in Excel) but it is also a huge piece of my daily work as an Admin. So today when my rows and columns were not agreeing it was cause for crisis. I do not take Excel malfunctioning lightly.

I went into the throw together a report of past appointments I stumbled across this little gotcha (pictured below):

The rows numbered 1 and 2 span one row in some columns but multiple rows in other columns. This does not a happy systems administrator make.

Unfortunately I took it as an Excel glitch, fought with it, gave it a good ol' reboot and was still stuck. When I finally slowed down and looked at the issue I realized that these rows represented Appointments with multiple "Required Attendees." Removing the Required Attendees column resolved the issue.

I am sharing this in hopes your day doesn't have the hit the speed bump that mine did. If you have a better work around for the issue please let me know in the comments.

Britta Rekstad

Britta spent several years as a Systems Administrator and Consultant in the Financial Services Industry focusing on configuration, training and automation. Currently she works with Microsoft Partners and Customer Organizations to provide training, documentation and oversight on system design.

She was awarded the Microsoft MVP award in 2015, 2016 & 2017 for her contributions to the Dynamics CRM Community. She carries out her passion for empowering systems administrations, budding consultants and university students through presenting, mentoring and guiding programming and events.