Long footers in Excel 2000

[Andy Smith]

I'm trying to put a long legal disclaimer at the bottom of every printed page
on all the worksheets in my Excel 2000 workbook. A footer is the obvious way
to go, but after some research it seems 2000 can't do a number of the
solutions I've seen, e.g., a background graphic or a graphic within the
footer, and the limit for text is 255 characters.

On one page I've just copied a text box to appear slightly to the right of
every page break, because it's always the same number of rows (25) that
prints, but on other pages both number of rows and number of columns can get
quite large: 84 x 50,000 is the max. I know I can put it on the top left and
make rows and columns repeat, but that's not where clients want it -- it's
got to be the bottom -- and even the Report Manager can't do it.

I've seen a solution involving Word -- how would I go about implementing that?

 

[NickHK]

Andy,
No sure how practical it is for you, but a one-off solution I did once was
to put the paper through the printer twice.
Set up your <footer> layout on the WS so it prints correctly on your paper
size. Print out x sheets.
Set up your data WS with a large enough bottom margin to avoid the already
printed footer. Inserted the footer paper, print again.

If the footer is static (not connected to the data WS), this may be OK.
You can still have page numbers etc printing from data WS as normal, if
required.

A more robust solution may be to use Access reporting, with the data linked
from Excel.

NickHK

 

[Andy Smith]

Yeah, I saw the solution about putting the paper through twice. But this is
serious software for high-end financiers at brokerages and banks -- they're
not about to do that! The Access solution might be best, since there's
already an Access database in the background.