Recalculate multiple worksheets

[CS1]

If I have a worksheet on my page to recalculate I can right click on the worksheet and click recalculate.

What if I have 100 worksheets through out my file?

If I do a Custom Modification I can change the attributes of the worksheets but cant recalculate.

[Pat Stanford]

Check out this thread:

http://techboard.nemetschek.net/ubbthreads/ubbthreads.php?ubb=showflat&Number=96413&an=&page=

Pat

[Hugues]

Hi CS1,

the recalculate command in the right click menu recalculates all worksheets throughout your file.

You don't have to use a script unless you just want a particular set of worksheets to be recalculated.

Hugues

NNA

[Pat Stanford]

Just to clarify.

If you right click on a worksheet and select Recalculate from the contextual menu, every worksheet in the drawing will be recalculated. I was not aware of this.

Perhaps that item should be renamed to Recalculate All WS or something. All the other contextual menu options only work on the active object. Probably not a problem, but could be an issue for some people.

Pat

[Laura Stone]

We have lots of worksheets on our drawings and generally only want to update one at a time as it otherwise can take up to an hour. Is there a way of doing this?

Laura

[Pat Stanford]

1. If you have the worksheet in the drawing, right (ctrl) click on the worksheet image and select Recalculate from the contextual menu.

2. If you have the worksheet in Edit mode, just select Recalcuate from the pulldown menu (triangle) above the row headers.

Pat

[Laura Stone]

As far as I can work out these two methods recalculate all of the worksheets, I only want to recalculate the one I have open, or even better only one cell.

Is there any way of doing this?

[Pat Stanford]

Alright, if you want to be difficult about it try this: ;-)

Create a new Vectorscript and paste in the following two lines. You don't need begin end or anything other than these two lines. After you save the script, it will recalculate only one worksheet and only if it the worksheet image is the first selected object on the active layer.

RecalculateWS(GetWSFromImage(FSActLayer));

ResetObject((FSActLayer));

Pat

[CS1]

the recalculate command in the right click menu recalculates all worksheets throughout your file.

You don't have to use a script unless you just want a particular set of worksheets to be recalculated.

When I right click that option is not present, I have been in to my workspace and searched "all menu items" and cant find anything that resembles "recalculate" that I can add to my list of right click options.

[Laura Stone]

Thanks Pat - that works perfectly.

Laura

[Hugues]

the recalculate command in the right click menu recalculates all worksheets throughout your file.

You don't have to use a script unless you just want a particular set of worksheets to be recalculated.

When I right click that option is not present, I have been in to my workspace and searched "all menu items" and cant find anything that resembles "recalculate" that I can add to my list of right click options.

Make sure you are right clicking on a selected worksheet image.

[Hugues]

Hi Laura,

Here is another tip if you are working with large files and large worksheets that take time to recalculate.

If you are editing a worksheet and you don't want it to automatically recalculate everytime you enter a cell, you can turn off the Auto-recalc preference for that worksheet.

Just open the worksheet preferences dialog and uncheck the Auto-recalc check box. Editing a cell will now just update that cell and you can manually recalculate the worksheet later on.

Hugues

NNA