tracking code
LBMC Technology Solutions
  • Home
  • Solutions
    • Dynamics 365
    • Dynamics NAV
    • Dynamics GP
    • Dynamics CRM
    • Sage Intacct
    • Document Management (ECM)
    • Network Engineering and IT Solutions >
      • IT Security
      • Managed IT
      • Business Phone Systems
  • Events
    • All Upcoming Events
    • Training / CPE
    • Webinars and Workshops
  • Resources
    • Blog
    • Forum
    • On-Demand Webinars
    • Referral Program
    • Services We Offer
    • Support
  • About Us
    • Careers
    • Partner with Us
    • Community
    • Contact Us

How to get rid of the data validation rules pop-up in Excel

3/21/2016

 
Posted by Jim High

Exported data from Dynamics CRM 2016 into Microsoft Excel has some additional formatting that wasn’t included in previous versions.  This is helpful in many cases, but can also present some frustration if you aren’t accustomed to working with that type of table.  I talk about how to convert the data from a table to a simple range of cells in a previous post. 

One additional annoyance can occur even after converting your data to range, which is click on a cell in your exported dataset.  By default every time you click on a cell in that range, it will show you the data validation rules.  The problem is that sometimes it covers up information you’re trying to view in adjacent cells shown below.  It may also prevent you from entering data in those fields if you are doing some Excel manipulation. 

get rid of the data validation rules pop-up in Excel

Fortunately, there is an easy resolution.  First, select all of your cells in the worksheet so that the change affects your entire spreadsheet. 

get rid of the data validation rules pop-up in Excel

Go to the “Data” tab in your ribbon bar, then click on “Data Validation” drop down menu and then “Data Validation…”

Picture

In most cases, you’ll get a warning saying the selection contains more than one type of validation.  That’s fine since we want to affect them all anyway so click “Ok.”  If you don’t want to remove them all, then hit “Cancel” and change your cell selection first. 

get rid of the data validation rules pop-up in Excel

That will bring up the Data Validation window.  You have two options.  If you want to just hide the input messages, uncheck the “Show input messages when cell is selected”.  If you want to remove the validation altogether and allow you full control of the worksheet, click on the “Clear All” button in the bottom left corner of the window.  Once you click “OK” to close the window, all of those annoying popups will be gone. 

get rid of the data validation rules pop-up in Excel

Remember that cell selection is important.  If you fail to select the entire worksheet, then this will only work on the particular cell(s) you have selected.  Happy exporting!


Contact Us

Comments are closed.


    Blog

    ​Your one stop shop for technology.

    Categories

    All
    Business Central
    Dynamics 365
    Dynamics CRM
    Dynamics GP
    Dynamics NAV
    Events
    Microsoft Dynamics Add-ons
    Software Decisions
    Tutorial

Solutions
Microsoft Dynamics 365
    Business Central
    Customer Engagement
Microsoft Dynamics NAV
Microsoft Dynamics GP
​Microsoft Dynamics CRM
​Sage Intacct
​
Network Engineering

​ERP Comparison Guide
Learning Opportunities
All Upcoming Events
User Conferences
Training / CPE
Vision
Webinars & Workshops
​

Resources
Blog
Forum
Referral Program
​​YouTube Channel

Company
About Us
Careers
Contact Us
​
Locations
Charlotte
Knoxville
Nashville
Picture
Picture
Proudly powered by Weebly

Sitemap | Home | Careers | Contact Us

share

Copyright © 2019

LBMC Technology Solutions