Results 1 to 7 of 7

Thread: How to check data validation compatibility of excel 2010 on excel 2007

  1. #1
    Join Date
    Feb 2011
    Posts
    54

    How to check data validation compatibility of excel 2010 on excel 2007

    Recently I have got a job in good company. This company has provided me laptop for office work. This is good configuration laptop. It supports all most all application. But in this laptop Microsoft office 2010 is install. I don’t know much more about the Microsoft office 2010. I use to Microsoft office 2007. Because I installed office 2007 in my laptop. I prepare the workbook in excel 2010 because I am in office. When I return at home then open this file in office 2007. How to data validate on the office 2007. Because laptop is not permission to bring at home from office. When I save the book in 2010 and opened in 2007, data validation has completely disappeared. If I save the book in 2007 and opened in 2010, data validation is intact.

  2. #2
    Join Date
    Nov 2008
    Posts
    1,192

    Re: How to check data validation compatibility of excel 2010 on excel 2007

    I want to tell you that you should know about the compatibility mode. You know latest version is run on the older version. But the older version runs on the latest version. Because it is policy of the company and also some modules are added means enhance the older version. It is not big issue. I can tell the process how to see the data on your pc. When you create the spread sheet in excel 2010. After creating when you will save the file then you will see the top corner in the excel sheet click on the logo then you will go to save as and then click then you will see older versions option is available. Save as in which version you want to see.

  3. #3
    Join Date
    Mar 2010
    Posts
    183

    Re: How to check data validation compatibility of excel 2010 on excel 2007

    I would like to tell you about me I have also same issue. But I am not sure with named collections. I don’t know what you mean. In previous version I used the functions first time. And including the standard data validation. Then you will see dependent data validation and Vlookup orientations. Everything I know and work very smoothly for me and also my friend who use the Microsoft office 2010. He also use to Microsoft office 2007 but he didn’t use data compatibility. I think it is non- existence in 2010. If anyone knows something extra then post there.

  4. #4
    Join Date
    May 2008
    Posts
    979

    Re: How to check data validation compatibility of excel 2010 on excel 2007

    Well, I have also used Microsoft 2010 office tools. And I also use to excel sheet for preparing my records. But I want to tell you the main solution first you create a test file with data validation record. The try it for opening in Microsoft excel 2007 and check the result if any problem arises. Then try to repair it respire it. I am giving you the link where you can see the steps. Please read this file carefully and follow the steps. The link is repairing the workbook.

  5. #5
    Join Date
    Mar 2010
    Posts
    183

    Re: How to check data validation compatibility of excel 2010 on excel 2007

    You should know more about the Microsoft office. You can download the PDF or e-book from the internet. I don’t know what do you know about the Microsoft? But I want to tell you that latest version never run on the older version. And you can never upgrade the older. But you can purchase the latest version. But you can see you file in excel 2007. But one thing you will have to do. Only when you save your file then always save in older version. I want to suggest you that you learn on the net about the office tools.

  6. #6
    Join Date
    Mar 2010
    Posts
    106

    Re: How to check data validation compatibility of excel 2010 on excel 2007

    This is inadvertent behavior. I have been able to reproduce the problem internally. Also, I did some research on the problem and found that the Excel development team knows about the subject. The error is actually in Excel 2007 does not, Excel 2010. A fix is being considered for Office 2007 Service Pack 3. I am telling you something you will do this steps may your problem will be solve first you clear the validation from the cell and then after you will select the cell and then click editing section and then click clear and then clear all data.

  7. #7
    Satyrs Guest

    Re: How to check data validation compatibility of excel 2010 on excel 2007

    Well, really this problem too big for the beginners. I think when this problem exist in excel in 2003 then there is option for updating the share point lists then now it removed from later. In 2007 you can update the spreadsheets which have data validation. But I want to suggest you that you should use the license version of 2010 because in 2010 this problem has removed this problem. So if you will use the office 2010 the I’m sure you will not face this problem.

Similar Threads

  1. How to turn off compatibility Checker in Microsoft Excel 2007
    By CeLeStiA in forum MS Office Support
    Replies: 2
    Last Post: 21-02-2012, 02:20 PM
  2. Data Validation not working in Microsoft Excel
    By Indudep in forum MS Office Support
    Replies: 2
    Last Post: 09-02-2012, 07:35 PM
  3. Data validation and Auto-complete help on Microsoft Excel
    By ashwin2012 in forum MS Office Support
    Replies: 2
    Last Post: 24-01-2012, 07:43 PM
  4. Compatibility issue with Excel 2007 VBA
    By KALYAN23 in forum Software Development
    Replies: 3
    Last Post: 18-09-2009, 12:01 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,641,288.31437 seconds with 17 queries