Jump to content
  • 0

Recalculate worksheet command without clicking on worksheet?


Hi All,

Is there a way to recalculate worksheets without actually having to select a worksheet and right-click to choose recalculate? I've searched for the command in the workspace editor with no luck.


Thanks, Scott

Share this post

Link to post

1 answer to this question

Recommended Posts

  • 0

As far as I know there's no built in command. You can write a script to do it though. I've got one to recalculate all worksheets in a file, but you could modify it to do just one specific instance by name. Vectorscript below. I set it up as a Plugin so I could make it a custom menu item. I borrowed and adapted this from someone else's work, so it's possible it could be simplified. Hope this helps.




{Recalculate all worksheets in file}
Procedure WSrecalc;

foundObject: handle;
objname :String;
i, n : integer;
OK : boolean;

function DoRecalc (h : handle) : Boolean;


	For i := 1 to n do begin
		foundObject := GETOBJECT(NAMELIST(I));
		If GETTYPE(foundObject) = 18 Then ok := DoRecalc(foundObject);
Run (WSrecalc);



Share this post

Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114


© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.