Jump to content
  • 0

Updating all Worksheets in a file



14 answers to this question

Recommended Posts

  • 0

Try this script. It should do what you want. Be careful, you could make a bunch of complicated WSs and it could take a very long time to recalculate them.


You can make the script into a menu command you can add to your workspace using the directions in this thread.

Procedure RecalcAllWS;
{January 14, 2021}
{©2021 Patrick Stanford pat@coviana.com}
{Licensed under the GNU Lesser General Public License}

{No Warranty Expressed of Implied. Use at your own risk.}

{Recalculates all worksheets in the Resource Manager of the active}
{file and redraws to update any that are On Drawing}

Var	H1:	Handle;
	ResList, NumWS, WSIndex:	LongInt;

	ResList:=BuildResourceList(18, 0, '', NumWS);

	For WSIndex := 1 to NumWS do



  • Like 1
Link to comment
  • 0
1 minute ago, Pat Stanford said:

What no keyboard shortcut!!!!  All that work and you don't even think enough to give it a shortcut.  Humph! 😉

You assume I would remember the shortcut. I won't! But I will remember where I put the command. Even so, I'm using the contextual menu now that I moved "Properties" up in the contextual menu and that moved Recalculate to the top of that menu. That is the easiest solution, granted it's not a recalculate all worksheets command.

Link to comment
  • 0
6 hours ago, rbryanharrison said:

I'd bake cookies for a version that recalculates only the active worksheet.  I just want to hit a keyboard shortcut rather than endlessly choosing "File > Recalculate Active Worksheet."

I would be very much interested in that one too.


6 hours ago, Bruce Kieffer said:

You can right click to get the contextual Manu and it should appear there. It does on my setup.

Screen Shot 2021-08-26 at 8.51.03 PM.png


@Bruce Kieffer What I can see 'Recalculate' function update all worksheets not only selected one. And with many worksheet present in file it can take a while to update.


Would really welcome quicker way to navigate to recalculate active worksheet function.




Link to comment
  • 0
On 8/27/2021 at 3:47 AM, rbryanharrison said:

I'd bake cookies for a version that recalculates only the active worksheet.

I think right-click method is nearly as fast as shortcut but if theoretically someone is interested in the update-selected-script-variante.

#DomC 2022-09-17 Use at your own risk
#Recalculates selectes worksheets on the active layer.
#Worksheets with the same names were also recalculated, even if 
#they are not on the same layer and/or are not selected

selected_worsheets = []
def add_handle(h): 

vs.ForEachObjectInLayer(add_handle, 2, 1, 0)

for worksheet_insctance_handle in selected_worsheets:
	sheet_resource_handle = vs.GetWSFromImage(worksheet_insctance_handle)
Link to comment

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.

  • Create New...