In this article, I analyze the “Could not complete the operation. One or more parameter values are not valid” error when trying to manage Outlook rules after a Windows system update. Then provide a solution for the problem.

Hardware/Software Configurations:

My computer has Windows 7(64bit) and Outlook 2010(64bit) installed. Both work perfectly without any problems. But things change after a Windows system update …

Note: I have set Windows system update to auto update mode.

Symptom:

Last night, Outlook continued working smoothly. When I shut down my computer, I see Windows update message “Please do not power off or unplug your machine. Installing update ## of ##”.

As Windows update frequently, I do not pay much attention to that. Just let it go.

However, this morning, when I try to start Outlook as usual, I see a warning message “Outlook is not the default email client”. I just check the option to reset Outlook as the default one and proceed.

Then, in my Outlook inbox, I see a lot of new incoming emails. Originally these emails should be filtered and put into the corresponding subfolders by rules automatically. I immediately notice that there may be something wrong with my Outlook rules. Therefore, I try to click “File” -> “Manage Rules and Alerts”, but “Rules and Alerts” dialog box does not appear. Instead, I get another error message “Could not complete the operation. One or more parameter values are not valid”.

Now all of my rules stop working. I have to pick up hundreds of emails manually. That is a nightmare, especially when I need to do that every day. Therefore, I must fix the problem as soon as possible.

Diagnosis:

At the beginning, I thought the problem is caused by the Windows update, since my Outlook is fine just before the update. And Windows update has a reputation of introducing new problems to an existing stable system.

I have made a backup of the whole system, before the problem occurs. Therefore, that is my last resort to solve the problem.

Before doing anything, I try to contact Microsoft support. And they provide the following solutions:

  1. Use the “Repair” function in Office installer to repair Office, including Outlook.

Result: I try the solution but after the repair process, nothing changes.

  1. Create a new profile. Then recreate all the accounts for the profile and add the existing PST file to it.

Result: I try to create a new profile, create a test account, and then add the existing PST file to the new profile. Then I restart Outlook. This time I can start the rule manager. But all rules disappear. I cannot understand that since in Outlook 2010, the rules are stored in the PST file. Therefore, what I need to do is recreate all the accounts and rules, which is time consuming. Therefore, I finally discard this solution.

  1. For Outlook 2010, the rules are stored in the PST file. Therefore, the support thinks my PST file is corrupt and suggest me to repair it with scanpst.

Result: I don’t think the problem is caused by PST file corruption. To confirm my idea, I try to restore my PST file to an old version before the problem occurs with DataNumen Backup, then restart Outlook. The problem still exists. So, the problem should not be caused by the PST file, but a system update which changes the Outlook executable or dll files.

Deep Diagnosis:

I guess the problem may be caused by a conflict of my existing rules in PST file and the new updated version of Outlook. Therefore, I try to follow this article to write a small VBA code to delete all the rules in my PST file. However, whenever the code steps to the following line:

Set objRules = objStore.GetRules

I will still get a “Could not complete the operation. One or more parameter values are not valid” error again. So the problem jus prevents me from access all the rules via either GUI method or VBA codes. I have to seek other ways to solve the problem.

Solution:

Now based on the above analysis, there are two solutions for my problem:

  1. Restore the whole system to the time point before the system update occurs.
  2. Recreate a new profile, and recreate all the account and rules again.

Solution 2 is time consuming. Therefore, finally I decide to choose the first one, as follows:

  1. Unplug the network cable and disable the wireless network in my computer. To prevent the system from being updated automatically.
  2. Make a backup of the PST file since it contains some new emails after the update.
  3. Restore the whole system to the time point before the update occurs.
  4. Overwrite the old PST file with the new one backed up in step 2.
  5. Start Outlook.
  6. Click “File” -> “Manage Rules & Alerts”, this time the “Rules and Alerts” dialog box will pop up without any problems. And all the rules appear in it.
  7. There may be some rules in the PST file that conflict with the new system update. Since I don’t know which one cause the conflict, I choose to remove all of them.
  8. Re-plug the network cable and re-enable the wireless network in my computer.
  9. Check and perform system update manually. During the update, I can see there is an update for Outlook.
  10. After the update, restart Outlook and re-access the rules via “File” -> “Manage Rules & Alerts”, this time I can still access the “Rules and Alerts” dialog box.
  11. Add all the rules back.
  12. Everything is OK now even with the latest update of Outlook.

Conclusion:

The system update causes a conflict of the existing rules with the new updated version of Outlook. It is better for Microsoft to find a fix for that, or provide an option to remove the conflict rules. However, if none of them are available in a timely manner, we can still solve it by utilizing an old backup.

4 Comments so far. Join the Conversation
             

After inserting many comments in an Excel workbook, you may want to customize the fonts of all the comments. In this situation, you can refer to this article. Here we will share you 2 easy methods.

As we can see, the comments inserted in Excel automatically use the default font. At times, you may want to alter the comments’ fonts. If there are a few comments, you can simply use the following Method 1 to manually change them. However, if there are hundreds of comments, you are better off selecting the latter means.

Method 1: Change One by One

  1. First off, select a comment in the worksheet.
  2. Then, right click on it and select “Format Comment” from the context menu.

    Select "Format Comment" Menu Item

  3. Next, in the small popup dialog box, you can select fonts and styles to your liking.

    "Format Comment" Dialog

  4. Ultimately, click “OK”.
  5. Later, you can use this way to manually change comments one by one.

Method 2: Batch Change via VBA

  1. For a start, launch Excel VBA editor with reference to “How to Run VBA Code in Your Excel“.
  2. Then, in the “Microsoft Visual Basic for Applications” window, put the VBA code below into a project or module.
Sub BatchChangeFontsOfAllComments()

    Dim objWorksheet As Excel.Worksheet

    Dim objComment As Excel.Comment

   

    'Process all worksheet one by one

    For Each objWorksheet In ThisWorkbook.Worksheets

        If objWorksheet.Comments.Count > 0 Then

           For Each objComment In objWorksheet.Comments

               With objComment.Shape.TextFrame.Characters.Font

                    'Specify font name and size

                    .Name = "Comic Sans MS"

                    .Size = 10

                    'Use RGB function to create a color value

                    .Color = RGB(255, 0, 0)

                    .Italic = True

                    .Bold = True

               End With

           Next

        End If

    Next

End Sub

 

VBA Project

  1. Later, run this macro simply by pressing “F5” key button.
  2. Eventually, after macro finishes, back to the worksheets.
  3. As you can see, the fonts of all comments have been changed, as shown in the following screenshot:

Change Comment Font Result

Comparison

Advantages Disadvantages
Method 1 Quick and easy to process a small amount of comments Very troublesome in case of too many comments
Method 2 Very efficient regardless of the number of comments Increase risks of virus infection

Restore Compromised Excel File

When your computer suddenly shut down, if some Excel files haven’t been saved, the next time when PC boots back up, you may find the Excel files are corrupted. At this point, if you would like to get back the files, you have no choice but to take aid of a powerful and reliable Excel recovery tool, like DataNumen Excel Repair, which can recover corrupted Excel data with effortless ease.

Author Introduction:

Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including fix sql and outlook repair software products. For more information visit www.datanumen.com

             

Many users complain a lot about the pretty long time when they attempt to restore an iTunes backup to iPhone. Now, in this article, we will teach you how to fix it in 6 easy troubleshooting steps.

To avoid data loss, one of the most effective approaches is to back up data on a regular basis, no matter in terms of your computer or phone data. For example, when you encounter PST corruption, if you have backups, you can easily restore PST data without needs to repair PST file. However, at times, some troubles may occur when restoring backups. For instance, some iPhone users are disturbed by the issue that restoring iTunes backup to iTunes appears to take forever. Here we will guide users to fix it in 6 steps.

Restoring iTunes Backup Takes Very Long Time

Step 1: Disconnect iPhone

First off, you need to disconnect the iPhone from the computer. Please remove it safely instead of directly ejecting it violently. Otherwise, it’ll damage your iPhone without letting you know. One day, you may find some apps inaccessible or some files are compromised and so on.

Step 2: Upgrade iTunes

Then, you ought to check if the iTunes on your computer is the latest version. At times, the outdated iTunes may contain some vulnerable bugs, which can lead to the excessively long restoring time. Hence, in this step, you have to upgrade your iTunes application.

Step 3: Reboot iPhone & Computer

After that, you have to reboot both your iPhone and computer. It is because that the culprit may be the phone or computer itself. For instance, there may be too many processes running on your computer in the background, which leads to this issue. At this point, a simple reboot can assist you to eliminate such troubles with ease.

Step 4: Try iTunes Restore Again

At present, when iPhone and computer boots back up, you can retry to restore an iTunes backup to your iPhone. On the iPhone, launch “Restore from Backup with iTunes”. Then, connect iPhone to computer and let restoring backups go on to see if the problem persists.

Step 5: Restore iCloud Backups Instead

Assuming that iTunes backup restoration is still in such a dilemma, perhaps it is the time for you to consider the other iPhone backup features, such as iCloud. Do you have iCloud backups? If so, you can try to restore iCloud backups instead.

Step 6: Contact Apple Support

Last but not least, provided that you still persist to restore iTunes backups, you have no alternative but to contact the relevant experts, such as the official Apple support. They promise to provide users with free support in its warranty. Hence, you must be able to gain effective helps from them.

Author Introduction:

Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including sql fix and outlook repair software products. For more information visit www.datanumen.com