Error in exporting report to Excel

[dmbfan73]

I'm trying to export a report to Excel, but am getting the following error:

"Contract Listing 2 can’t retrieve the value of this property.

The property isn’t available from the view in which you’re running the macro or Visual Basic code, or Contract Listing 2 encountered an error while retrieving the value of the property.
To see the valid settings for this property, search the Help index for the name of the property."

Exporting to Word works fine, and exporting to Excel has worked before. I can't figure out why it's not working anymore. Any ideas?

 

[M8KWR]

instead of export the report to excel, would you prefer to export just the data, so export the query that is attached to the report..

Hope this helps.

 

[dmbfan73]

Thanks, I would have done that next but I figured it out. I have 2 lookup tables that feed dropdown lists, and in some records these fields were left blank. When I put data in them, the export worked fine. So now I made the dropdown fields mandatory.