Microsoft KB Archive/300560

= XL: Error Message: Could Not Set ControlSource Property. Invalid Property Value =

Article ID: 300560

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 97 Standard Edition

-



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 ?

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:

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



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 (').

Additional query words: XL2002 XL2000 XL97

Keywords: kberrmsg kbprogramming kbprb KB300560

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.