web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Crm Export to excel dy...
Microsoft Dynamics CRM (Archived)

Crm Export to excel dynamic worksheet connection string issue

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

when exporting  Data from CRM to a Dynamic PivotTable or dynamic worksheet on of our customers runs into an error "Unable to open <URL>. Cannot locate the Internet server or proxy server". 

On further inspection we found out that the url in the connection string of the generated excel file is wrong. The Query_from_Microsoft_CRM connection string states "https://<organization>.xxx.com/_grid/print/print_data.aspx?tweener=1". Correct would be "https://crm.xxx.com/&lt;organization>/_grid/print/print_data.aspx?tweener=1". 

CRM 2016 and Excel 2016 facing IFD with Microsoft Dynamics CRM for Outlook installed and configurated with the correct server address. When exporting to an dynamic worksheet the worksheet is filled initally but can't be refreshed. The crm service endpoints are correct. 

Where can I define the connection string that is used when creating the excel file? 

*This post is locked for comments

I have the same question (0)
  • ScottDurow Profile Picture
    ScottDurow 21 on at

    Hi Stefan,

    Do you have the outlook add-in for Dynamics installed? It's required to refresh data.

  • Community Member Profile Picture
    Community Member on at

    Thanks for your reply, Scott.

    I'm a coworker of Stefan.

    The Outlook Add-In is installed and it is working fine.

    Without the Add-In the CRM-Refresh Button wouldn't be visible.

  • Community Member Profile Picture
    Community Member on at

    Thany you Scott for your quick reply. 

    The outlook addin for dynamics crm is installed and working. 

    My best bet is that the wrong connection string is some leftover from an former upgrade. Unfortunately I can`t figure out where it is stored... Do you have any ideas?

    Best regards

    Stefan

  • Community Member Profile Picture
    Community Member on at

    was this resolved. we are facing the same issue

  • Community Member Profile Picture
    Community Member on at

    Unfortunately not. We are waiting for the next upgrade. Maybe the Problem solves itself this way

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans