I am trying to export an Access report to excel, but receive the following message:

" (the database) can't retrieve the value of this property. The property isn't available from the view in which you are running the macro or Visula Basic code, or (the database) 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."

The error message would be greeat if it actually identidified what "this property" is! Any idea what the issue is? I have successfully exported other Access reports to Excel. Hoping there is a work around...