Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Following on-prem CRM 8.1 links from Excel 2016

Posted on by Microsoft Employee

Hi,

I have been researching this issue for a while now, but have yet to see a definite answer... so here goes, we have a pretty large spreadsheet with loads of CRM links in it. When a link is clicked in the worksheet, Excel becomes non responsive for about 45 seconds before loading the page. 

I have performed the following tests before posting the question:

1. This behaviour is for CRM links only; any other links added to the same spreadsheet open instantaneously or with a maximum delay of 3 seconds.

2. Ran office repair - shaved off about 5 seconds the first time, no difference after.

3. Changed security settings on IE to MS recommendation. (and yes, the CRM URL is under trusted sites)

4. Disabled all add-ins - no difference

5. Ran Excel in Safe mode - no difference

6. Works well when the document is in protected mode, but the spreadsheet needs to be edited when being worked on.

7. Tried with Excel On-line - CRM links on a new workbooks work fine, but the shared worksheet used in the office cannot be opened in Excel online as Data Validation is not supported. (Google sheets is not an option - security)

Any and all help is appreciated.

Thanks,

Saad

*This post is locked for comments

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans