XL: Error Message: Could Not Set ControlSource Property. Invalid Property Value (300560)


The information in this article applies to:

  • Microsoft Excel 2000
  • Microsoft Excel 2002
  • Microsoft Excel 97 for Windows
This article was previously published under Q300560

SYMPTOMS

When you try to set the ControlSource property for a control, you receive the following error message:
Could not set ControlSource property. Invalid property value.
-or-

When you try to include a pipe (|) character in the ControlSource property, you receive the following error message
Remote data not available. Start application <XXXXXX.exe>?
followed by:
Could not set ControlSource property. Invalid property value.

CAUSE

These error messages occur when you include one or more of the following characters when you set the property, and you do not enclose the sheet name in apostrophes:

! @ # $ % ^ & () + = ; " ' < , > . [] {} |

WORKAROUND

To work around this issue, rename your sheet to include only alphanumeric characters and the underscore (_) character, or enclose the sheet name in apostrophes (').
Modification Type:MinorLast Reviewed:10/10/2006
Keywords:kberrmsg kbprb kbProgramming KB300560
©2004 Microsoft Corporation. All rights reserved.