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

3 answers 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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


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.

  • Create New...