Excel to Publisher

[Jeanette]

My document has already been created in Excel. It's about 60 pages in five
tabs. Income Statement presented monthly over six years 2005 thru 2010;
Balance Sheet same time period; Cash Flow Statement same time period;
Construction Schedule, same time period. The Excel docs are nicely formatted
as you would see in a financial presentation, but my partner is adamant on
having it in presented in Publisher. I have been trying for three days to
convert/import/export the Excel sheets into Publisher to no avail. It looses
pages, it looses formatting. I have never in my professional life presented
a financial report in Publisher, and I have never seen anyone in the
financial industry use Publisher to present their financial reports, but my
senior partner wants it done in Publisher. I don't know how to do it. Does
anyone know how?

 

[JoAnn Paules [MSFT MVP]]

Have you tried saving it as a .jpg and inserting that?

 

[Rob Giordano \(Crash Gordon®\)]

Did you try Copy/Paste?

I just tried it on some balance sheets I had in Excel...Copy/Paste, then resized in Publisher...no problem...only thing that happened was Arial font changed to Courier...so I just switched it back. Not sure why your partner wants it done in Publisher, seems like extra work.



| My document has already been created in Excel. It's about 60 pages in five
| tabs. Income Statement presented monthly over six years 2005 thru 2010;
| Balance Sheet same time period; Cash Flow Statement same time period;
| Construction Schedule, same time period. The Excel docs are nicely formatted
| as you would see in a financial presentation, but my partner is adamant on
| having it in presented in Publisher. I have been trying for three days to
| convert/import/export the Excel sheets into Publisher to no avail. It looses
| pages, it looses formatting. I have never in my professional life presented
| a financial report in Publisher, and I have never seen anyone in the
| financial industry use Publisher to present their financial reports, but my
| senior partner wants it done in Publisher. I don't know how to do it. Does
| anyone know how?
| --
| Jeanette

 

[Jeanette]

Can't save an excel file as a jpg.

Besides, the excel file is 60 pages of financial tables througout four tabs.
I spoke w/a financial printer last week, and they use a file converter
called "v-file" to convert the file to tif and then to the program they use
for printing their financial books, and that's even a big task. They don't
use Publisher. No financial company uses Publisher. My partner is not a
finance guy, he's an aviation engineer, and he's dead set on using Publisher.
I can't figure it out, and I don't know how to win in this disagreement.
Since you're a Publisher MVP, do you have any suggestions?
--
Jeanette

Have you tried saving it as a .jpg and inserting that?

--

JoAnn Paules
MVP Microsoft [Publisher]

My document has already been created in Excel. It's about 60 pages in
five
tabs. Income Statement presented monthly over six years 2005 thru 2010;
Balance Sheet same time period; Cash Flow Statement same time period;
Construction Schedule, same time period. The Excel docs are nicely
formatted
as you would see in a financial presentation, but my partner is adamant on
having it in presented in Publisher. I have been trying for three days to
convert/import/export the Excel sheets into Publisher to no avail. It
looses
pages, it looses formatting. I have never in my professional life
presented
a financial report in Publisher, and I have never seen anyone in the
financial industry use Publisher to present their financial reports, but
my
senior partner wants it done in Publisher. I don't know how to do it.
Does
anyone know how?

 

[Jeanette]

Copy and Paste doesn't work. The file is way too big 1,483 KB. I have over
40 pages of Excel sheets in my workbook and there are another 60 pages in
another workbook 2,000 KB. Nothing has worked so far. My partner is not a
finance guy, he's an aviation engineer and he doesn't like how Excel and Word
look in a book presentation, he likes Publisher and he's firm on having this
Excel report converted to it. I'm stuck between a rock and a hardplace. Any
suggestions? I'm in Vegas.

 

[Mary Sauer]

Publisher is not the best program for what you are trying to do. You could do a
screen capture of each page.
SnagIt is an excellent choice, it will save in any format. Simple to use with good
clear output. There is a trial download.
http://techsmith.com/products/snagit/default.asp

You might do a copy/paste to Word and then copy/paste again to Publisher. Lots of
work.

Try insert, object, scroll down to Microsoft Office Excel Worksheet, Publisher will
create a worksheet, copy the cells in your Excel chart, (Open the clipboard, edit,
Office clipboard) paste the cells. The Office clipboard will hold 24 entries.

 

[JoAnn Paules [MSFT MVP]]

I had a spreadsheet I put in my newsletter but it was only three pages. I
converted it to a .pdf and then to a .jpg. (I honestly forgot about that
middle step - it's been a year since I did it.) I don't think I'd enjoy
doing 60 pages of it. And then, of course, it's not editable.

--

JoAnn Paules
MVP Microsoft [Publisher]

Can't save an excel file as a jpg.

Besides, the excel file is 60 pages of financial tables througout four
tabs.
I spoke w/a financial printer last week, and they use a file converter
called "v-file" to convert the file to tif and then to the program they
use
for printing their financial books, and that's even a big task. They
don't
use Publisher. No financial company uses Publisher. My partner is not a
finance guy, he's an aviation engineer, and he's dead set on using
Publisher.
I can't figure it out, and I don't know how to win in this disagreement.
Since you're a Publisher MVP, do you have any suggestions?
--
Jeanette

Have you tried saving it as a .jpg and inserting that?

--

JoAnn Paules
MVP Microsoft [Publisher]

My document has already been created in Excel. It's about 60 pages in
five
tabs. Income Statement presented monthly over six years 2005 thru
2010;
Balance Sheet same time period; Cash Flow Statement same time period;
Construction Schedule, same time period. The Excel docs are nicely
formatted
as you would see in a financial presentation, but my partner is adamant
on
having it in presented in Publisher. I have been trying for three days
to
convert/import/export the Excel sheets into Publisher to no avail. It
looses
pages, it looses formatting. I have never in my professional life
presented
a financial report in Publisher, and I have never seen anyone in the
financial industry use Publisher to present their financial reports,
but
my
senior partner wants it done in Publisher. I don't know how to do it.
Does
anyone know how?

 

[Frank]

My document has already been created in Excel. It's about 60 pages in five
tabs. Income Statement presented monthly over six years 2005 thru 2010;
Balance Sheet same time period; Cash Flow Statement same time period;
Construction Schedule, same time period. The Excel docs are nicely formatted
as you would see in a financial presentation, but my partner is adamant on
having it in presented in Publisher. I have been trying for three days to
convert/import/export the Excel sheets into Publisher to no avail. It looses
pages, it looses formatting. I have never in my professional life presented
a financial report in Publisher, and I have never seen anyone in the
financial industry use Publisher to present their financial reports, but my
senior partner wants it done in Publisher. I don't know how to do it. Does
anyone know how?

Suggestion:
Instead of converting excel to publisher why not convert boss to excel.
Frank

 

[CyberTaz]

Hi Jeanette-

Just one more voice into the mix to echo the sentiments of others.

Copy & Paste or OLE are the most feasible options _if_ there is some
specific reason a Pub file needs to be created. However, each page in the
..xls would have to be individually copied & pasted (using Paste Special) or
named as ranges & embedded into Publisher one at a time. Even then, any XL
Headers & Footers will not be included, nor will any instances of 'Rows to
repeat at top' or 'Columns to repeat at left'. Quite honestly, I would prefer
to just import the data and restyle the report from the ground up than either
of these options.

The point that "he doesn't like how Excel and Word look in a book
presentation" is not very specific, but suggests one or both of two
perspectives:
1) Print Quality (Clarity/'sharpness'), or
2) Facing Page layout capability to accomodate binding.

Outputting from a Publisher file will add little, if anything, in the former
case. That is ultimately determined by the printing process/device.

In the latter case, the other formatting/layout issues you are encountering
are a high price to pay for facing-pages and would most likely result in an
even less satisfactory appearance.

If a professional printed result is the intended goal, IMHO, outputting to a
..pdf is the most cost-effective & realistic choice, and leave the book-type
layout to your printing service.

Best of Luck |:>)

 

[JoAnn Paules [MSFT MVP]]

Or convert to an excellent boss. ;-)

 

[Jeanette]

No. Copy and past doesn't work, not with a file that big. We figured it
out. Whoever suggested tif, was correct. I just don't have that feature on
my computer, but it was on one of my partner's computers, so it was done.
All 90 excel pages were easily copied into Publisher, but it had to be
exported into a tif file first and then copied from there. No formats or
data were lossed. It had to be done one page at a time, and it looks very
good.

 

[Mike Koewler]

Jeanette,

You do realize you will not be able to edit the data in the Pub file
now, right?

Mike