人気ブログランキング | 話題のタグを見る

drop-down list compatibility between Office 2007 and 2010 [Solved]

drop-down list compatibility between Office 2007 and 2010

I have creadted an excel file with drop-down list with Office 2007.
It really works very good.
I made several trial an every thing is ok.
However when I try to used the same file in other computer with office 2010 it doesn't work.  The problem is that when
I click in the arroy to deploy the drop-own list, the list is deployed but empty.
 
In second step,  a create from the beginnig the drop-down list  directly with excel 2010 and the result is the same.  Does anybody known how to fix this bug?
 
Thank you.

Solutions to the Problem drop-down list compatibility between Office 2007 and 2010

Download Error Fixer for Free Now

The formula for the validation list source uses relative references.
That means that the actual reference will change for each row, so in every row you will have a different list.
I assume that this is not the intent.

Row 2 will have 

=OPERADORES!A2:A75

the next rows will have
=OPERADORES!A3:A76
=OPERADORES!A4:A77
=OPERADORES!A5:A78
etc. 

To ensure that each row uses the same list for data validation, you need to use absolute references with a $ sign in front of the row and the column.
To do that, edit one of the data validation cells and change the "Source" formula to 

=OPERADORES!$A$2:$A$75

Tick the box at the bottom that says "Apply these changes to all other cells with the same settings"

Now all data validation cells will have the same list.

If that does not help, please share a sample file.

Here is how to share a file from your Skydrive: Please go to your Skydrive and upload the file into your Public folder.
Then click the file and select Share > Get a link

Copy that link and paste the url here.

Note: It is recommended that you back up your files and folders before attempting this step:

  • Move the mouse cursor over to the upper right side of the screen.
  • A menu will pop up on the left. Click on the "Settings" feature on the menu.
  • On the Settings window, click on the "Change PC settings."
  • Now, left click on the "Update and recovery" feature.
  • For the next step, left click on the "Recovery" feature.
  • There is an option here saying "Refresh your PC without affecting your files." There, left click on the "Get started" button.
  • Now, follow the instructions on the screen to finish the Refresh process.
  • After the Refresh process has finished restart your Windows 8.1 or Windows 8 device.
  • Check again to see if the error drop-down list compatibility between Office 2007 and 2010 has been fixed.

If you do not possess the technical expertise required to accomplish this yourself or do not feel comfortable doing so, download and install a powerful automated tool to get the job done.

Another Safe way to Fix the Problem: drop-down list compatibility between Office 2007 and 2010:

How to Fix drop-down list compatibility between Office 2007 and 2010 with SmartPCFixer?

1. Download Error Fixer . Install it on your computer.  Click Scan, and it will perform a scan for your computer. The junk files will be shown in the scan result.

2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been fixed.


Related: Change Cell Color If Character Count Exceeds A Certain Amount,Change One Hyperlink Style,Cant Install Internet Explorer 9 Beta,Cant Uninstall Older Version Of Microsoft Silverlight.,Change Downloaded Files Folder Path?..,Conditional Formula Help,Computers Started Having Problems At The Start, When They Are Turned On, All That Happens Is A Black Screen.,Computer Lock Up And Freezing,Computer Shuts Down Abruptly After Gaming For 5 Mins,Confusion Over Uninstall IE8,Deleting Blank Pages In Word While In Print Preview Mode,Delete Spaces Between Single Capitals In A Long Column Of Company Names? __,Date/time Change At Startup,Database Tables And Text Files No Longer Paste Correctly Into Microsoft Excel,Dell G2210 Monitor Compatibility With Windows 8,Divorced Dads Tips: Divorce 101 For Dads,Crabgrass Elimination,Stress: The Cause Of Poor Digestive Health,Ten Things You May Not Know About Michael Buble,Psychic Ability & Connecting It To You!
Read More: How to Fix Problem - Does Remote Desktop on Windows 7 machines work over the internet??,DPC watchdog on W8,Troubleshooting:Do you get same performance from GTA4 on different versions of Windows 7?,How to Fix Problem - DNS server address for wireless connection to home network is always 192.168.1.1 does not get correct DNS servers from router?,How Can I Fix - Does IE always tell to run a Website in compatability view??,Default Gateway Issue in Windows 7,Delete Browsing History Not Working,DEP shuts me out of internet explorer whenever I click on an item such as a picture, calendar, etc.,debug.log using up 450 gb on hard drive,Do I need all these programs?
by NoOutputDevice | 2016-09-30 09:52