Microsoft Excel – designed to be non-functional for advanced users

My job involves me working with a lot of Microsoft Excel files.  Many companies use it as a defacto database.  It also makes a handy data analysis tool in a pinch.  And Microsoft pitches it for all of these features.

But then I ran into an issue just yesterday where if you want to lock formulas but have the sheet be sortable, that isn’t something easy to achieve.  There is a workaround though!  Fear not!

But this workaround now doesn’t let users add new rows to the dataset.  The funny part?  Microsoft’s own UI gives you options for each of these independent events.  You would therefore think that this is all standard.  But no.  You can’t have the interface do something simple.

The worst part of all this is that I’m sure this is a situation driven by 1990’s programming challenges that were never updated in the newest version.  Heaven forbid Microsoft make something that works as advertised….

Advertisements

One thought on “Microsoft Excel – designed to be non-functional for advanced users

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s