Greetings

We are using MS Dynamics CRM 4.0 and dynamic spreadsheets (pivot table, bar charts, etc. in Excel 2007) for reporting,

When one of our users is prompted by the Data Connections security warning to 'enable this content' it clears all the data?

The .xlxs is saved locally and the user is within the network? Any ideas on how I can get this to work?

Thanks in advance,
Bon