Office 2004 problem

[Brandur Ellingsgaard]

I've just bought Office 2004 and it is great! I do have a question though:
I've tried to create an invoice in Word. First I insert an Excel worksheet
where I can format the cells, so they add the right numbers automatically.
That's no problem, but it seems that the worksheet I insert into Word only
includes the top 10 rows. My worksheet is 34 rows, but as I said, only the
top 10 rows appear in the word document.

Can any one help me with this? Alternatively can anyone tell me about
another way to format cells in word, so I can make an invoice which can
calculate the sums automatically?

Cheers

Brandur

 

[Jim Gordon MVP]

Hi,

The Excel window in Word won't grow to the expanded size of your workbook
automatically.

I don't know the steps you took, but try these:

From Word's menu choose Insert > Object > Microsoft Excel Chart (not
workbook).
When Excel opens use Edit > Delete Sheet. You'll have just the same data
worksheet.
Use File > Close and return to document
At this point you have an embedded Excel worksheet in your Word document.
Double-click the worksheet to bring it back in Excel
Add a bunch of rows and or columns to the workbook.
Use File > Update
Then use File > Return to document
You can now drag the corners of the embedded object to expand to the new
dimensions of the workbook's area.

Is this sorta what you are looking for?

-Jim

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[Brandur Ellingsgaard]

Hi Jim,

It worked absolutely perfect! Thank you so much. I should have suspected
that a tweaky way had to be the answer in a Microsoft app If you do it
by the book, it doesn't work, but there are paths unknown to most people,
that can lead to Paradise

Cheers
Brandur