To create a book in word you can use "includes" to build the different phases
of the book. I am creating a multiple page census report in excel, the
bigger it gets the more it crashes, can I make separate files and use
something like "includes" combine all pages in printed copy of the book.
Mary Ellis

IF???
you mean you are creating multiple pages of the same thing with different
data you should consider using a macro to populate ONE report and print from
there. A looping macro could do all.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mary Ellis" wrote in message
...
To create a book in word you can use "includes" to build the different
phases
of the book. I am creating a multiple page census report in excel, the
bigger it gets the more it crashes, can I make separate files and use
something like "includes" combine all pages in printed copy of the book.
Mary Ellis

What I am doing is this. If you look at each form for the US Census
every one is different (10 year span between census')
I have started at the earliest, 1790, and have followed a family
through to the 1930 census so I have a different form for every 10
years (except for 1890 that year is missing from the National
Archives) anyway, some years can be 18-20 pages more or less when
paginated for print ... I finally made a pdf file from the last excel
book and it was 187 pages.
This excel workbook crashed numerous times, one of those times I
started wondering if excel uses 'Includes' like Word does..
I don't understand the loop idea you mentioned since the names, dates,
ages, people and all other data can change and will change from each
census record.

Thanks again for the reply...
Mary




On Dec 24 2008, 8:45*am, "Don Guillett"
wrote:
IF???
you mean you are creating multiple pages of the same thing with different
data you should consider using a macro to populate ONE report and print from
there. A looping macro could do all.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Mary Ellis" wrote in message

...

To create a book in word you can use "includes" to build the different
phases
of the book. *I am creating a multiple page census report in excel, the
bigger it gets the more it crashes, can I make separate files and use
something like "includes" combine all pages in printed copy of the book..
Mary Ellis

I went here and don't see what you are talking about.
http://www.census.gov/
Perhaps you can tell me or send your workbook for a look.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...
What I am doing is this. If you look at each form for the US Census
every one is different (10 year span between census')
I have started at the earliest, 1790, and have followed a family
through to the 1930 census so I have a different form for every 10
years (except for 1890 that year is missing from the National
Archives) anyway, some years can be 18-20 pages more or less when
paginated for print ... I finally made a pdf file from the last excel
book and it was 187 pages.
This excel workbook crashed numerous times, one of those times I
started wondering if excel uses 'Includes' like Word does..
I don't understand the loop idea you mentioned since the names, dates,
ages, people and all other data can change and will change from each
census record.

Thanks again for the reply...
Mary




On Dec 24 2008, 8:45 am, "Don Guillett"
wrote:
IF???
you mean you are creating multiple pages of the same thing with different
data you should consider using a macro to populate ONE report and print
from
there. A looping macro could do all.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Mary Ellis"
wrote in message

...

To create a book in word you can use "includes" to build the different
phases
of the book. I am creating a multiple page census report in excel, the
bigger it gets the more it crashes, can I make separate files and use
something like "includes" combine all pages in printed copy of the book.
Mary Ellis