When I copy a spreadsheet into Microsoft Publisher, initially I will be able
to see all of the columns. However, once I try to size-down the spreadsheet
so it will fit on the page, columns disappear from the spreadsheet. I need
this spreadsheet to print landscape on a page with portrait headers and
footers. Word won't let me rotate the spreadsheet and it has the same
missing columns problem anyway. I'm trying to add this to a larger report.

Does the actual Excel file have to be entered into the Publisher/Word
document? Or just a representation of it?

What I'm thinking is that if you can get what you need to include displayed
on the screen in Excel, you could use a screen capture tool such as SnagIt,
IrfanView, PrintKey 2000 (search the internet for any of those) to capture a
..gif or .jpg of what you want and save it as a graphic file and then insert
the graphic file into the Publisher or Word document and size as required.
..jpg or .gif will give you good quality without the bloat overhead that a
..bmp from PrtScr would give you in your final file.

"Iceman" wrote:

When I copy a spreadsheet into Microsoft Publisher, initially I will be able
to see all of the columns. However, once I try to size-down the spreadsheet
so it will fit on the page, columns disappear from the spreadsheet. I need
this spreadsheet to print landscape on a page with portrait headers and
footers. Word won't let me rotate the spreadsheet and it has the same
missing columns problem anyway. I'm trying to add this to a larger report.

I tried capturing it before and wasn't really happy with the results. It's a
schedule going into a financial report and I was hoping to link it so I
didn't have to update it when things change. If I can get it to work, we can
possibly do our entire financial report in publisher.

"JLatham" wrote:

Does the actual Excel file have to be entered into the Publisher/Word
document? Or just a representation of it?

What I'm thinking is that if you can get what you need to include displayed
on the screen in Excel, you could use a screen capture tool such as SnagIt,
IrfanView, PrintKey 2000 (search the internet for any of those) to capture a
.gif or .jpg of what you want and save it as a graphic file and then insert
the graphic file into the Publisher or Word document and size as required.
.jpg or .gif will give you good quality without the bloat overhead that a
.bmp from PrtScr would give you in your final file.

"Iceman" wrote:

When I copy a spreadsheet into Microsoft Publisher, initially I will be able
to see all of the columns. However, once I try to size-down the spreadsheet
so it will fit on the page, columns disappear from the spreadsheet. I need
this spreadsheet to print landscape on a page with portrait headers and
footers. Word won't let me rotate the spreadsheet and it has the same
missing columns problem anyway. I'm trying to add this to a larger report.

Sorry. It was just a thought, but I can understand why an automatically
updated display would be more desirable. Any chance of using smaller fonts,
word wrap, other tricks in Excel to make the area to be displayed smaller?
Perhaps look at it from another layout angle? Like if you have totals at the
end of rows perhaps move those down and back under the rows that they are
totals for? Things like that. Sometimes the obvious escapes us: I had a
table recently that needed 16 columns and about 6 or 8 rows. It wouldn't fit
without landscaping the page (in a Word document) and I really didn't want
the one sheet in the document landscaped. I turned things on its side, and
made it 16 rows by the 6 or 8 columns and it fit very nicely on a regular
'portrait' layout sheet.

"Iceman" wrote:

I tried capturing it before and wasn't really happy with the results. It's a
schedule going into a financial report and I was hoping to link it so I
didn't have to update it when things change. If I can get it to work, we can
possibly do our entire financial report in publisher.

"JLatham" wrote:

Does the actual Excel file have to be entered into the Publisher/Word
document? Or just a representation of it?

What I'm thinking is that if you can get what you need to include displayed
on the screen in Excel, you could use a screen capture tool such as SnagIt,
IrfanView, PrintKey 2000 (search the internet for any of those) to capture a
.gif or .jpg of what you want and save it as a graphic file and then insert
the graphic file into the Publisher or Word document and size as required.
.jpg or .gif will give you good quality without the bloat overhead that a
.bmp from PrtScr would give you in your final file.

"Iceman" wrote:

When I copy a spreadsheet into Microsoft Publisher, initially I will be able
to see all of the columns. However, once I try to size-down the spreadsheet
so it will fit on the page, columns disappear from the spreadsheet. I need
this spreadsheet to print landscape on a page with portrait headers and
footers. Word won't let me rotate the spreadsheet and it has the same
missing columns problem anyway. I'm trying to add this to a larger report.