A recent error I received when attempting to export a Management Reporter report to Excel was the following:
“The given key was not present in the dictionary”
After several attempts I found that by eliminating one or both of the following situations resolved the error.
1) By unmarking the option “Export to a single worksheet”, I was able to export to Excel.
2) It appears the error also appeared when I had a value in the report footer. When I deleted the value in the footer I was able to export the report to Excel.
As mentioned, the error occurred when both situations were present or just one.