
From the advanced find I am exporting to excel. If I choose Static worksheet with records from this page - there are no issues. If I choose Dynamic Pivot Table or Dynamic worksheet - no data shows up in excel. I get the error "This field has no items".
I have done the following to try and solve this issue, but none have worked.
1. I have enabled macros in excel (it prompts every time, anyway to get this setting to stick?)
2. I have created an ODBC connection to the database.
Any help would be great!
*This post is locked for comments
I have the same question (0)I have never seen that error but you can make the settings stick by adjusting your Excel security to allow macros. Obviously this increases security risk.
Leon Tribe
Want to hear me talk about all things CRM? Check out my bloghttp://leontribe.blogspot.com/
or hear me tweet @leontribe