Get rid of warning for external data connection Hi, I\'m using an extelrnal data

Question

Get rid of warning for external data connection

Hi,

I'm using an extelrnal data link to collect data from a CSV file generated by a third party application. The CSV is continuouls filled, so I want to update the data every time I open the Excel spreadsheet. I set the option of the data link accordingly.

My probleem : every time I open the spreadsheet I hhave a security warning that disables the data connexion, and I have to manuually re-enable the connexion.

How can I get rid of this message??

Thanks.

Explanation / Answer

The data warning can not be disabled. You can't even use a macro to disable or cclick the warning message for you because the warning diisplays before VBA code runs.

What's needed is an aadditional option to always trrust the data source. Please take a moment to suggest to Microsoft that they include such an option in a future release of Excel. To display the suggestion form go to Excel's Help menu and choose Send Feedback.

Related Questions

Navigate

• Browse (All)
• Browse G
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.