MOPS07: Cannot Export My Tasks to Excel

I wanted to document this interesting issue.  (Well, interesting to me at least).  All credit goes to Ijaz Rasheed for identifying and researching this issue.

 

The Problem

Users attempt to export their My Tasks page to Excel.

image

Excel throws an error:

image

Clicking “Yes” only makes things worse…

image

The Workaround

Instead of using the menu to export to Excel, right click somewhere on the My Tasks grid, and use the IE Export to Excel feature.

image

The result is a messy Excel document however.  Until you show your end users how to develop a macro to clean it up, they will likely be unhappy.

image

 

The Solution

The issue is caused by specific fields on the My Tasks page.  As of today, based on Ijaz’s research, it would appear that the issue is consistently caused by having blank dates on the My Tasks page.  For instance, if you add the Actual Start or Actual Finish fields to the My Tasks page.  Until they are all filled out, you will not be able to export to Excel.

The solution is to remove the blank date fields from the My Tasks page.  Add them to the Assignment Details page, and encourage your end users to click through to there to fill in Actual Start and Actual Finish.

Tags:

One Response

  1. GregDC July 23, 2010

Leave a Reply

x

We use cookies to ensure the best possible experience on our website. Detailed information on the use of cookies on this site is provided in our Privacy and Cookie Policy. Further instruction on how to disable our cookies can be found there.