renumber sheets

[nostupidquestions]

is there a way to renumber sheets in the sheet set manager? i've got over 100 sheets and i need to insert some new sheets in the middle. there wasn't a way in 2009 but i was hoping for something in 2012. it seems like something that would be included by now.

[Jonathan3891]

It will not automatically renumber them, but you can go in sheet set manager and change the sheet numbers.

[nostupidquestions]

thanks for the reply. i guess i should have included a 'quickly' or 'automatically' in my post in regards to renumbering. renumbering each sheet takes forever.

[rkmcswain]

Nothing built in as you have seen (not sure why after all these years...)

But given enough programming knowledge, it's certainly possible to roll up your own routine.

We have such as tool and it pays for itself every time it is used.

[troma]

How does this work if you have sheets numbered:

01

02

03-A

03-B

04

05

?

Or do you just avoid this type of numbering?

[nostupidquestions]

i got one somewhere several years ago but it doesn't work with 2012.  i agree that this feature should be included.

[Jeff_M]

There's also some 3rd party help if it's something you need.

[Joe-Bouza]

Nothing against SincPac, my favorite is SSMproperetieseditor at JTBworl dot com

and it more than renumbering

[rkmcswain]

---

@troma wrote:

How does this work if you have sheets numbered:

01

02

03-A

03-B

04

05

?

---

Our numbering is usually very simple (1, 2, 3, 4, etc) - so our routine simply starts with the first sheet (1) and then numbers the rest sequentially. It also updates a custom property with the total number of sheets since we have a field that references that.

[marcobee]

How can i make sure that my sheets are numbered in a good order considering that am using different files (i have set 5 sheets for each file). The other issue i want to ask is if there there is automatic way of editing datum for profile because i take much time to go through each sheet changing datum

[Joe-Bouza]

You have to order the sheets in SSM then sequetially number them

http://www.jtbworld.com/SSMPropEditor.htm

[Joe-Bouza]

Jimmy's routine handles prefixes and suffixes

http://www.jtbworld.com/SSMPropEditor.htm