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 


the next rows will have

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 


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 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

Constant Refresh Tech Support

Constant Refresh

It seems the installation of IE8 has led to a situation where my home page (Google) is in constant need of refreshing (the green bar at the bottom of the page).  Why can't the pages load completely on their own?  Thanks...

Solutions to the Problem Constant Refresh

Download SmartPCFixer to Fix It (Free)

Are you stating that the Google Website is constantly refreshing itself?
Do you have issues with other web sites?

If you recently installed IE8, uninstall it, reboot then install it again.


Because of this Constant Refresh error, Windows can fail in starting some processes and the system's performance can significantly slow down. In some cases, Windows has problems starting up and the system can freeze.

Lastly, this error Constant Refresh can even result in the Blue screen of death error message, just like other critical Windows errors. If any of the above problems and symptoms occur in your PC, then you should immediately seek to resolve this problem.

In order to resolve Constant Refresh error or repair the corrupted and damaged Windows files, you will need a Constant Refresh error repair tool. There is more than one method of treating this kind of error code, and here is how you can manually do it:

  1. Start the computer and log in as administrator
  2. Go to the start button and select All Programs. Go to Accessories, System Tools, and then System Restore
  3. Click on System Restore and in a new window, select the 'Restore my computer to an earlier time's option and click Next
  4. On the new confirmation window that appears, click Next
  5. Restart your computer after the restoration has been completed

Another Safe way to Repair the Problem: Constant Refresh:

How to Fix Constant Refresh with SmartPCFixer?

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

2. After the scan is finished, you can see the errors and problems which need to be fixed.

3. When the Fixing part is finished, your computer has been speeded up and the errors have been removed

Related: Can Not Install Update KB2509553 On OS Win XP.....many Times Attempted,Can We Have Multiple Users Using The Same Excel 2007 Template When They Login To A Terminal Server ?,Can Or Will The Dell Dock Harm My Computer?,Can't Connect To A Wireless Network With A Wireless Laptop,Can't Establish DDE Connection To Excel Starter 2010 From Word Starter 2010,Changing The Default In The Access Find And Replace Box,Charts In Excel - Show All Months,Cant Find Graphics Card After Reinstall Windows 7,Changing Sheet Names In Multiple Graphs Using VBA,Changing A Single Row Of Data Into Multiple Columns,Computer Not Starting In Any Mode - Normal Or Safe,Conditionally Change Backcolor Of Cell Depending On Date,Computer Said Operating System Corrupt And Shut Down, Now Will Not Start At All,Computer Freezes When Idle And I Have To Reboot,Computer Starts Up Slowly
Read More: [Solved] Control panel not responsive,Tech Support: Control Panel and Windows Explorer Won't Start,Troubleshooter of Error: Constant Error Message at Log in.,How Can I Fix - Continuing text past section break?,Solution to Error: convert a cells text to basic html code,Changing Outgoing Mail Port Number to "587" as required to use Comcast E-Mail,Check box for sign off,Computer freezes when saving picture,Computer randomly freezes and restarts.,Computer won't wake from sleep with Windows 7 sp1 installed
by NoOutputDevice | 2016-09-23 17:29

Color a Shape

I am trying to to assign a color to a Shape that is the same color as the background color of a cell.
 Code like:

ActiveSheet.Shapes("MyShape").Fill.ForeColor.SchemeColor = Range("A1").Interior.ColorIndex

does not throw an exception, but the assigned color is wrong.

Is there an easy way to assign SchemeColor values based on ColorIndex values?
Do I need a translation table?

I would like this to work on Excel 2007 and versions of Excel prior to 2007.

Solutions to the Problem Color a Shape

Download Error Fixer (Free)

SchemeColor was introduced in Excel 2007 so you can't use it in older versions.
Shapes don't have a ColorIndex property, so you should use the Color of the interior of the cell:
ActiveSheet.Shapes("MyShape").Fill.ForeColor.RGB = Range("A1").Interior.Color

In this method we will try to Boot in Safe mode with Networking and see if the error still persists.

  • Search "MSCONFIG" and Open.
  • Click on Boot Tab
  • Tick Safe Boot in Boot Option
  • Select Network.
  • Click Apply and OK.
  • Reboot your System.

Recommended Method to Repair the Problem: Color a Shape:

How to Fix Color a Shape 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 finished, 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: Cannot Download Flashplayer,Cannot Install Windows Update Error 8024A000,Cannot Display Website/ DNS/UNABLE TO CONNECT TO WEBSITE,Cannot Find Driver For Conexant AC-Link Audio Driver For Windows 7,Cannot Edit Hyperlink Using Alt F9,Cannot Open My Layout & Editing Program,Cannot Open XML Links In Excel 2010.,Cannot Open MSSQL$ACT7 Service Since Updating To Windows 8.1,Canon Zoom Browser EX Won't Work Error "Zb Module Has Encountered A Problem And Will Close",Cannot View Certain Pictures And Videos In Internet Explorer 8,Changing The Number Of Logical Processors.,CD Writer Not Functioning / Not Recognised By XP,Can’t Download Apps From Windows Store,Change What Programs Open When I Log Into My Computer,Checkbook Register Zero Colum Display
Read More: Fast Solution to Error: Check consistency message,Fast Solution to Error: Change what programs open when I log into my computer,Change cell color when if/then is true [Anwsered],Fast Solution to Problem: Change PC settings and Metro Apps Constantly Crashing\/Not Working.,[Anwsered] child's laptop is not able to connect to internet even though i have a westell wireless,Cannot display Chinese in the NotePad6.1 (Win 7),Cannot add favorites “Unspecified error”. - Cannot create a Favorites in a new folder,cant set yahoo mail as default using VISTA I downloaded and installedlatest messenger and toolbar,Cant boot into windows 8 after resizing primary drive.,Ccleaner, Malwarebytes does not open up
by NoOutputDevice | 2016-09-19 17:26

Cannot receivve email from POP3 server on Outlook 2013

I was forced into moving into Windows 8 from Windows XP because my computer died.  Then I found out that none of my Office Software worked on Windows 8, now I am told by Verizon that Outlook 2013 does not work with POP3 servers.  Say it ain't so Joe! I
can receive by setting the incoming to incoming.verizon.net; but neither outgoing.verizon.net nor smtp.verizon.net work.  Is there a secret magic setting that I need?

Keys to the Problem Cannot receivve email from POP3 server on Outlook 2013

Download Error Fixer (Free)

Make Sure that your Hardware Meets the System Requirements

Microsoft Windows Requirements :

  • 1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
  • 1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit)
  • 16 GB available hard disk space (32-bit) or 20 GB (64-bit)

You need to double-check your computer's hardware configuration against the following Microsoft requirements. If your PC hardware is not up to par, then make sure you upgrade where necessary before continuing.

Another Safe way to Repair the Problem: Cannot receivve email from POP3 server on Outlook 2013:

How to Fix Cannot receivve email from POP3 server on Outlook 2013 with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your computer.  Open it, and it will scan your computer. The errors will be shown in the scan result.

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

3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in this software. Like dll downloading, windows updating and print spooler error repair.

Related: Batch Re-arrangement Of Excel Columns With Multiple Files,Black Screen Followed By Extremely Slow Boot, But No Entry In Event Log,Baixar Mfc.100dll,Bang Authenticate Dll Error - Receive Error Message: "Internet Explorer Cannot Display The Webpage",Black Screen And Restoring To Factory Settings,Browsers Are All Set To Unavailble And I Can Not Change The Default,C:\Users\MyName\Favorites\Favorites\Favorites\Favorites\Favorites\Favorites\Favorites\Favorites\...\Favorites Refers To A Location That Is Unavailable.....bla Bla Bla__,Calculate "Median" In Totals Row Of Pivot Table,Brightness Does Not Work After Downloading The New Windows 8.1 (ATIV Book 8),BSOD While Browsing With Chrome - Crash Address Ntoskrnl.exe+5a440,Can Someone Tell Me What The Different Is In Using A Subform In A Main Form Instead Of Creating A Form Outside Of The Main Form And Dragging It Into The Main Form?,Can I Uninstall IE10 Directly Back To IE8?,Can I Work With Excel Spreadsheets And Make Changes On Them On A Kindle Fire Or Ipad,Can't Get A Used To Part Of The Network PC Connect To Regular Internet At Home.,CAN'T DOWNLOAD ATTACHMENTS FROM EMAIL OR DOWNLOAD ANYTHING FROM A WEBSITE,Can't Install AutoCad 2009 On Windows 7 As It States Can't Install On This Version Of Windows,Can't Get Rid Of Network Place That Is Powered Off...?,Can't Pair Blueant X5i Wireless Headset With Windows Vista.,Can't Shut Down Windows 7,Can't Send Emails On Windows Mail --- Error 0x800CCC0B Comes Up
Read More: [Solution] Canon Digital Rebel XT 8MP EOS Digital Camera,Troubleshooting:Cannot send emails, error message 0x800ccc7d Error,cannot sign into widows messenger__,Troubleshooting Cannot see the Event log in Event Viewer for the Oepn Program Error,Fast Solution to Error Cannot Print Specific Excel File,Can you have Multiple security programs?,Can someone tell me how I can get rid of Microsoft Visual++++ Runtime error?,Can't boot up on Windows 8 recovery disks,can you read this minidump file please?,Can't Find Windows Fax and Scan
by NoOutputDevice | 2016-09-14 11:41

can't login to Windows live from W7 IE8 laptop.

can't login to windows live (mymsn, hotmail, etc.) on W7 IE8 laptop.  All other computers can log in with a variety of configurations.  Is there some default security/access setting that changed?

Anwsers to the Problem can't login to Windows live from W7 IE8 laptop.

Download SmartPCFixer for Free Now

·         Are you getting this error when you are attempting to sign in to Windows Live?
·         Are you able to login and access other websites?
You may try optimizing the Internet Explorer and then check what happens.
“How to optimize Internet Explorer”http://support.microsoft.com/kb/936213
Also refer to “You cannot log in to or connect to secured Web sites in Internet Explorer”http://support.microsoft.com/kb/813444
Microsoft Answers Support Engineer
Visit ourMicrosoft Answers Feedback Forum and let us know what you think.

If this post helps to resolve your issue, please click the "Mark as Answer" or "Helpful" button at the top of this message.
By marking a post as Answered, or Helpful you help others find the answer faster.

Running System Update Readiness Command

On running the System Update readiness Command, it will Detect & Replace Incorrect Registry data with the Correct one. Which may ultimately Solve can't login to Windows live from W7 IE8 laptop. in Windows.

  1. Open CMD as Administrator by Simply Right Clicking on Start button > Command Prompt (Admin).
  2. Now Type or Copy paste "DISM.exe /Online /Cleanup-image /Scanhealth" and hit Enter,
  3. Now again Type or Copy paste this "DISM.exe /Online /Cleanup-image /Restorehealth" and hit Enter.
  4. Close the Command Prompt Window because we are done.

Try and see if you still get the same error can't login to Windows live from W7 IE8 laptop. in your Windows.

Note: You may be prompted to enter your administrator's password when you try to execute certain system tasks!

Recommended Method to Repair the Problem: can't login to Windows live from W7 IE8 laptop.:

How to Fix can't login to Windows live from W7 IE8 laptop. with SmartPCFixer?

1. You can Download Error Fixer here. Install it on your system. When you open SmartPCFixer, it will perform a scan.

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

3. When the Fixing part is finished, your computer has been speeded up and the errors have been fixed

Related: Being Blocked With My Email,Bad Directory Name When Trying To Install A Program.,Bckgzm.exe-system Error: The Program Cant Start Because Opencl.dll Is Missing From Your Computer.try Reinstalling The Program To Fix This Problem.,BAD_POOL_HEADER ERROR - WINDOWS 8,BIOS, Checksum, .NET Framework Or Registry Errors. Having Problems With All. Help,Can't Find Out How To Get Rid And Search For Anything Else Using Internet Explorer On Windows 8.1.,Can't Boot Into Win 7 X64, BSOD (system_service_exception, STOP: 0x000003B), Seems To Be Related To Win32k.sys,Can You Insert Dashes Into A Number Sequence?,Can You Modify Value Field Colum Settings In Pivot Table To Delete The "sum Of" Or "count Of" And Just Have A Single Word For The Data?,Can't Find Account Picture
Read More: Troubleshooting:Can't access Portfolio Manager.,Fast Solution to Problem: Can no longer browse to save export flat file to a specific location.,How to Fix Problem - Can not download file - others can.?,Solution to Error: Can List Styles be based on Normal?,How to Resolve - Can you print two or three spreadsheets on the same page. All spreadsheets are in the same workbook.?,Can anyone help me troubleshoot this "no network/internet access" problem?,can't display Windows or Microsoft Updates Page any more with IE8,Can not recieve e-mail The connection to the server has failed.,can't download windows update, can't install service pack 1,Can not print to a network printer from IE7
by NoOutputDevice | 2016-09-08 12:46