Replies

About 2 years back, I had posted (could not find that post) on the Lounge a description of a solution which allows service providers the freedom to generate the index at any stage of production, as long as all paragraphs are numbered; and new paragraphs inserted get further numbers. This is not an automatic Index generator, and needs input of professional indexers. It is not intended to be a substitute for the work of professional indexers.

The solution converts paragraph nos to page nos after the pagination has been frozen, and thereafter generates the index with the page nos., which allows the indexer to work without the time pressure usually associated with the indexing job (say after the first proof stage). Of course, in changing para nos to page nos, a certain amount of manual work is required, but the labour required is not smart labour.

There was sophistication in the solution in that the index entries could be upto 3 levels, and the solution allowed use of Greek and other special characters (by use of SGML entities) which might optionally be used to set the order in which the entries appear in the final index. This approach has worked flawlessly for an index comprising nearly 61,000 entries for an encyclopaedic reference work.

Could this be relevant to your needs?

The solution involves building the Index entries in Excel and generating the actual index in Word.

I am using Excel 9.0.2720 and succeeded in banishing the phantom by the follg method:
Refresh Pivot Table
Select the Phantom item from the page field

The moment I did that, the item disappeared. I have no logical explanation, but then it worked for me. Hope it does for you!

Add a column to the data range (named, say, Include?) and put in No for rows which you do not want included. Add Yes to all the others.
Expand the range of the Pivot Table to include this new column and take it in the Pivot Table layout as a page field. For this field, set Hide Item for “No”.

Not in Excel that I know of. However, StarOffice spreadsheet has a feature whereby the filter criteria can be saved to an ini file and independently modified and/or re-used.

Not in Excel that I know of. However, StarOffice spreadsheet has a feature whereby the filter criteria can be saved to an ini file and independently modified and/or re-used.

Office XP has a Save As XML option for Excel — the resultant XML File conforms to the MS Office DTD.

Office XP has a Save As XML option for Excel — the resultant XML File conforms to the MS Office DTD.

I suggest that you use the endnote feature and at the end of the text portion of the file, put a hard page break and create an extra page, on which the endnotes will begin to appear. When printing, do not print the range of pages on which the endnotes appear. Then, in Normal View, go to the View Footnotes and in the Footnotes pane, select all the endnotes and paste them to another file. You might have to reset the starting number of the endnotes in each chapter to ensure that the numbers across chapters do not overlap.

If you want a continuous single series of endnotes across, say, several chapters of a book to print as if they were a separate chapter, the easiest way of doing that is to Insert all the Chapters into a single file after all chapters are done. This will bring the endnotes of the whole book together in one place with continuous numbering. Then, do the same as above, and you can then copy the consolidated text of all Endnotes and put them into a single chapter at the end of the book.

Using the keyboard, the same effect can be had by applying Ctr-F11 and Ctrl-Shift-F11.

Selection.Fields.Locked = True locks the programmatically selected field, and setting the same to False unlocks it. This prevents updation of the field as well.

Use the TA filed to insert the ToA entries; then use the TOA field to generate the Table. If the Authorities need to be collected from more than one file, put the RD field and reference all the documents from which the TA entries have to be collected, and then at the end of all the RD fields, insert the TOA field and save the file as a separate file.

There is a complete thread giving a solution to this, and a link to an add-in. Hope this resolves your problem.

Please look at this thread for an elegant solution

Thanks very much, Klaus. I shall use kerning fearlessly.

Apologies for the late reply. Just read this thread now.

Have you tried rotating the text in an Excel worksheet cell(s) and then copying the cell(s) to the clipboard and then pasting it (using Paste|Special)into the Word file as an Excel Object? You get freedom to rotate to an exact extent upto 90 degrees at least.