Home → Troubleshooting → @RISK for Excel: Other Issues → "Object variable or With block variable not set"
Applies to:
@RISK for Excel 5.x–7.x
TopRank 5.7–7.x
When I click on an @RISK icon in the toolbar or ribbon, I get the error message
Object variable or With block variable not set
Or else, none of the ribbon buttons do anything, not even an error message.
This can be caused by manually adding the @RISK or TopRank toolbars. Never do that; instead, you should let our software manage them. Please run Excel and remove the toolbars that you manually added. The instructions vary according to your version of Excel:
In Excel 2007 or newer, click File » Options » Add-ins (or the round Office button and then Options » Add-ins). Look at only the active add-ins at the top of the page. If you see any "RiskExcel12" or "TopRankExcel12" add-in in the list, click Go at the bottom of the page, remove the check mark from that add-in, click OK, and close Excel.
If no such add-in is in the active list, or if the problem persists after you remove the check mark, right-click into the toolbar and click Remove custom toolbar. You may have to try clicking different places in the toolbar until the right-click menu offers that option.
In Excel 2003 or older, click View » Toolbars, uncheck the @RISK and TopRank toolbars, then click into your worksheet to make the menu go away. Close Excel.
To prevent this problem in the future, always launch our software through the desktop icon, if available, or through the Windows start menu. Click the Windows Start button, then Programs or All Programs » Palisade DecisionTools and select the application you want. You can do this whether Excel is already running or not; our application will launch Excel for you if it's not already running.
See also: There are other possible causes for this message. See All Articles about "Object variable or With block variable not set".
Last edited: 2016-06-24